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

Triqueta Ventures

2/21/2025

Numeric ID for transfer codes

Hello!, I wanted to know if with xata I had the possibility of creating a column that has unique numbers and that the numbers are created by themselves as they are created, like an ID field but personalized

azad

2/19/2025

Pgroll support for creating index on huge table with frequent reads & writes

Hi PgRoll Team, I’m Azad, and I have a use case where I’d like to understand if PgRoll can provide support. Currently, I’m using Flyway to manage schema migrations, but I recently encountered an issue with the following error: SQL State : 53400...

michaeltintiuc

2/16/2025

Identity table sequence name is ignored

When creating an identity column via id int PRIMARY KEY GENERATED ALWAYS AS IDENTITY (SEQUENCE NAME blobs_id_seq ...) the sequence name is then returned as a number (i.e. 6088102) this causes issues with migrations via drizzle-kit push is this a limitation of the free plan and are there any ways around it?

Rittam

2/14/2025

Connect xata-db with encore.dev

tried this connection in the db>index.ts file but wasn't able to figure out.

mrcentigrade

2/12/2025

@auth/xata-adapter issue.

i've a sveltekit app (svelte 4) and i am using authjs (nextauth) to implement google signin. signout / signout works. however i've noticed that updateSession doesn't work. i spent some time and bumped my authjs related packages to the latest i.e. @auth/core@latest @auth/sveltekit@latest @auth/xata-adapter@latest. my session config is as follows: ``` session: {...

Peeble

2/6/2025

invalid or expired jwt

Hey all, I was trying to use the "export full table to CSV" feature on the web interface but was getting the error in the attached screenshot. Is this because the table is pretty large and it's timing out? I was able to export earlier without issues, but the table size has grown larger.

angelgce

2/4/2025

Migrations failed on git update

When I create my PR my xata dev branch has migrations, because of that a preview branch is created as the documentation says to see my |migrations", but this branch never brings my changes even if my PR has the new migrations, so when I merge my PR, xata wont update main with new migrations.

alihammad

2/2/2025

Error: branch [sharai:develop] has search disabled

Hi there, I used to build products with Xata as it's powerful and has a free plan. I'm currently building a product and faced a search error. I thinks it's because of pricing update. So I'd like to ask if I can have a fully featured plan for testing as used to be before moving to production. Thanks...

kalem868

2/1/2025

Connection terminated unexpectedly

I have my database set up like this const pool = new Pool({ connectionString: process.env.XATA_DATABASE_URL, max: 10, });...

teleoflexuous

1/29/2025

table().get_schema(name) fails with table (name) not found, search_and_filter().query(table) works

Hey, so here's a snippet of code I'm using ``` print("Table:", table)...

Michael Schaufelberger

1/24/2025

Drizzle pull/push: Permission denied for view pg_stat_user_indexes

Hi 👋 Sorry to bother you again. Quick question: After a long while I'm using the drizzle commands again and now I'm receiving the following error: ```bash...

Oreki

1/17/2025

Help with Drizzle

Hey team, i would like to run introspect and pull commands from drizzle-kit, but i seem to be running into an error the config:-...

Michael Schaufelberger

1/17/2025

Branch copy has old schema version

Hi 👋 I have an issue that a new branch does not include all columns of the base branch. Workspace ID: 5713tr...

protoavatar

1/16/2025

Error using aggregation: search disabled

Hi, i have been using the aggregation endpoint for long, but I am now receiving an error: "branch [esabiciPg:main] has search disabled". I can't find a way to enable it. Did something change recently or is this an error?

Sidereal Night

1/8/2025

postgreSQL alternative

Hello Is it possible to connect to my Xata database using mysql/php instead of postgreSQL ? If I look at code snippet, I can't find the mysql option under php ...

November

1/6/2025

Error: Out of Memory when creating a new sequence on pg-enabled DBs

I'm looking to create a new sequence, but it doesn't look like the pg instance is letting me create one- ``` When running then CREATE SEQUENCE foo_bar_id_seq MINVALUE 20;...

November

1/5/2025

CLI/programmatic migrations for pg-enabled dbs

Hey all, I'm looking to try and test out xata, and want to be able to do some migrations programmatically So far, it looks like re-using my existing Flyway migrations is out (I can't just point it to the xata instance unless it's a dedicated instance), so I figured that pgroll CLI would be the way to go I know that pgroll is already built-in to the UI itself for managing, and prior questions seem to point to the UI (https://discord.com/channels/996791218879086662/1268594196474757121), but I was wondering if there was a way to get programmatic or externally-driven migrations working with xata- trying with:...

theres

1/4/2025

`SET` and `current_setting` Usage in Xata

I'm exploring the possibility of migrating our application to Xata. However, I've encountered some issues with the SET statement, set_config, and current_setting functions. We rely on these functions to pass additional session parameters (e.g., userid, tenantid, etc.) for RLS and auditing purposes. Have I overlooked something, or is this functionality simply unavailable in Xata? Thanks in advance!

Femi

1/2/2025

Option apiKey is required

Please can someone tell me why I keep getting Option apiKey is required...

Schahin

12/29/2024

pgroll with drizzle generated migrations - possible?

Is it possible to use the migrations generated with drizzle-kit generate with pgroll? This would make our db schema updating process very smooth!...

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!