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

JustSomeDev

11/27/2024

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?

Michael Schaufelberger

11/22/2024

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

ghqpio

11/22/2024

Need help with: invalid SQL: table [main/excluded] not found

Using Kysely as a dialect. Trying to insert data and resolve conflict by using native PG "excluded" table when running into conflict. My code: `return await this._db .insertInto('Reports') .values(values)...

Craft

11/21/2024

Push into an existing array with xata's SDK

Hi, I'm using Xata's SDK for python to create new rows into my db, right now we try to find a solution to push new floats into a price array, but i can't find how to do it with Xata SDK without having to fetch all the information one by one. As this is a basic function on Postgres, i was wondering if it's not yet implemented onto the SDK. Thanks in advance.

blaise

11/20/2024

python xata client out of sync when using .data() vector search

Hi folks, I am trying to use the xata client in python SDK search ingessted records, after editing schema while developing im noticing like complete out of sync data -- missing records, misssing columsn even though the schema has been pushed, etc, how do i fix this as it makes vector search unusable in prod. My intuition is theres indexing happening on the table with the embeddings -- its strange cuz it was working fine til i edited the schema now ssearching is essentially a no op / does not work...

kayog123

11/20/2024

permission denied for schema

Migration failed, unable to execute start operation: pq: permission denied for schema

kayog123

11/20/2024

Merge dev branch to main branch

Hello, I'm currently working on some project and I need to merge my changes n my dev branch to our main for production release. I wanted to know on how to do it?

Luan Vieira

11/19/2024

Transfer ownership in free plan

I'm working on a personal project for a friend, but I will not keep the workspace for myself. I've seen that you can add members to the workspace and assign them as owners but I think the option is available only to Pro members. There is a way to do this with the free plan?...

Michael Schaufelberger

11/19/2024

How can I get data from a different table when adding a column? - Multi Schema Migrations

Hi 👋 Say I want to store a user's full name inside a post. For this, I would add a column to the posts table userFullName using pgroll: ```json...

brownfox.dev

11/18/2024

Kysely types - ID

We've created tables directly with sql script as we need inheritance and don't want xata_* columns in our data. Everything works nice, but when I try to query with id column I get this error:

Argument of type '1' is not assignable to parameter of type 'OperandValueExpressionOrList<Model<DatabaseSchema>, "buildings", "id">'

Argument of type '1' is not assignable to parameter of type 'OperandValueExpressionOrList<Model<DatabaseSchema>, "buildings", "id">'

...

Damiano

11/14/2024

Custom id field in transaction update operations

Hello everyone. I would like to perform bulk upsert operations (https://xata.io/docs/sdk/transaction#update) using a custom unique field as the identifier instead of the default xata_id field. Is this possible, or is there a better way to achieve this?

Summer

11/14/2024

using pgstream to replicate Azure Postgres Flexible Server

Hello everyone, We are looking for a solution that is able to replicate DDL changes for Azure Postgres Flexible and have been looking at pgstream but are unsure if it would work. Does anyone have experience?...

mrcentigrade

11/11/2024

summarize pagination

i'm using summarize to get unique values for a text column from my table. i've pageSize set to 10. with getPaginated i use the meta in the object returned to implement cursor based pagination. with summarize i don't have the meta in the object returned. how can i go about implementing pagination with summarize?...

11/10/2024

Added a column 6 hours ago, and it is still doing a migration

I am unable to click the add new column through the + on the table, and the migration in progress has been in a loading state for a couple hours now.

RealT

11/7/2024

Import a CSV file with text[] column type

I kept getting invalid column type [text[]] error when trying to import a csv file into a new table with a text[] column type. I tried to import a csv file that is exported from an existing table and it still failed because of that column. This is one of the rows in my csv file and the second column is of text[] type. Any ideas? rec_csi6284le37f553ij520,"[""All and Together"",""End and Final""]",2024-11-01T05:03:28.353467Z,2024-11-06T06:39:28.877725Z,2,7097,193,end,קצה...

Triqueta Ventures

11/4/2024

.search Issue

Hello! I have been using the .search functionality of xata for a few weeks and a few days ago it stopped working out of nowhere. Does anyone know if it is a xata problem or a problem with my project?

Michael Schaufelberger

11/4/2024

FetcherError: Internal Error

Hi 👋 When trying to write to our non-postgres DB, we are currently getting the cryptic error: ``` FetcherError: Internal Error (Request ID: f347ce16-76ee-945f-81df-51cf8d1f6e59)...

DigitalMischief

11/3/2024

What support is there for database events?

I cant find any concrete information on database events or subscriptions. I see brief articles on pg_roll and pgstream but nothing definitive about whether those integrations are supported with Non-native postgres databases. Data replication out of non-Postgresql native Xata databases is proving to be a lift

escular

11/2/2024

Writing data from Kafka topic to database

Hello, I am trying to create a simple replication of DML and DDL operations from a source database to a target database. The hosts are running Almalinux 9 and PostgreSQL 16. I am using pgstream to send data changes to a Kafka topic. I then try to fetch these via Kafka Connect with the JDBC Sink Connector and apply them to the target database. Unfortunately, there are problems with the Sink Connector. For example, whenever I create a new test table using CREATE TABLE, I get the error message from the attached file....

error.txt

mrcentigrade

11/2/2024

is branch-ing ready for production use.

was trying to figure out migration workflow in production. i just noticed that docs says the feature is in beta https://xata.io/docs/getting-started/workflow i haven't yet connected my sveltekit project github repo to xata. i just got few active users and i don't want to lose their data. i still have one branch main in my sveltekit repo but with active users now i will have to created a dev. ...

Previous Next

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!