Hi, is it possible to use xata import
Hi, is it possible to use xata import for CSV files into postgress enabled dBs on existing tables? It seems it tries to recreate the table (I am not using the --create flag) I receive an error like this: "Error: Migration failed, migration is invalid: table "tableName" already exists"
Hi! Anyone having issues on the Web-UI
Hi! Anyone having issues on the Web-UI with all the xata fields appearing as null? (xata_id, xata_createdat, xata_updatedat, xata_version) I have 2 different projects with the same issue...
hi, why i can't insert record using
hi, why i can't insert record using fetch?
function test() {
const payload = {
wallet_id: "string"...
is there currently a way, while creating
is there currently a way, while creating records i would like to modify xata's internal columns, for example give a old date for a record created right now
Connect to Postgres
https://xata.io/docs/postgres#export tried pg_dump like in the documentation but got error 'pg_dump: error: query failed: SSL SYSCALL error: EOF detected', probably issue with sslmode=require
Hey any chance sorting would support
Hey any chance sorting would support nested JSON object keys? i can't directly use raw query since i need other stuff as well
quick question, how can i get all
quick question, how can i get all records who do not have a linked entry, for example
...
const entries = await variables.database.db.markets.filter('card.id', null).getAll();
const entries = await variables.database.db.markets.filter('card.id', null).getAll();
Hi there, has anyone used Flyway with
Hi there, has anyone used Flyway with Xata? We use Spring Boot with Flyway and it calls SET ROLE under the hood which leads to an error, cause SET ROLE is not supported
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....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...
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 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.