Xata

X

Xata

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

Join

help

general

Query Table Data

The formatting on this page https://xata.io/docs/api-reference/db/db_branch_name/tables/table_name/query#pagination is hella broken for me. Tried on a couple browsers to make sure it was not just firefox.

Hi, just one small thing:

Hi, just one small thing: In the docs for the Postgres connection string, the examples are missing ?sslmode=require. Which results in all the clients/apps (cli, drizzle, or apps) to get a dropped connection (hangs). The connection string in the admin panel however, has the query param and is working flawlessly. I suggest including the search query of the url in the docs and maybe even mention that we can just copy-paste it in the db settings in the admin panel....

there any option to change field type

there any option to change field type after is created ?

hi one question, the xata_id its always

hi one question, the xata_id its always a string? it could not be like 1 2 3 4 5 6 ?

hi im just testing xata, i need to

hi im just testing xata, i need to create a inventory management system for my business, you guys recommend me xata? xata have branches? like one branch for dev and another for staging and one for prod?

Wink wink. Day 4 of our Easter Egg hunt!

Wink wink. Day 4 of our Easter Egg hunt! Riddle: What programming language was pgzx built for? Know the answer? Fill out the form for a chance to win a Meta Quest 3...
No description

Hi,

Hi, How do i delete a file from a record? When I delete the file from Xata app UI, and i refresh the page, the file reappears. I was testing a feature to update images on a Nextjs app and at first, I thought maybe it was Nextjs aggressive caching behavior but replacing the current file in the record with ANY file works both on the Nexjs app and Xata UI (I have no problem with that) but trying to delete it both from Xata's UI and my app fails....

specifically, creating new branches?

specifically, creating new branches?

Hi,

Hi, I am working on a project on behalf of someone who is not a developer. I may have started the development with my personal account and so the db is linked to account. How easy is it to migrate the db from my account to their account. Should I stop and refactor now or is there any easy way to switch to their account during deployment and for production ?...

Hi, Does Xata have any support for

Hi, Does Xata have any support for LISTEN or NOTIFY

Hey alexf, thank you!, currently I am

Hey alexf, thank you!, currently I am using xata in a side project just waiting for features that are on roadmap like pg_dump and pg_restore so I can import my data, great product tho :xatafly:

Actually Cockroach doesn't support this

Actually Cockroach doesn't support this feature, which tbh makes support here potentially simpler. You could just treat malformed postgres versions as <15 and should be good to go. I can throw together a PR if it's helpful...

Hey guys, quick question, is the vector

Hey guys, quick question, is the vector column same as a "Vector" database or is it completly different?

Hey minester16 recursion in the TS SDK

Hey @minester16 , recursion in the TS SDK is indeed limited to two levels (so it will go up to currentTable.two.three). We created an issue in the client-ts repo https://github.com/xataio/client-ts/issues/1221 for the SDK dev team to include in their work planning as I believe there is some performance optimization that we may need to look into before enabling deeper recursion. You can follow that issue for updates!

the limits e g 15GB in the free tier are

the limits (e.g. 15GB in the free tier) are per workspace, and shared between the databases and branches in that workspace. That's something we should clarify as well, thanks. We might, in the future, limit in how many free workspaces you can be part of, but currently we don't.

The CLI command ` xata schema dump f

The CLI command xata schema dump -f schema.json writes the schema of the current branch to a file.

Serialize

Hi How can I get rid of this warning?...
No description

Hi

Hi Is there a way to check when a new entry is added to a table, like polling or something more efficient and less expensive?...

What is the best way to handle this kind

What is the best way to handle this kind of scenario, I want some fields to be unique and never be null
No description