Xata

X

Xata

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

Join

help

general

Hey, hi! Anyone know if Xata is

Hey, hi! Anyone know if Xata is compatible with the TigerData (formerly Timescale) BSL ? Perhaps, at least, in the BYOC offering ?

Hey everyone, love Xata - regrettably

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?

Hi 👋

Hi 👋 Congrats on the new release! 🚀 Will there be basic support for files and search on the new platform? We enjoy having the built-in solutions you provide. It's a perfect fit for our app (file uploading is secondary but we didn't have to setup anything on our own with Xata). If not, do you have any recommendations for alternative services? With a similar ease-of-use (DX- / setup-wise) and feature set?...

did you solve this?

did you solve this?

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?

Connections

Hi! Is anyone else having problems connecting through postgres? I see my database just fine on the website but all the connections on various automations that I have are being rejected.

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

is that a prank ?

is that a prank ?
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
Next