James Harper <james@ejbdigital.com.au> writes:
James Harper <james@ejbdigital.com.au> writes:
Is there any project to build a mysql emulation layer for postgres? All my searches come up with the April1 post from a few years ago.
Would anyone else find such a thing useful? I have a few servers where I'm running mysql only because the application I am using demands it (wordpress, mainly).
For something simple like Wordpress, it's probably not hard to just patch wordpress to make it work, but in the general case, there's a lot of odd coner case behaviour in MySQL that likely makes it hard to do.
What sort of behaviour?
I wrote a plugin for postgres a while back that would allow you to point an MSSQL application at it (eg it listened on port 1433 and pretended to be MSSQL). It worked for some basic stuff but got too complicated and I never got around to refactoring it. In particular matching up the various locking and isolation levels was never going to be perfect, so it would only work for pretty basic applications.
https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html and https://dev.mysql.com/doc/refman/5.0/en/differences-from-ansi.html are good places to start. There's some behaviour that is probably safe to ignore. I'd look at things around data types though, there's some corner cases with dates, times, IIRC DECIMAL/float things that may/may not translate well, and apps may/may not care about. -- Stewart Smith