Xata

X

Xata

This is Xata's community Discord server, where we discuss all things Xata: projects, features, dreams!

Join

help

general

ask ai

Hi, I have a bug with my code, when I add sessionId to the options, I receive error (invalid key [rules] in request). It works when I remove rules and searchType ```js...

Support for Xata early access?

I'm having some issues with extensions for Xata on early access, I'm unable to load postgis extension. SELECT * FROM pg_available_extensions; returns 47 results but postgis is not in there....

Trouble loading data in Xata Lite UI

Hi, I'm trying Xata Lite for a upcoming project. The UI doesn't render if the table have no primary key. I'm creating tables in db through direct connection. Is Xata planning to support this view in upcoming updates?

Do you block servers from connecting?

I'm having a problem where the scripts located in one of my servers won't connect to Xata, but all other scripts in other servers do. I'm getting this error on the log: PHP Warning: pg_connect(): Unable to connect to PostgreSQL server: could not translate host name "us-east-1.sql.xata.sh" to address: Name or service not known in /home/whazzer/public_html/vecino-seguro/servicios/sesion.php on line 13...

Migrating data from A DB in one workspace to another DB in another workspace breaks my app

My workplace contracted third parties to help quickly build a CMS because we have so much on our plate. We used Xata, and can’t invite them to our main workspace because data privacy reasons. Now the project from 3rd party has been delivered, it works on their workspace -> database, but we want to have this on a db in our main workspace. I tried xata dump -f schema.json and xata init —schema.json, but got error about incorrect format. Since both DBs are native PG DBs, i ran pg_dump and pg_restore, which worked with some errors To use the database from our main workspace, should be straightforward, i removed old Xata files, and ran xata init and later xata pull to set up the project with the intended db. This worked, but breaks so may others things, id and xata_id no longer being “aliased”...

Xata with commercial pg extensions.

Hi, I'm JP from Agenta (https://agenta.ai) and we're interested in postgres at scale, alongside other commercial extensions like the once from TigerData (formerly Timescale). How can we benefit from the benefit of both Xata and TigerData while not breaching TigerData's licensing model ?

Trouble with branch copy

Hi 👋 We are having trouble copying a branch on Xata Lite. A certain migration is not run Workspace ID:...

Do dedicated clusters scale to zero when DB is idle?

We are using Xata for our app and I've just purchased the Pro plan before going live as the shared cluster on free tier keep throwing "out of memory" error every once in a while despite very minimal use. When provisioning a cluster, I see the pricing calculator predict a monthly cost of $53.29 for 1 x db.t4g.medium. This is true if my instance runs 24/7 for the whole month. However, since Xata is serverless, my understanding is that the instance will shut down once idle for a certain period of time, and thus this $53.29 would not be billed if there are significant periods of idle time throughout the month. Just wanted to know if the above assumption is correct or $53.29 is the fixed amount you'll have to pay per month anyways for 1 x db.t4g.medium?...
No description

Hey, getting error while trying to access a table.

{id: "b93bbb94-3836-9e55-8d7d-f9608f77d239", message: "json: unsupported value: NaN"} Please have a look....

Are there any elegant solutions to handling external connections if your DB is not Postgres enabled?

Hey everyone, love Xata - regrettably didn't realize I had to opt in for the native Postgresql wire initially when creating a database so my long lived prod instance does not use the native wire and thus I am finding that replicating any of the data outside of Xata is a bit of a chore as postgres event handling is not an option for me. Does anyone have any good ideas, resources or a direction to point me to find a way to thoughtfully expose my data to external platforms without polling?

How to disable postgress?

I keep getting an error in n8n when trying to connect a new xata database that says "Error in sub-node ‘Xata‘ this endpoint works only with non postgres enabled branches" when I connected via api and I used the HTTP end point URL not the PostgresSQL Url and there are no other settings in my database for enabling or disbling postgres, nor are there any options to enable or disable postgress when I create the database either. The only branch available to me is "main" so I don't understand why I am getting this postgres enabled error...

General questions for multitenant SaaS

Hi, I have multiple questions: 1. What is structure of Xata - workspace -> clusters -> databases? 2. How many databases can be in one workspace/cluster?...

Unable to start a pgroll migration using the Xata CLI

Hi 👋 I'm having trouble starting a pgroll v0.11.1 migration using the Xata CLI. The error I get is:...

COPY statement

im using this query: COPY profiles FROM '${profilesWithAudience} and im getting this:...
No description

Are indexes possible on free tier?

When I attempt to create an index in the dashboard it returns an error stating that the table doesn't exist even though it's been created and seeded. Script CREATE INDEX IF NOT EXISTS idx_vehicle_plate ON citations(vehicle_plate); ...

Is there a way to move files between branches?

Hi 👋 I was wondering if there's a way to move/copy over files when moving data from one branch/db to another. AFAIK, I think the only way is to run a script which downloads from the source records and re-uploads to the target column. Is there a better way?...

regclass error

I'm trying to deploy a MedusaJS(commerce platform) instance using Xata. There is an error during the migration process: MedusaJS tries to run: ```sql...

issue with build when specifying OLLAMA_ENABLED=1

Collecting page data ..Error: No providers enabled. Please configure API keys at <unknown> (.next/server/chunks/7078.js:1:2183) at 12900 (.next/server/chunks/7078.js:1:2394) at t (.next/server/webpack-runtime.js:1:143) at 25207 (.next/server/chunks/7640.js:1:144)...

Get Xata system fields with kysely

I am using kysely adapter. How do I get xata system columns. xata.updateAt etc. It's automatic with the xata sdk but seems impossible with the kysely adapter
Next