• 0 Posts
  • 259 Comments
Joined 2 years ago
cake
Cake day: July 26th, 2024

help-circle
  • Using integer primary keys often creates race conditions when you have multiple database shards, so UUIDs have become the standard. (2 different webservers can create a record in 2 different database sync that then sync with eachother in the background). Using UUIDs for SQLite is less common though as SQLite mostly used for small or local applications but developers are used to UUIDs now and even consider them the standard for primary keys now.