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.
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
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

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?