PostgreSQL support for WikkiTikkiTavi

Filed under: Programming · Date: Sun Jul 18 17:53:08 2004

PostgreSQLI've hacked PostgreSQL support for WikkiTikkiTavi (also known as 'Tavi). This is only a quick hack, but it seems to work. There are issues, which you can read from the download page.

The patch is not complete, but since there's been little going on in the database independence page, I decided to hack the source to get support quickly for PostgreSQL. If you find any bugs, or have any suggestions, send me mail or comment here. Please note: this is experimental work and should not yet be considered for production use.

Go get the patch: PostgreSQL patch for Tavi.

Update Update: The patch has been fixed with regard to maintain() function and data in rate table.

Update Update 2/28/2008: Patch link fixed. The old download page has been removed.

Looks like MySQL works in really bizarre way. No wonder why people find it difficult to support MySQL with other databases. Tavi has a table with timestamp attribute. It has default value of NULL, but when the SQL query explicitly sets the timestamp to a NULL value, MySQL updates it to the current timestamp. You can't beat that kind of logic simply by validating the SQL query. Now the timestamp is explicitly set on PostgreSQL. The MySQL end still relies on this quirk.

From MySQL to PostgreSQL

Articles and code to help porting MySQL software to PostgreSQL.


Comments are disabled for this post.