Database Design Advice
matt.lawrence at virgin.net
Mon Nov 18 13:04:14 GMT 2013
On 18/11/13 11:18, Philip Skinner wrote:
> Auto-increment a double column primary key, something like:
> uid int(11) not null auto_increment, revision int(11) not null
> auto_increment, primary key(uid, revision)
> ; works in mysql. You won't have your concurrent query issues there,
> for the most part anyway. Maybe marking a records as tainted.
As far as I know that only works with MyISAM in mysql. It certainly
doesn't work like that in Postgres.
More information about the london.pm