Xata

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

Join

Xata

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

Join

help

general

brownfox.dev

11/13/2024

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.

brownfox.dev

11/7/2024

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

Kaligraphy

11/5/2024

Good day everyone, there is a little UI

Good day everyone, there is a little UI bug in the Schema View

atan2

10/6/2024

is that a prank ?

1benw

9/23/2024

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

Anonymous_hacker

9/22/2024

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.

Anonymous_hacker

9/20/2024

Can anyone share me the docs for

Can anyone share me the docs for exporting the data from the database.

Anonymous_hacker

9/19/2024

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

DigitalMischief

9/10/2024

Does anyone have an automation to

Does anyone have an automation to replicate a non Postgresql xata db into a Postgressql xata db?

Bill.IHCha

9/10/2024

Is there any updates on this?

protoavatar

9/6/2024

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"

protoavatar

9/6/2024

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

Jon

8/29/2024

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

Matthew

7/30/2024

hi, why i can't insert record using

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

Oreki

7/29/2024

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

tài

7/21/2024

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

Oreki

7/3/2024

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

Oreki

6/28/2024

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

...

Oreki

6/23/2024

GetAll

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

Shoot3R

6/12/2024

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

Gaming

Programming

Xata

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

Xata

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