Databasen - Revisited

[Andy Armstrong]

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