Switch from Mysql to Postgres?
Posted by Peter Donald Fri, 02 Dec 2005 04:45:00 GMT
Most of my personal applications require a small database that enforces foreign key constraints and has a reasonably standard SQL interface. Mysql 4.1 + Mysql Front have served me well but recently I have been getting the dreaded Lost connection to MySQL server during query error. I believe it is a problem with the drivers I am using but I am still digging to find the cause of the error.
I have contemplated the switch to Postgres as my database of choice; It feels like a much more mature offering and has far more liberal license . I would not miss out on having a nice graphical front end as there is a number available (PGnJ , pgAdmin , EMS SQL Manager for PostgreSQL).
After the initial period of cognitive I expect I will be happy with Postgres so maybe this mysql driver error is the kick I need to finally make the move.
Trust me…PostgreSQL is a much more capable, reliable, and user-friendly database. I made the switch two years ago and couldn’t be happier. Additionally, the PostgreSQL community is super friendly and helpful, and the license leaves no bad taste in your mouth or feeling of living in a gray area, as MySQL’s does.
Good luck, John
John
I have just converted all of my database schemas across to using the database agnostic schema class and migrations which will hopefully make the change as painless as possible.
Peter