sergiompc12 Posts - Answer Overflow

sergiompc12

•Created by sergiompc12 on 9/25/2024 in #help

Migration Errors

Hi all, i am trying to make a migration to a database in Turso using drizzle. However i am blocked in two issues. - The first is because when i do some changes on the schema the major of the times the migration presents the following message: " SQLite does not support xxxx out of the box, we do not generate automatic migration for that, so it has to be done manually" - The second one is when i try to apply the migration i got stuck in these errors: SQL_MANY_STATEMENTS or SQL_EMPTY_STATEMENTS this is my drizzle.config.ts

import { defineConfig } from 'drizzle-kit'

export default defineConfig({
    schema: './src/admin/index.ts'
    out: './drizzle/admin'
    dialect: 'sqlite',
    driver: 'turso',
    dbCredentials: {
        url: process.env.TURSO_URL
        authToken: process.env.TURSO_GROUP_DB_KEY,
    },
})

import { defineConfig } from 'drizzle-kit'

export default defineConfig({
    schema: './src/admin/index.ts'
    out: './drizzle/admin'
    dialect: 'sqlite',
    driver: 'turso',
    dbCredentials: {
        url: process.env.TURSO_URL
        authToken: process.env.TURSO_GROUP_DB_KEY,
    },
})

Thanks in advance for your help.

1 replies

Gaming

Programming