News for hackers. Stuff that matters.

A comment on The perils of UUID primary keys in SQLite. Parent comment

Re:The perils of UUID primary keys in SQLite by ysleepy on Saturday June 06, 2026 @07:33AM (#48423899)
Maybe you could explain why one would use "without rowid" in the first place.

I get saving 8 bytes per row seems attractive, but the tradeoff is not explained.

[ Parent | on HN ]
Re:The perils of UUID primary keys in SQLite by andersmurphy on Saturday June 06, 2026 @11:25AM (#48425938)
Update the article there's now a section for UUID4 with rowid. It's less bad than UUID4 without rowid but it's still about 4-6x slower than UUID7 without rowid.
[ Parent | on HN ]