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
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?
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....
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:
...
Storing objects of a specific class
Hello. Could you please tell me how to store an object of type "Document" (from langchain.docstore.document import Document) in a table?
Xata Starter Guide Next.JS trouble
Just following allong with the Getting Started with Next.js and Xata guide and I'm getting this error:
```"npm:@xata.io/client@latest
Module build failed: UnhandledSchemeError: Reading from "npm:@xata.io/client@latest" is not handled by plugins (Unhandled scheme).
Webpack supports "data:" and "file:" URIs by default....
Drizzle ORM schema conflict with xata_createdat and xata_updatedat
This is my drizzle schema:
```typescript
export const users = pgTable('users', {
id: text('id').primaryKey(),
email: text('email').unique(),...
Remix v2.8.1 (vite) on Vercel serverless function timeout when making xata db calls
The app is deploying properly and I can't see any issues in the runtime logs on Vercel. The serverless function (Node.js 20x) just timeouts after 60 seconds. Via console.logs I'm pretty sure it's related to a xata query.
In the build logs I see the following warnings (not sure if this is related):
```...