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

Michael Saurin

8/26/2024

Hosting services for the .Net Core Web Application

I want to use Xata Serverless Postgres in a .Net Core Application in the US East (N. Virginia) region. Which hosting services for the .Net Core Web application do you recommend considering low latency between the database and the application and also cost-effectiveness?...

Prismatic Martian

8/18/2024

Schema and tables

New to Xata and confused. I have a dbt project that uses a specific schema name and within that schema will be all my tables. I don't see anything in the UI where I can set the schema name. I also tried to upload csv files that are part of the seed data, it adds additional columns, it renames the columns in the seed files (from id to xata_id), and in one columns it removed the values making it all NULLs. I might be missing something here but I've never seen a postgres db behave like this. Is this broken?...

andreasb

8/12/2024

Immutability & tamper-proofing?

Hey! Are there any plans to expand the scope of Xata into the immutability/ledger db space? We have solutions such as ImmuDB, Dolt SQL, XTDB, SQL Server 2022 Ledger and so on which provides cryptographically verifiable tamper-proofing of data (i.e., you cannot change data in the database without traces). Does Xata see this as something within its scope?

mrcentigrade

8/12/2024

bool type is missing in web-ui dropdown

hello, i'm trying to add a bool type column to my table from xata.io web ui. i don't find the option in this dropdown. any idea what is wrong?

Petar Vukovic

8/10/2024

Initialiaztion client in python

I added .env file in which are db_url,api_key.But when i in main.py initialize client i got File "C:\Users\pvukovic\Desktop\AI_projects\ChatDocko_demo\backend\main.py", line 7, in <module> xata = XataClient(api_key=api_key, db_url=DB_URL) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\pvukovic\AppData\Local\miniconda3\envs\chatdocky\Lib\site-packages\xata\client.py", line 111, in init ) = self._get_workspace_id()...

🆂🅵🅲 SPACEFLAKE

8/9/2024

Unable to log in to prod branch main after using PR based workflow

I was eager to try out this feature but may have done something wrong along the way. I use next-auth in this Next.js project on Vercel. I have the Vercel integration aswell. I can log in to the site as a user on the preview branch, but now my users and me can't log in the prod site on main. Any suggestions?...

kernelpanic

8/9/2024

Error using pg_dump

I was able to use pg_dump just last week to dump my database. Today when I tried, I get this error: pg_dump: error: query failed: couldn't get first string argument pg_dump: detail: Query was: SELECT set_config(name, 'view, foreign-table', false) FROM pg_settings WHERE name = 'restrict_nonsystem_relation_kind'...

41 · 6C · 69 · 73 · 68

8/9/2024

Ident authentication failed for user "username"

I am getting the following error while migrating the schema using drizzle-kit

Андрей

8/4/2024

Vector search with filtering.

Hi! I am interested in the ordering in vector search with filtering. 1. First the search is performed and then filtering and we may have empty results. 2. First filtering and then search and as a result we always have a given number of documents in the search. I assumed that Xata had the second method and the code was customized for it. The program worked and there were no problems. But then errors started to occur (probably due to more testing) and it turned out that the first option worked. Is this true or not? Thank you....

Ventston

8/2/2024

Pgroll vs ariga/Atlas

Hello, Thanks for this great tool! I discovered pgroll while trying to improve my database migration management. I had also found ariga/Atlas ( https://github.com/ariga/atlas) and I can't find or identify the strengths and weaknesses of either tool. Can you help me compare the two tools? Thanks in advance 💚...

AD Amorim

8/1/2024

Vercel integration is not setting the XATA_BRANCH

errors: [ { message: 'database branch [...:preview-nativedone-chore] not found', status: 404 }...

Kosta

8/1/2024

pgroll with pg-enabled db

I tried using pgroll like shown on github

pgroll init --postgres-url postgres://user:password@host:port/dbname

pgroll init --postgres-url postgres://user:password@host:port/dbname

using the url from pg enabled database but I get an error

Failed to initialize pgroll: pq: unknown statement type, see https://xata.io/sql-support for the support matrix
Error: pq: unknown statement type, see https://xata.io/sql-support for the support matrix

Failed to initialize pgroll: pq: unknown statement type, see https://xata.io/sql-support for the support matrix
Error: pq: unknown statement type, see https://xata.io/sql-support for the support matrix

...

Condo's Sugar Baby

8/1/2024

Issues connecting to the database

I'm trying to connect to my db using the new Postgres + Prisma setup. For some reason whenever I try to push or migrate I keep getting the message

``
Error: P1001: Can't reach database server at

us-east-1.sql.xata.sh:5432` ...

agaitan026

7/30/2024

how to show all results in react app?

im trying const response = await axios.post( 'https://alexis-gaitan-s-workspace-r0aiag.us-east-1.xata.sh/db/dbsnetworkdb:main/tables/usuarios/query', but its showing only max 1000 results, but i have like 10000...

CodeMaestro

7/26/2024

xata raises error if `RESET ALL;` is called

I have encountered a bug with xata when using asyncpg and a connection pool. Root cause: When a connection is released back into the pool, the RESET ALL; is executed and xata raises a setting "" is not allowed error. ...

50BytesOfJohn

7/25/2024

Is it possible to restrict api key to specific branch only?

I mean, to have a single API key that I can use for main branch that I can have in vercel prod env for example, and 2nd api key, that can be used for all branches, except main? So while trying to push changes, query etc. from main I will get the error?

dream

7/25/2024

Using prisma to create a new record with a file column

How do I use the prisma client to create a new record with an empty file column? I've tried the following: 1. Placeholder metadata (taking hints from this example: https://xata.io/docs/sdk/file-attachments#1-createupdate-a-record-with-an-empty-file-server-side) ```ts await prisma.message.create({ data: {...

dream

7/25/2024

Custom env variable names

Hello! I'm using a vite plugin to check for environment variables before creating a new build. Vite recommends declaring env variable names with the prefix VITE_. The plugin only detects variables with this prefix. How can I configure the xata SDK and CLI to use the env variables VITE_XATA_BRANCH and VITE_XATA_API_KEY?

Andrew

7/24/2024

schema migration to add link between users and projects tables.

Trying to run a migration in the xata migration editor. It runs without error but I cannot get the link created. When I use the interactive tool to create the link_to_table it creates a link between the tables but when i try to add a record it gives this error " columns invalid: column [user_xata_id]: column not found " [ { "alter_column": { "table": "projects",...

SmokeyFro

7/23/2024

Cannot destructure property 'id' of 'raw' as it is null (following the Astro tut)

Howdy folks. I'm pretty new to Xata and have to say so far it's pretty dang awesome. I'm still figuring things out and have been going through the Astro, Xata, Stripe & Lucia tut (sans the stripe part). The user registration and session parts are working, but I'm getting the following error when signing up as a new user: ...

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!