Xata

X

Xata

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

Join

help

general

Is there any updates on this?

Is there any updates on this?

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

I am using N8N and keep getting the

I am using N8N and keep getting the following error: Issues: input values have 2 keys, you must specify an input key or pass only 1 key as input (input values have 2 keys, you must specify an input key or pass only 1 key as input)...
No description

How to make this adaptation

How to make this adaptation automatically via schema.ts? As in the session table, for example: ```ts export const sessions = pgTable('session', {...
No description

hi, why i can't insert record using

hi, why i can't insert record using fetch? function test() { const payload = { wallet_id: "string"...
No description

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();
...

GetAll

just a random thought, how bad will it be to use getAll() on large datasets?

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

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?