News for hackers. Stuff that matters.

A comment on /story/39313623. Parent comment

Re: by ildjarn on Saturday February 10, 2024 @07:42AM (#39325764)
Serial index forces a synchronisation point on every entity that can create records. If this is only ever a single database that’s fine but plenty of apps can’t scale this way.
[ Parent | on HN ]
Re: by marcosdumay on Saturday February 10, 2024 @09:50AM (#39326513)
They don't. Clustered databases deal with parallel generation of them just fine.

They require periodic synchronization. What isn't a big deal at all and is required by many other database features.

[ Parent | on HN ]
Re: by sgarland on Saturday February 10, 2024 @12:25PM (#39328150)
If you have a sharded DB, each instance can get its own range of ints, which are periodically refreshed.

PlanetScale uses int PKs [0], and they seem to have scaled just fine.

[0]: https://github.com/planetscale/discussion/discussions/366

[ Parent | on HN ]