1 reply

Expo SQLite : Empty hash in __drizzle_migrations

SQLite

drizzle orm

Hello,

I'm using latest drizzle orm 0.45.1 on expo, with expo driver and SQLite database. It seems to work well for now except the hash is an empty string in __drizzle_migrations table

This causes issues when adding new migrations, as I believe drizzle use it to identify which migration is applied

I also noticed the ID is null but I found a github issue regarding that (https://github.com/drizzle-team/drizzle-orm/issues/1227), but it seems unrelated to the hash, it's due to drizzle using SERIAL for the ID which is not supported on SQLite.

I can accept the null ID but I really need to fix the hash before sending this feature to prod or it will prevent from adding new migrations. Anyone encountered this?

I followed the drizzle documentation to integrate with Expo, this is my drizzle.config.ts

export default {
    schema: "./src/db/schema.ts",
    out: "./src/db/migrations",
    dialect: "sqlite",
    driver: "expo",
} satisfies Config;

export default {
    schema: "./src/db/schema.ts",
    out: "./src/db/migrations",
    dialect: "sqlite",
    driver: "expo",
} satisfies Config;

And this is this is the journal I get from

npx drizzle generate --name=init

npx drizzle generate --name=init

{
  "version": "7",
  "dialect": "sqlite",
  "entries": [
    {
      "idx": 0,
      "version": "6",
      "when": 1767018383567,
      "tag": "0000_init",
      "breakpoints": true
    }
  ]
}

{
  "version": "7",
  "dialect": "sqlite",
  "entries": [
    {
      "idx": 0,
      "version": "6",
      "when": 1767018383567,
      "tag": "0000_init",
      "breakpoints": true
    }
  ]
}

Thank you

Drizzle Team•5w ago•

1 reply

Max

Expo SQLite : Empty hash in __drizzle_migrations

SQLite

drizzle orm

export default {
    schema: "./src/db/schema.ts",
    out: "./src/db/migrations",
    dialect: "sqlite",
    driver: "expo",
} satisfies Config;

export default {
    schema: "./src/db/schema.ts",
    out: "./src/db/migrations",
    dialect: "sqlite",
    driver: "expo",
} satisfies Config;

And this is this is the journal I get from

npx drizzle generate --name=init

npx drizzle generate --name=init

{
  "version": "7",
  "dialect": "sqlite",
  "entries": [
    {
      "idx": 0,
      "version": "6",
      "when": 1767018383567,
      "tag": "0000_init",
      "breakpoints": true
    }
  ]
}

{
  "version": "7",
  "dialect": "sqlite",
  "entries": [
    {
      "idx": 0,
      "version": "6",
      "when": 1767018383567,
      "tag": "0000_init",
      "breakpoints": true
    }
  ]
}

Thank you

Expo SQLite : Empty hash in __drizzle_migrations

Similar Threads

Expo SQLite : Empty hash in __drizzle_migrations

Similar Threads

Similar Threads

Similar Threads