Well, I'm still trying to push some fixes into the wp core that would make db abstraction easier, but until then here is the wordpress 1.5.3 version of the files for the hack. for a new installation it's the same as always - if you're upgrading and using the hack, first upgrade using the official wordpress download, then unzip the hack and drop the changed files over top - should be no problems now :)
The changelog has all pertinent changes in it
BTW, I don't know why you people think the sqlite pragma command 'PRAGMA short_column_names = 1' is for sqlite 3 only - it's not, in fact unless you're using pdo or doing some strange compiling you can't USE sqlite 3 with php - it's for 2 !
Here are the 1.5.3 Hacked files, enjoy!
This site is now running the hack - maybe later this week I'll take a look at all the sql problems that are blocking good abstraction 1. the idiots who are using show table status to do the work of last_insert_id or select max()
2. although this only affects postgres - there are some problems with order by combined with group by and aliasing of tables
fun fun - if they'd fix the show table status stuff sqlite could have almost all the preg match stuff taken out
fixing the queries for postgres might be a bit harder
just for fun I've been running mysql in ansi mode and seeing what breaks
edit: changed download location