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. ...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....
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?...
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.
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...
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?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 ?
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!...
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:
"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. ...
File-Type Columns no work
Since yesterday, I no longer have the option to add file-type columns in the tables. Does anyone know what could be the issue? I still have a free plan.
Links (Relationships) database structure and filter / query approach
Hi everyone, I am very new to Xata and databases generally and I am trying to build a small web app. I am using Next.js Latest, typescript.
I am looking for some guidance on setup and then filtering the data, so any help would be appreciated:
The situation I have is:
...
REST API - Unknown Column Type
I'm looking to wire Xata to a low-code frontend (Divhunt). I'm testing using the Rest API to get a list of entries from my table. The filtering function isn't working how I think it should.
I use Prisma to manage the backend of my database. The column I'm filtering on is an Enum in Prisma.
```...
Unable to get query using dynamic table
I want to retrieve data with the filter userId is this.userId. but when I do it with dynamic table name I get an error:
...
This expression is not callable.
Each member of the union type '{ <F extends FilterColumns<AgentRecord> | JSONFilterColumns<AgentRecord>>(column: F, value: FilterValueAtColumn<AgentRecord, F>): Query<...>; (filter?: BaseApiFilter<...> | ... 1 more ... | undefined): Query<...>; } | { ...; } | { ...; } | { ...; }' has signatures, but none of those signatures are compatible with each other.ts(2349)
This expression is not callable.
Each member of the union type '{ <F extends FilterColumns<AgentRecord> | JSONFilterColumns<AgentRecord>>(column: F, value: FilterValueAtColumn<AgentRecord, F>): Query<...>; (filter?: BaseApiFilter<...> | ... 1 more ... | undefined): Query<...>; } | { ...; } | { ...; } | { ...; }' has signatures, but none of those signatures are compatible with each other.ts(2349)
Sql over http unused parameters.
I need help using the typescript sdk to pull data using sql.
```ts
const my_nam = 'interbro'
const my_date = '2020-04-01'...
unable to execute start operation: pq: syntax error at or near ")"
I keep getting this error whenever I try to start a migration. This is my migration.json file:
[
{
"create_table": {...
Column is not an object or link
Hey I am trying to create an relation in my database schema. I am using Prisma ORM.
Somehow this schema makes the xata.io table view break more specifically the view for
Child table. It says "Error loading data... columns invalid: column [parentId]: column is not an object or link".
I have done the modification thing that xata prompts me for when I first open the viewer I just have not pulled the schema to my prisma.schema as I thought it was more clear to only show the schema I wrote.
What am I doing wrong?...High severity vulnerabilities when installing @xata.io/cli
Hi all, encountered 4 high severity vulnerabilities when I installed the CLI:
```
npm install @xata.io/cli
added 200 packages, changed 3 packages, and audited 1808 packages in 14s...