10
The perils of UUID primary keys in SQLite
(andersmurphy.com)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 06 Jun 2026
10 points (100.0% liked)
General Programming Discussion
10003 readers
6 users here now
A general programming discussion community.
Rules:
- Be civil.
- Please start discussions that spark conversation
Other communities
Systems
Functional Programming
Also related
founded 7 years ago
MODERATORS
This goes to show that using uuid4 is not a good thing for db tables, but that is what uuid7 was designed for. Also using ROWID or autonumber or whatever built in system the database is using is the best bet. Only use uuid7 if you need distributed inserts and you want the clients to be able to generate their own keys.