SQL Keys in Depth


75 bookmarks. First posted by briantrice 18 days ago.


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 
yesterday by plouf
PostgreSQL keys. Good article about when you should use keys etc.May be important in job interviews.
database  sql  PostgreSQL 
14 days ago 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
16 days ago by danbee
Feistel cipher
databases  sql 
17 days ago 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
17 days ago 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 
17 days ago 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 
17 days ago 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 
17 days ago 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
17 days ago by alexdunae
SQL Keys in Depth via Instapaper http://ift.tt/2DKOW1V
sql  database 
17 days ago by alexrudy