Storm Posts - Answer Overflow

Storm

•Created by Storm on 9/17/2024 in #help

identityName.startsWith is not a function

I get this error whenever I push or introspect, I'm using drizzle + postgres. https://github.com/drizzle-team/drizzle-orm/issues/2919

9 replies

XXata

•Created by Storm on 5/28/2024 in #help

Is it possible to do a sorted search?

I have this code and I want to sort the result by the created_at field

const profiles = await xata.search.all(searchQuery, {
        tables: [
            {
                table: 'cv_theque_profiles',
                filter: {
                    is_active: true,
                },
            },
        ],
        page: {
            size: 10,
            offset: 0,
        },
        fuzziness: 1,
    })

const profiles = await xata.search.all(searchQuery, {
        tables: [
            {
                table: 'cv_theque_profiles',
                filter: {
                    is_active: true,
                },
            },
        ],
        page: {
            size: 10,
            offset: 0,
        },
        fuzziness: 1,
    })

3 replies

XXata

•Created by Storm on 4/26/2024 in #help

Does type "serial" exist in Xata/Drizzle?

7 replies

XXata

•Created by Storm on 4/26/2024 in #help

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?

5 replies

XXata

•Created by Storm on 3/27/2024 in #help

Drizzle ORM schema conflict with xata_createdat and xata_updatedat

This is my drizzle schema:

export const users = pgTable('users', {
    id: text('id').primaryKey(),
    email: text('email').unique(),
    createdAt: timestamp('created_at').defaultNow(),
    updatedAt: timestamp('updated_at', {
        mode: 'date',
        precision: 3,
    }).$onUpdate(() => new Date()),
})

export const users = pgTable('users', {
    id: text('id').primaryKey(),
    email: text('email').unique(),
    createdAt: timestamp('created_at').defaultNow(),
    updatedAt: timestamp('updated_at', {
        mode: 'date',
        precision: 3,
    }).$onUpdate(() => new Date()),
})

When I push my schema using npx drizzle-kit push:pg I get a popup from Xata telling to add xata_createdat and xata_updatedat I do add them but then later when I change my drizzle schema (let's say I added a firstName column) and push it, Drizzle warns me that I'm going to drop xata_createdat and xata_updatedat What am I supposed to in this case? Thank you

9 replies

Gaming

Programming