DT
Drizzle Team•2mo 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(),
});
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)
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.
2 Replies
Ricardo Romero
Ricardo Romero•2mo ago
I've also tried the 0n notation and it fails with the same error. I'm using bun as a package manager and sveltekit as a framework Anyone know of a suggested workaround? I'll probably end up saving it as string and doing the conversion manually
rphlmr ⚡
rphlmr ⚡•2mo ago
Want results from more Discord servers?
Add your server
More Posts
This query is to much for me :)Hello guys, This is the Query: ``` const result = await db .select({ contact_id: contaDefining types for default values in createSelectSchemaIn my users table schema for a Turso DB, I've got a field of `settings: text('settings', { mode: 'js.unique() doesn't seem to workI am coming from a front end background so am in unfamiliar territory with DB/Postgres stuff so apolSQLite Migrations add column not workingIm trying to add a column to the schema, but when i run `drizzle-kit generate` it says no changes foTypeError: columnType.startsWith is not a functionI am using PlanetScale and am interested in using `npx drizzle-kit push` to prototype my schema. I Cannot read properties of undefined (reading 'compositePrimaryKeys')My table ```js export const tableName = pgTable( 'table_name', { t1Id: varchar('t1_id'Make varchar field one of string unionI know that CHECK constraint hasn't been implemented yet, but I want to implement a Role field that base generic repositoryHey guys! I'm really struggling to create a base crud repository which i can use as a base class forone-to-many self referenceHello guys, this is a simplified section of my schema: ``` typescript export const contacts = mysqlTEnforcing DB level foreign keysHey guys, I've read the docs on the relation key word and the docs note that the relations are only