4 ms·

I stopped reading at "Traditional SQL uses related tables connected by IDs" ... that's what ends up with databases designed with pointless auto-incremented prox

• redis_mlc 6y ago
  > I stopped reading at ... Always the sign of a moron. > that's what ends up with databases designed with pointless auto-incremented proxy-primary keys You're actually very incorrect about them being pointless: - databases will assign an implicit numeric id (row id) if you don't (ie. that's what MySQL InnoDB does.) But it may be hidden and unusable if internally-generated, so you just screwed yourself. https://blog.jcole.us/2013/05/02/how-does-innodb-behave-without-a-primary-key/ https://blog.jcole.us/2013/05/02/how-does-innodb-behave-with... - sorting a numeric id is always faster than a long string - most database mgmt. tools require a table numeric primary key to work at all. But cheer up. In one or two decades, you'll be right. Source: DBA.