Xata

X

Xata

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

Join

help

general

Filter not working.

Hello, I am trying to filter with xata.createdAt for a date 2025-01-14T14:19:05.349804Z and it looks to be not working, tried with adding milliseconds too , and also tried with the date selector - dose not work, As seen in screenshot the date in the records in "xata.createdAt" column exists for which filter was applied but no records were found. Is there anything we could do to solve this ? or is this a bug ? Thanks...
No description

Cannot connect to DB

I just created a Databse in Xata and I'm trying to connect to it with psql. But this is the output of psql: psql: error: connection to server at "eu-west-1.sql.xata.sh" (52.18.153.197), port 5432 failed: could not receive data from server: Operation timed out I double checked all fields and all are okay. Any idea on how to solve this? Thank sin advance!!...

no schema has been selected to create in error

Hello, My app is using search_path, and i am getting below error when i try to connect to xata instance. failed to create version table: pq: no schema has been selected to create in . How do i overcome this error please

How much replicate can create in PRO plan

is there any hard limit how much replicate can i create in different location and also how the pricing works for them?

PATCH record not working but GET is?

I didn't change anything and suddenly the PATCH record stopped working, even though I followed the convention https://{your-workspace-slug}.{region}.xata.sh/db/db_branch_name/tables/table_name/data/record_id The error message I got was: ```...

$notExists filter having weird behavior

I have a field called description and I wanted to filter out those rows with description as null. I use $notExists. It works for the most case but for some cases. One of the values which is being filtered as notExists true is attached in the text document. Please do let me know if more info is needed for this. Thanks

I am trying to update the user record in my database in the callback function of oauth2. FetchError

The code works fine without the Xata logic, i.e only for authentication, but gives Fetch Error in the catch block when i try to update the record. I have checked my schema against this and its correct. ```ts exports.callback=async (req,res)=>{...

Did my PostgreSQL database just get wiped?

During the development of a platform, I started receiving errors from PostgreSQL and when I accessed Xata to see if everything was ok, I realized that all my tables were gone, nothing even appears in the Schema History...
No description

Active Migration Won't Complete

Currently, I have a table migration that has been going on for 9 days, It is a large table with about 12 million rows but in the past most migrations have only taken a few hours. I just want to be able to delete and reupload the table but it won't let me because of the active migration.
No description

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

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

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?

Connect xata-db with encore.dev

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

@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: {...

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

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

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

Connection terminated unexpectedly

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

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