There is a python database SIG (Special Interest Group) which seems to
be better place to ask this kind of questions 
From: Brendan J Simon [mailto:brendan.simon@bigpond.com]
This is probably more of a python question rather than a wxpython
question, but there may be a wx solution that is more appropriate.I'm looking to use a database with wxpython to table and graph some
information. I know that mysql and postgresql are available
with python
bindings, at least on linux. Does anyone know if they are
available on
other platforms such as MSW, MacOS, etc. I'm pretty sure MySql is
available for MSW.
Availability of mysql on MSW isn't even a python question - it's a mysql
question ;). From
http://www.mysql.com/downloads/mysql-3.23.html
you can learn that MySQL IS available on both MSW and MacOS (and many
other platforms, too). And I know nothing about PostgreSQL (but seems
that it is supported on MSW via cygwin).
So, what is the best cross-platform database? ie. the best database
engine that is useable on multiple platforms and has python bindings ?
I think most people will answer that this depends on your demands. And
this is true ;). There is no best editor, best database or best
programming language (i'm not pretty sure about the last one).
I think most databases are supported by python. There also is several
SQL server implementations written in pure python (gadfly among them).
Does wxWindows have DataBase support and if so does wxPython support
access to it ?
I think it is not an accurate question. What do you mean by "Database
support"? There is a project, GNUe, which helps creating wxPython
interfaces to databases, though it's still in alpha stage.
What about MS-Access on MSW machines. Is it a good idea to
use this DB
on that platform and other DBs on other platforms. If so,
then I would
want a wx solution which hides the specifics of each DB.
I personally don't think so. MS-Access is not very well suited for
multi-user access - it's hard to impossible manage user privelegies in
it.
I would suggest pure python database, if you demands on speed & size &
number of users are low; otherwise, use MySQL (but it lacks many sql
features).
Thanks for any help or advise.
Brendan Simon.
You are welcome.
--Victor.
···
-----Original Message-----