86 bookmarks. First posted by briantrice january 2018.
After wading through sixty-four articles, skimming sections in five books, and asking questions on IRC and StackOverflow I think I’ve put the pieces together and have a recommendation to harmonize the various camps. Many arguments about keys boil down to false dichotomies and failures to acknowledge other points of view.
database
postgres
postgresql
sql
7 weeks ago by dagh
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?
Database_Performance
MySQL
SQL
Database
march 2018 by GameGamer43
What database keys really are, and how to use them effectively.
database
article
reference
sql
postgresql
february 2018 by davidgasperoni
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…
from instapaper
january 2018 by adamlogic
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?
Archive
january 2018 by plouf
PostgreSQL keys. Good article about when you should use keys etc.May be important in job interviews.
database
sql
PostgreSQL
january 2018 by lost_in_space
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…
from instapaper
january 2018 by danbee
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…
from instapaper
january 2018 by rogerhsueh
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?
Pocket
january 2018 by iiska
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?
After wading through sixty-four articles, skimming sections in five books, and asking questions on IRC and StackOverflow I think I’ve put the pieces together and have a recommendation to harmonize the various camps. Many arguments about keys boil down to false dichotomies and failures to acknowledge other points of view.
sql
design
databases
postgresql
profdev
After wading through sixty-four articles, skimming sections in five books, and asking questions on IRC and StackOverflow I think I’ve put the pieces together and have a recommendation to harmonize the various camps. Many arguments about keys boil down to false dichotomies and failures to acknowledge other points of view.
january 2018 by Chirael
After wading through sixty-four articles, skimming sections in five books, and asking questions on IRC and StackOverflow I think I’ve put the pieces together and have a recommendation to harmonize the various camps.
database
sql
january 2018 by Tafkas
tags
101 1801 archive article begriffs bestoftheweb bestpractices concepts data database databases database_performance data_science db dba design dev development er_modeling ids indexes info joenelson key keys learning mysql performance pocket postgres postgresql primary-key profdev programming read reference schemas sql sqlserver tech tutorial uuid via:popular