News for hackers. Stuff that matters.
Re:SQL style guide by comboy on Sunday October 09, 2016 @02:28PM (#12672558)
Maybe what author means is that from the db design standpoint, composite keys are used much less often than they could be. Very often unique table row can be defined by some other column or a pair, on which you will probably put an index anyway.

But that's just playing devil's advocate. In general I think ids are fine because ORMs play nice with them and FKs are simple.

Re:SQL style guide by Treffynnon on Monday October 10, 2016 @12:40AM (#12675080)
Basically this is the answer - besides that bit about acquiescing to the demands of an ORM.