Xata

X

Xata

Join the community to ask questions about Xata and get answers from other members.

Join

help

general

Working with Postgis

Hi all. I'm looking to work with Postgis, in order to store event location data and return search results based upon proximity to device geolocation and Google Maps data. Web, docs, Xata bot and Discord searches are all turning up a blank. Not sure where to begin, or if I should be considering a different approach? Any guidance to get me started appreciated.

I can't really connect to the DB does

I can't really connect to the DB does anyone have any idea?

Could you help me, please? My database

Could you help me, please? My database simply disappeared during the development of a platform, everything was fine and seconds later I received countless errors stating that the database doesn't even exist... https://discord.com/channels/996791218879086662/1344707939163967590...

Hi, the code and types files don't auto

Hi, the code and types files don't auto generate as usual when run Xata init or Xata pull main

Good day everyone,

Good day everyone, I am unable to access some of my database on my account...

The workspaces I am working on, are all

The workspaces I am working on, are all pro but my account itself isn’t pro, could this be the issue?

Connect to Postgres

i seem to be unable to run this query in the dashboard
ALTER TABLE cards ADD COLUMN "index" SERIAL PRIMARY KEY;
ALTER TABLE cards ADD COLUMN "index" SERIAL PRIMARY KEY;
...

Links

From the ui, I can create a new column that's a link to another table. However, this new field pulls all the fields from the linked table. How do I disable that? Basically all I want is this behavior in sql:
column text not null references "user" ("id")
column text not null references "user" ("id")
...

were options like `start`, `end`,

were options like start, end, after and before removed from pagination options?

Hi, I am having issues restoring data

Hi, I am having issues restoring data from an sql using psql on a postgres enabled database the error i am getting is ERROR: role "postgres" does not exist

Hey guys, I tried to run kysely

Hey guys, I tried to run kysely migrations via xata dialect, but I get this error Migration failed with Error: Transactions are not supported yet. . Does it mean that I have to connect directly? We need inheritance so we have to run raw query. Tried to connect directly, run sql script and everything works fine, we just want to run these queries from code. My guess is that we have to connect directly here as well.

Hey, I got xata working with kysely on

Hey, I got xata working with kysely on cloudflare workers, but I've got few questions. On cloudflare you're supposed to create new instance (db connection) every time function is evoked. Kysely docs state that you should destroy such instance, but your docs/example with cloudflare doesn't mention it. Does the client keep the connection open and should I destroy it? I guess the destroy function of kysely instance would free memory as well, but I think it's not relevant in case of cloudflare as th...

Good day everyone, there is a little UI

Good day everyone, there is a little UI bug in the Schema View
No description

Region

Is there any particular reason why ap-southeast-2 is the only region that can't be postgres enabled yet? I have a AU client who I'm using non postgres for and would like to migrate to postgres enabled but don't really want to use a different region

Generated url

Hey folks does anyone know how we can remove the database url in xata.ts file after running xata codegen it will automatically add database url in new generated file. I am using old xata client not the xata next cli.

Can anyone share me the docs for

Can anyone share me the docs for exporting the data from the database.

do you know how we can create enum in

do you know how we can create enum in schema.json or do we have to use string type only @1benw

Does anyone have an automation to

Does anyone have an automation to replicate a non Postgresql xata db into a Postgressql xata db?

Is there any updates on this?

Is there any updates on this?
Next