DT
Drizzle Team•2mo ago
B33fb0n3

Drizzle doesn't know how to serialize a bigint

When using a defaultValue for a bigint like this: 
storage: bigint('storage', {mode: 'bigint'}).default(262144000n).notNull(), // 250mb in bytes
storage: bigint('storage', {mode: 'bigint'}).default(262144000n).notNull(), // 250mb in bytes
I will ge the following error when generating the schema: 
TypeError: Do not know how to serialize a BigInt
TypeError: Do not know how to serialize a BigInt
I am using postgresql
Solution:
Try without the n ? I guess it is only a JS thing right?
Jump to solution
5 Replies
B33fb0n3
B33fb0n3•2mo ago
bump
rphlmr ⚡
rphlmr ⚡•2mo ago
Hello, Would you try this? 
.default(sql`'262144000n'::bigint`)
.default(sql`'262144000n'::bigint`)
B33fb0n3
B33fb0n3•2mo ago
Yes, that works! But only for the drizzle kit. When I try to push it, I get the following error: 
error: invalid input syntax for type bigint: "262144000n"
error: invalid input syntax for type bigint: "262144000n"
Solution
rphlmr ⚡
rphlmr ⚡•2mo ago
Try without the n ? I guess it is only a JS thing right?
B33fb0n3
B33fb0n3•2mo ago
That worked 🥳 I guess it is, yea. Thanks for your help ❤️
Want results from more Discord servers?
Add your server
More Posts
need help with drizzle transactions and foreign key constraintsI have a circular database schema: `service` references one `service_generation` (as the `latest_genHaving an issue with sqlite running `drizzle-kit generate`.Having an issue with sqlite running `drizzle-kit generate`. I get the following output ``` drizzle-upsert with excluded using column nameI'm trying to do a an upsert like so ```js await db.insert(user).values(values).onConflictDoUpdate({Not detecting changes in schema (postgres)Pic 1: On first drizzle-kit generate, it generated the sql as expected Pic 2: On 2nd drizzle-kit geIntrospection generates invalid typescript codeExample in photoconnection poolerWhats the correct way to connect to postgres using pgbouncer as a connection pooler? should we use hUnable To push updates to my DB. Maybe issue with the versions?A few things seem to be going wrong for me. 1. I went to push some schema changes to my drizzle db quick help with select()I'm sure there's something I can do about this, I'm just not sure. I've got a couple of tables, `paDuplicate statements after adding .unique()Starting from a schema that is entirely synced, I add one `.unique()` constraint on one of my columnBigint in SQLite results in "TypeError: Do Not Know how to serialize a BigInt"It's failing in this section of my schema: ```ts const users = sqliteTable("users", { balance: blo