News for hackers. Stuff that matters.

A comment on My Notes on Gitlab's Postgres Schema Design (2022). Parent comment

Re:My Notes on Gitlab's Postgres Schema Design (2022) by tengbretson on Saturday February 17, 2024 @07:56PM (#39415049)
In JavaScript land, postgres bigints deserialize as strings. Is your application resilient to this? Are your downstream customers ready to handle that sort of schema change?

Running the db migration is the easy part.

[ Parent | on HN ]
Re:My Notes on Gitlab's Postgres Schema Design (2022) by Rapzid on Saturday February 17, 2024 @08:17PM (#39415191)
Depends on the lib. Max safe int size is like 9 quadrillion. You can safely deserialize serial bigints to this without ever worrying about hitting that limit in many domains.
[ Parent | on HN ]
Re:My Notes on Gitlab's Postgres Schema Design (2022) by duskwuff on Sunday February 18, 2024 @12:14AM (#39416414)
> Max safe int size is like 9 quadrillion.

2^53, to be precise. If your application involves assigning a unique identifier to every ant on the planet Earth (approx. 10^15 ≈ 2^50), you might need to think about this. Otherwise, I wouldn't worry about it.

[ Parent | on HN ]