42
The perils of UUID primary keys in SQLite (andersmurphy.com)
submitted 5 months ago by to c/programming@programming.dev
21 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] 2 points 5 months ago (2 children)

Can't you just reserve X bits of the primary key to store a shard ID?

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 2 child comments
    •
  • [–] 3 points 5 months ago

    If you are owning every little part of the design in every nuance, sure. But how do you configure this in mysqll, postgres, etc etc. does your favorite framework support this easily.

  • permalink
  • fedilink
  • source
  • parent