I’ve now got a tool (almost complete) that slurps in a MySQL DB definition and spits out one for Postgres. I will post a link to it when I get creation of the enum tables working. (Instead of enums, Postgres uses constraints and extra tables.)
Eric Hodel has written 3 entries about this goal
I had a few problems moving to FreeBSD 5 with MySQL, which ultimately caused by was shoddy code in InnoDB.
I just rewrote all our in-code SQL queries to be easily recognizable. They now all live in
FOO = <<-SQL
SELECT blah
FROM there
WHERE x = 1
SQLThis will help us with moving away from MySQL.
Bob has also been exploring Postgres performance, but his results are preliminary
Eric Hodel has gotten 4 cheers on this goal.
Chuq (username: yakuza) cheered this 2 years ago
Knit Geek cheered this 3 years ago
batkins cheered this 3 years ago
dagvl cheered this 3 years ago
