MySQL is my database of choice, but to get through the blog sample, I've used Postgres since this is a "known working config". The first issue I ran into is that the syntax in the example is specific to Postgres 8.x and I happened to have 7.4 installed.
Since I'm not as familiar with running postgresql as mysql, there was considerable pain in getting the server setup properly. I know this isn't the responsibility of the phocoa project, but a short primer and/or cheat sheet on getting a working server config would really be helpful. Some of the struggles I found were setting passwords and access permissions.
Chris
Hmmm. Well you could use it with mysql and just fix the queries that are generated for postgres. I should be able to generate appropriate code for any db, just haven't bothered to yet, but it should be trivial to just fix those errors, they should be very rare.
As for setting up postgres, there isn't much to it the way I do it. I use either yum on linux or macports on mac and it kinda does everything for you, and just tells you to run a few commands once it's built...
You are right it can be tricky but recent versions are quite automated unless you're building from source.
Alan
This Topic Is Locked To Guest Posts
It's been a while since this topic was active, if you'd like to get it going again, please post as a registered member
