[Pythonmac-SIG] Silly question? Database server (Mac OS 9 / Mac OS x / PC-Win)

[Bob Savage]

on 12/7/01 10:00 AM, Schollnick, Benjamin wrote:

> Guys,
> 
> I'm running into a situation where I'd like to interface with a database
> (preferably SQL based).... But since I'm planning this to be multiplatform,
> I'm not sure what's available for both Mac OS (9 & X) & the wintel
> platforms...

This was a big weakness that OS 9 had. MacOSX has at least 4 more SQL-based
databases that I know of:
MySQL -- free
PostGresQL -- free
OpenBase -- commercial
FrontBase -- commercial

I recently installed PostGresQL on my iBook and it works great, but you have
to do a few mysterious things to get it setup. Both PostGresQL and MySQL are
available already compiled. Also there was an article on Apple's website
that I found very useful for setting things up:

http://developer.apple.com/internet/index.html

There is a tutorial on setting up MySQL linked from this page (as "Open
Source Databases").

Both MySQL and PostGresQL have Python bindings (here is one I found for
PostGres: http://sourceforge.net/projects/pypgsql/ )

As far as I know both PostGresQL and MySQL have support for Unix, MacOSX,
and Windows. I don't know about the commercial databases because I am too
cheap :)

Best of luck!

Bob