Hacker News Reader

It would be great if this evolves to support mysql to postgresql and mysql to sqlite.

Then we can finally have multiple database engine support for WordPress and others.

It is always the edge cases that will kill you. In the case of WP on PostgreSQL, the reason you want WP in the first place is the plugins and those will be hit or miss on PostgreSQL. Just give up on the combination of those two.

Isn't there an adapter from mysql-to-postgres which would essentially mimic all the quirks in mysql onto an actual postgres?

I believe this is what Janus (NEXTGRES) does.

To clarify, the wire protocol is the easy part, the semantic differences how each database does things is a whole other can of worms. Such emulation will never be 100%, quirks and all.

Reply on news.ycombinator.com