[wxpython-users] a bit OT, db for deploying w/ wx on OS X?

[Werner F. Bruhin]

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