02 Dec 2005Switch from Mysql to Postgres?
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.