Xata

X

Xata

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

Join

help

general

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

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

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?

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

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

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

`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!

Option apiKey is required

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

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

Requests that go on forever and no response

Hello! I use Datagrip to access my database and very often for very simple queries like: SELECT id FROM public.cosmetics t LIMIT 201...

Probably a bug

When attempting to add a record through the interface and link it to other tables, by using the "link" functionality, it consistently retrieves data from the "main" branch, regardless of the branch I am currently in.
No description

pgroll.is_active_migration_period Error

I just started to use pgroll, and tried it initially with local postgres 16 in docker. All works fine. After that, I decided to apply the same migration to the my db in XATA and as a result get this error: Failed to start migration: pq: function [pgroll.is_active_migration_period] is unknown or not allowed What did I do wrong? Maybe someone has faced it before?...

Cannot to run non-interactive xata init

Hi, I want to run the β€œxata init” command non-interactive with flags, but returns me "Error: The current command required interactivity, but the --no-input flag is being used. Use --help to check if you can pass arguments instead or --yes to use the default answers for all questions. ". The command I executed was "xata init --db https://workspace-1234.us-east-1.xata.sh/db/database-name --sdk --no-input --yes --codegen=src/xata.ts --force". When I remove the --no-input flag asks me " You are working with a Postgres enabled branch. We recommend using the 'next' version of the Xata SDK. Do you want to install the recommended version (@xata.io/client@next)" but even if I say yes and install it, it asks me again and again. Am i missing something?...
No description

Unable to link a field to table via Xata SDK (JS/TS)

hello, I have been trying to link a role field in one table to a record in the roles table via the Xata SDK, but it does not seem to work. For more context, I am trying to create a new user and the role field is a link to the roles table. In the schema definition, the role cannot be null, but console.loging the return value from db.users.create returns the created user without the link under the role field. I have tried manually passing in the ID to the role I want to link, but that returns Fig. 1 and the new user record is not created If I try to pass the actual value I want from the roles table i.e. roles.role e.g. being == 'user', the create command is successful but users.role is still null. see Fig.2. ...
No description

Codegen timeouts

I'm getting constant timeouts on codegen today but the system status page says everything is fine of XATA. Any one else experiencing that? xata codegen
FetchError: request to https://abc123.ap-southeast-2.xata.sh/db/projects:main failed, reason: Code: ETIMEDOUT...

Help with initializing pgroll

Hi I'm trying to initialize pgroll but having some issue special characters in the password. I get an error Error: parse "postgres://postgres:Pass{[email protected]:5432/testdb search_path=pgroll": net/url: invalid userinfo. I also took a look at the supported commands for pgroll in the documentation. Is that the the full list of supported commands? Is there support for other commands like WITH or UPDATE, etc ...

Performance Concern - Database Migration Latency

I'm testing out different managed Postgres hosting solutions (from my dev machine but I've tried from a hosted server too.) and I'm experiencing unexpectedly slow execution times for create table queries, which is impacting my development workflow. Key Details: - Operation Type: Create table migrations - Observed Performance: Substantially longer execution times than anticipated...
No description

New Xata dedicated cluster version string?

Hey! Doing the updates of pgversions.com on behalf of Neon, asked here previously about the dedicated cluster version string, has this bumped up because of the recent minor releases at all?

Xata Dashboard error when trying to delete a file

Hi πŸ‘‹ I remember this working a few months ago, but now I'm getting an error whenever I try to update a record in the Dashboard that has a file. The error message: ```...
Next