Databasen - Revisited
andy at hexten.net
Thu Oct 19 11:24:19 BST 2006
On 19 Oct 2006, at 11:12, Peter Corlett wrote:
> While we're on about terrible not-quite-open source products,
> Movable Type
> is a right crock too. And it also has some rather quaint ideas as
> to what a
> database is. It doesn't mark primary keys with SERIAL, for example.
> I assume
> that they manually insert NEXTVAL('mt_blah_id'), and probably in a
> way prone
> to race conditions and ignoring errors if the few bits of an existing
> installation I've had to debug is any guide.
That's an alarmingly common idiom in badly written webby code -
either that or trying to work out what the inserted ID was by doing
SELECT MAX(id) just after the insert. Racetastic.
Andy Armstrong, hexten.net
More information about the london.pm