Is it possible to do a sorted search?
I have this code and I want to sort the result by the
created_at field
```typescript
const profiles = await xata.search.all(searchQuery, {
tables: [
{...manage ilike in api?
theres any api method to search records like ILIKE ? or theres only LIKE available?
Migrations with Drizzle
Hi
What is the current best practice regarding migrations when I'm using Drizzle with Xata?
With Planetscale I just used Drizzle Kit's
db push on db feature branches because the actual migration to prod was handled through the Planetscale dashboard....Parent Document Retriever in Xata
Hello. Is it possible to organize Parent Document Retriever in Xata? https://python.langchain.com/v0.1/docs/modules/data_connection/retrievers/parent_document_retriever/
Hi, trying to connect to a sample DB created by my self from Intellij IDEA, receive an error:
ERROR: column "rolconfig" does not exist Position: 312. ERROR: column t.xmin does not exist Position: 48. [42703] org.postgresql.util.PSQLException: ERROR: column n.xmin does not exist Position: 29
Is Xata powerful?
I'm building a SaaS app like Shopify, which has a lot of functions, features, and active users. I'd like to use Xata as the main data handler as it has a ton of features. However, I'm still not sure, I see developers building database solutions from scratch, so I don't know which option I should choose. Can I rely on Xata to handle a lot of data? Thanks :xatafly:
Non-default file attributes not accessible via Kysely query builder
If I try to fetch a
file.signedUrl or file.uploadUrl using the Kysely query builder, null is returned even though the file exists.
Are these properties only accessible via the Xata SDK as of now? If yes, this is a bit annoying because my Schema is very normalized and I need a lot of JOINs that are unsupported by the SDK atm.
I tried several different methods to access the file.signedUrl property but this one would be the easiest way to access it (if it would work):...Type of index
Hello. What type of index is used in vector search? Do you have an option to select HNSW?
How to run X number of operations in transaction
Hi, I am trying to upsert multiple records. According to the doc, I'll have to create update operations in transaction like before.
const result = await xata.transactions.run([
{ update: { table: 'titles', id: 'new-1', fields: { originalTitle: 'The third' }, upsert: true } },
......
How to filter file column based on the size of the array with the TS SDK
xata.db.products.filter(images:, {$gt:1})
Is there something like this ?...
Get one record
I am trying to add an
onClick event handler on the button Delete and creating a separate file for the xata client, which I will import. How can I go about it?
https://track-trip-dashboard-with-xata-next.vercel.app/dashboard/note/rec_com0uagjjap6athudr6g
```js...Does type "serial" exist in Xata/Drizzle?
I keep getting
error: type "serial" does not exist when I push my schema: id: serial('id').primaryKey().notNull(),
and if I do introspect I get this:
id: integer("id").default(nextval('cv_theque_profiles_id_seq'::regclass)).primaryKey().notNull(),
which is not valid syntaxically...
Copy main branch data to a branch
is it possible to to create a new branch from main branch and also transfer the data too?
Link to table
I need help in understanding link to table when creating a new schema for a table connecting to another table in the database.
Kindly share resources or jump on a call with me to get a clearer picture....
Search Relation table
Hi, I'm building a searching feature, and one of the columns "invoice" has a relation to a different table "customer".
I'd like to know how can I access the name of the customer within the invoice. Here's the code:
`import { getXataClient } from "@/app/xata";...
Xata DB Clone & Xata permissions
Hello!, i have two questions:
1. Does xata have any option to clone entire databases, with the tables and information inside, to be able to test in develop?
2. Does xata have any options to limit member permissions in workspaces? For example, a member can only access a database in a workspace.
Thanks!, and sorry for my bad english 🫠...
SQL Query working differently in playground vs SDK
Hi (again),
I have the following code:
``const subquery = SELECT DISTINCT (o.id)...Cannot perform I/O on behalf of a different request in Cloudflare Workers
Ok, so this may be a long one...
I have several cloudflare workers that write or request data from Xata.
When I do a single request using the TypeScript SDK, it works OK. When I do several requests like in a await Promise.all(array.map(async arrayElem => queryToXata(arrayElem))), then I get an error like:
...