News for hackers. Stuff that matters.

A comment on You might as well timestamp it. Parent comment

Re:You might as well timestamp it by marcosdumay on Saturday April 24, 2021 @10:48AM (#26925239)
> Serial IDs won't scale

You mean scaling into several machines? Yes, they do scale. Nothing requires that the values are always increasing and have no holes, so you can slice and cluster them at will (and many DBMS do exactly that).

[ Parent | on HN ]
Re:You might as well timestamp it by gmfawcett on Saturday April 24, 2021 @11:50AM (#26925803)
I'm confused? Serial means "always increasing and having no holes" -- it's one thing after the other. What you're arguing for sounds like just IDs, not serial IDs.
[ Parent | on HN ]
Re:You might as well timestamp it by marcosdumay on Saturday April 24, 2021 @12:20PM (#26926055)
Well, by your definition what people use as serial IDs isn't serial.

Databases have the concept of sequences, that are closer to your definition, but make no promises about holes (they normally don't generate holes by themselves, but there is no way to guarantee you won't lose numbers upon usage). It is common to use sequences to feed serial IDs, but not all DBMS do that and it's not a requirement in any way.

[ Parent | on HN ]