On 2015-05-21 12:16 PM, James K. Lowden wrote: > On Wed, 20 May 2015 19:05:29 +0100 > Simon Slavin <slavins at bigfraud.org> wrote: > >> Posting this not because I agree with it but because the subject has >> come up here a couple of times. >> >> <https://www.clever-cloud.com/blog/engineering/2015/05/20/Why-Auto-Increment-Is-A-Terrible-Idea/ >>> >> >> "Today, I?ll talk about why we stopped using serial integers for our >> primary keys, and why we?re now extensively using Universally Unique >> IDs (or UUIDs) almost everywhere." > > "A relational database is a graph where nodes are called > entities and edges relations." > > It's hard to know where to start. But that's definitely not it.
Indeed, that article had a rather poor idea what a relational database is. For one thing, it didn't seem to grasp that each entire tuple/row in a relation/table is by definition its own identity. If no subset of attributes/columns is a key, the entire tuple/row can be used to identify which tuple/row you're talking about. -- Darren Duncan