I used to use Mootools however I dropped it after bugs with select box .selectedIndex in Safari. I hacked some of the mootools source to fix it, but I don't want to run a customized version on a production server due to upgrade concerns. On a side note, it took mootools over a year to go from 1.11 to 1.2.
I've had way better luck with jQuery. I haven't run into any show-stopping bugs (actually, none at all), and even if I did the releases are much more frequent .
- datetime in MySQL is equal to timestamp in PostgreSQL. There is no equivalent of MySQL's timestamp data type in PostgreSQL
- An enum column in MySQL is equal to a varchar with a check constraint in PostgreSQL, for example: column_name enum('foo', 'bar') is equal to column_name varchar(3) check (column_name IN ('foo', 'bar'))
- The blob datatype in MySQL is equal to a bytea datatype in PostgreSQL
Also, when truncating a table, I do not believe PostgreSQL resets the sequence for serial columns, so it will need to be done manually.
Obviously there are more differences when moving to PostgreSQL, but these are most of the big ones for CREATE TABLE statements.
Just a little FYI. I wrote these all out, but forgot my email. Your blog is very unfriendly to comments without an email, as in I lost my comments.
