Help with Drizzle
Branch copy has old schema version
5713tr
...Error using aggregation: search disabled
postgreSQL alternative
Error: Out of Memory when creating a new sequence on pg-enabled DBs
CLI/programmatic migrations for pg-enabled dbs
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
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!pgroll with drizzle generated migrations - possible?
drizzle-kit generate
with pgroll?
This would make our db schema updating process very smooth!...Requests that go on forever and no response
Probably a bug
pgroll.is_active_migration_period 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
Unable to link a field to table via Xata SDK (JS/TS)
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.log
ing 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.
...Codegen timeouts
FetchError: request to https://abc123.ap-southeast-2.xata.sh/db/projects:main failed, reason: Code: ETIMEDOUT...
Help with initializing pgroll
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
...Cannot install Xata CLI in Linux using the script or homebrew
Performance Concern - Database Migration Latency
New Xata dedicated cluster version string?
Xata Dashboard error when trying to delete a file