SQL Keys in Depth


82 bookmarks. First posted by briantrice january 2018.


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
Feistel cipher
databases  sql 
january 2018 by dmccallum
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 
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
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 alexdunae
SQL Keys in Depth via Instapaper http://ift.tt/2DKOW1V
sql  database 
january 2018 by alexrudy