Drizzle TeamDT
Drizzle Team•2y ago
Ricardo Romero

Bigint in SQLite results in "TypeError: Do Not Know how to serialize a BigInt"

It's failing in this section of my schema:
const users = sqliteTable("users", {
  balance: blob("balance", { mode: "bigint" }).notNull().default(BigInt(0)),
  id: text("id", { mode: "text" }).unique().notNull().primaryKey(),
});

With the following error:
TypeError: Do not know how to serialize a BigInt
    at JSON.stringify (<anonymous>)
    at applyJsonDiff (/Users/moro/semiotic/sql-studio-webapp/node_modules/drizzle-kit/bin.cjs:5573:27)
    at applySnapshotsDiff (/Users/moro/semiotic/sql-studio-webapp/node_modules/drizzle-kit/bin.cjs:17562:20)
    at prepareSQL (/Users/moro/semiotic/sql-studio-webapp/node_modules/drizzle-kit/bin.cjs:15220:20)
    at prepareAndMigrateSqlite (/Users/moro/semiotic/sql-studio-webapp/node_modules/drizzle-kit/bin.cjs:15163:48)
    at async Command.<anonymous> (/Users/moro/semiotic/sql-studio-webapp/node_modules/drizzle-kit/bin.cjs:66406:3)

When I try to run drizzle-kit generate:sqlite.
Was this page helpful?