CodeSOD: Joined Up

AI Briefing

• – Bjørn suggests using UUIDs for non-primary key columns to avoid auto-incrementing IDs, which are large and expensive.
• – He proposes using auto-incrementing IDs for primary keys and only using UUIDs for cross-reference tables to facilitate queries.
• – Bjørn argues that following his design for cross-reference tables, even if it's unconventional, is a better approach than having a single, all-encompassing rule.