cmck Comments - Answer Overflow

Topics

cmck

•Created by Michael Schaufelberger on 1/17/2025 in #help

Branch copy has old schema version

Hi Michael, thanks for bearing with us. We've pushed a fix for this issue (I tested it there with the support-test-1 branch). One slight caveat, however; the dev branch has a long migration history, so branches created off it take time to complete. When you create a branch off of dev you may notice a timeout and an initial discrepancy in the tables. If you wait a few minutes and refresh the page, the branches will match. We're looking to improve this experience moving forward but the root issue has been resolved.

12 replies

•Created by Oreki on 1/17/2025 in #help

Help with Drizzle

With your non-postgres-enabled database, you might need to change the client you're using. Looks like you're using the TCP client. Did you try the HTTP client?

import { drizzle } from 'drizzle-orm/xata-http';
import { getXataClient } from './xata'; // Generated client

const xata = getXataClient();
const db = drizzle(xata);

import { drizzle } from 'drizzle-orm/xata-http';
import { getXataClient } from './xata'; // Generated client

const xata = getXataClient();
const db = drizzle(xata);

https://xata.io/docs/integrations/drizzle

13 replies

•Created by Oreki on 1/17/2025 in #help

Help with Drizzle

Let me double-check just to make sure I'm right about Beta Direct Access Enabled: false before you go exporting anything. Did you test it with a postgres-enabled db?

13 replies

•Created by Oreki on 1/17/2025 in #help

Help with Drizzle

I appreciate that it's annoying. We're looking into that feature for the non-pg-enabled databases. For the pg-enabled dbs, you can use pgdump.

13 replies

•Created by Oreki on 1/17/2025 in #help

Help with Drizzle

Unfortunately, there's no way currently to convert an existing database to a direct-postgres-access-enabled database.

13 replies

•Created by Oreki on 1/17/2025 in #help

Help with Drizzle

Hi Oreki, I suspect the issue is due to Beta Direct Access Enabled: false . Without this setting enabled you can't connect directly to your database with a postgres connection string. https://xata.io/docs/postgres#postgres-can-not-be-enabled-on-already-existing-databases you could test this by creating a test db with that setting enabled and see if the connection works.

13 replies

•Created by Michael Schaufelberger on 1/17/2025 in #help

Branch copy has old schema version

Identified the issue, we're working on a fix, thanks for bearing with us, Michael.

12 replies

•Created by Michael Schaufelberger on 1/17/2025 in #help

Branch copy has old schema version

Yes that's fine Michael, thanks for the added info. I can create branches through the support access myself so we can continue to investigate. I'll keep you posted.

12 replies

•Created by Michael Schaufelberger on 1/17/2025 in #help

Branch copy has old schema version

No worries. Could be a restore given the number of tables that are missing between dev and test-template

12 replies

•Created by Michael Schaufelberger on 1/17/2025 in #help

Branch copy has old schema version

Which tables are affected? I see there are some tables missing as well. I'll keep digging.

12 replies

•Created by Michael Schaufelberger on 1/17/2025 in #help

Branch copy has old schema version

Nevermind, found it 👍

12 replies

•Created by Michael Schaufelberger on 1/17/2025 in #help

Branch copy has old schema version

Which database is this branch on?

12 replies

•Created by Michael Schaufelberger on 1/17/2025 in #help

Branch copy has old schema version

Hi Michael, thanks for reaching out. We'll take a look.

12 replies

•Created by protoavatar on 1/16/2025 in #help

Error using aggregation: search disabled

Hi! This error occurs when you use search or aggregate on the free tier. We masde the tough decision recently to move the Search feature to the Pro tier. https://xata.io/docs/sdk/aggregate https://xata.io/blog/changes-free-tier

3 replies

•Created by ghqpio on 12/19/2024 in #help

Probably a bug

@ghqpio a fix for the linking issue has gone live, let me know if you run into any other errors. 👍

11 replies

•Created by Sidereal Night on 1/8/2025 in #help

postgreSQL alternative

Hi @Sidereal Night . Xata only offers postgres, not mysql so there's no mysql connection option.

2 replies

•Created by CustomEntity on 12/21/2024 in #help

Requests that go on forever and no response

Hi @Jan H, can you please open a ticket by contacting [email protected] ? Please include your workspace ID and any relevant timestamps, logs, error messages etc. and I'll take a look 👍

10 replies

•Created by Kaligraphy on 1/6/2025 in #general

The workspaces I am working on, are all

Likewise. Non postgres-enabled databases in xata should just have the schema view and schema history options.

10 replies

•Created by Kaligraphy on 1/6/2025 in #general

The workspaces I am working on, are all

Hey Kaligraphy. Databases that are not postgres-enabled won't have the "native sql table" option.

10 replies