Iain,
iain duncan wrote:
A little off topic, but I'm not sure where else to get practical
feedback on this. I've got a booking system that will be run on OS X
with a local database. I'm a relatively experienced python developer,
but an os x newbie, and would like the whole thing to be as idiot proof
as possible. Anyone have suggestions on what they have found to work
well for that sort of thing? I'm used to using MySQL for web dev but
installing the python mysql drivers on os x was painful.In use right now are:
python2.5, from mac universal binary
wxpython2.8, from mac universal binary
FormEncode - from setuptools ( if you haven't checked it out, it's
great! )
SQLAlchemy0.4.3 - from setuptools
MySQLdb - manual compile required with extra symlink in the system, ugh!and likely Paramiko for remote backups, but that could run separately.
Also, in some cases this system may be deployed so that others can
connect to the database, if this would change your recommendation, I'd
love to hear that too.
I would suggest that you look at Firebird SQL.
It is supported by SA, I am just switching over from another ORM to SA.
I only use it on Windows (just remember to turn on "Force Write"), did a bit of testing on Ubuntu.
On my dev machine I use the full server, so I can access the db using tools like IBExpress as well as with the application.
For deployment I use the embedded version of FB, but this one only allows one process to access the db.
With the latest version (2.1) they do have MacOSX builds - IIRC this support is relatively new.
Werner