1
SQL Keys in Depth
The internet is full of dogmatic commandments for choosing and using keys in relational databases. At times it verges on a holy war: should you use natural or artificial keys? Auto-incrementing integers, UUIDs?
Joe Nelson
- Popular posts
- 21
- Total points
- 4,728
- HN comments
- 1,930
- Rank
- #243 personal
Visit begriffs.com → RSS feedOn Hacker News Apr 2015 – Nov 2024
Software Engineering 16Systems & Performance 6Tools & Productivity 3Life, Learning & Writing 3Databases & Data 3Web & Frontend 2
2
User-defined Order in SQL
Some applications, such as todo lists, need to maintain a user-defined order of items. The challenge is that the order is arbitrary and can change when the user rearranges items:
3
Practical Guide to SQL Transaction Isolation
You may have seen isolation levels in the documentation for your database, felt mildly uneasy, and went on with life. Few day-to-day examples of using transactions really mention isolation. Most use the database’s default isolation level and hope for the best. It’s a fundamental topic to understand however and you’ll…