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

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

unc Vanzz

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

Dragoon | Sclee

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

Lukas

10/30/2024

Error when using Xata on AWS Lambda

Hello we are trying to deploy a dockerized node.js function to AWS Lambda (with the offical aws lambda node.js docker image), that creates objects with the drizzle ORM and uses the Xata-Http client. When we use this docker image locally we do not face any problems. But when we try to use it uploaded on AWS Lambda we get the following error, we put it in a pastebin because of the limit of characters of Discord: https://pastebin.com/NQWRLkhC The (simplfied) code we use is in the .txt file....

message.txt

CustomEntity

10/29/2024

Several connection problems with Datagrip

I'm having several problems connecting to my database with the Datagrip client. Every other day I can't connect and it can't fetch certain tables... Am I the only one with this problem?...

CustomEntity

10/28/2024

Cannot connect to by database with DataGrip

Hello, from one day to the next I no longer have access to my database from Datagrip, even though it was working and I hadn't changed any parameters.

HYRA

10/23/2024

SSL Cert

This might be super dump question. But how can I obtain the SSL cert from Xata?

matdehaast

10/23/2024

pgvx: complex return types

I love what you have done with pgzx. I'm trying to work out how I would produce complex return types of custom functions. Can I just return a pg Datum? Or is there more to it? Thanks...

dream

10/23/2024

Exclude special columns when fetching records

Using the xata typescript SDK, how do I exclude the xata.* and xata_* columns from the query results? I'm trying to maintain a two way sync between a client side user form and the database. These special columns make the form validation fail, I have to filter them out which is kind of frustrating. Is there a way to select all [*] columns and exclude these xata columns?

Raveen

10/20/2024

Search Method Cache issue

I'm using the xata.db.tablename.search method to retrieve data, and when I update or delete a data and immediately try to re-fetch records I get the old values only and only after few seconds I get the changed value. I think it might be cache, if so is there any way to clear it and get updated value ?

JustSomeDev

10/18/2024

Xata dedicated instance version string

Hey, I am a contractor representing Neon. We recently shipped https://pgversions.com/ and we put the shared instance pg version string as the one there We saw this comment on YC -> https://news.ycombinator.com/item?id=41878149 and we were wondering if someone could send the connection string for a dedicated instance please. Thanks!...

CustomEntity

10/17/2024

table [Zeldadle:main/zelda_daily_boss] is not compatible with xata; please adapt it

Hello ! I created my table using Datagrip and I have this error when using the http endpoint:

Panicintrinsica

10/16/2024

"Projection/Select" in search queries?

I've been adding text search to my site and was trying to figure out a way to limit the amount of data sent back to the client. Is there a natively supported way to only select/return a specific set of columns using search, whilst still searching those columns? Specific example, I want to search article content, but do not need to return the whole content body, I only need the names and id's of the articles that matched over n many points. ...

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!