rynt at yahoo9.com
Mon Mar 14 16:10:28 CET 2005
<andrea_gavana at tin.it> wrote in message
news:mailman.290.1110580373.1799.python-list at python.org...
I am still quite a newbie with Python (I intensely use wxPython, anyway).
I would like to know what are, in your opinions, the best/faster databases
that I could use in Python (and, of course, I should be able to "link"
with a wxPython GUI)? Specifically, I work on Reservoir Simulation, and
usually I have to store a discrete/huge amount of data (it depends on the
oil field). As you may have understood, I know almost NOTHING about
In general, my data will be numeric (floats, integers). Will a binary
(if it is possible) reduce the size of the DB? And what about speed in
Thank you a lot for every suggestion.
One thing you should consider, maybe the MOST important - What kinds of
reports are you/your bosses expecting to get out of your application? Are
you going to write the reports by hand? They can be a pretty expensive
proposition in terms of development time and energy.
Most RDBMS's meet your criteria of speed, numeric data, etc. I would
strongly encourage you to look into a database that can be accessed easily
by some kind of report writer such as Crystal Reports, or MS-Access, or some
of the other fine report writers out there. Unless of course you plan to do
all the heavy work of hand writing all your reports. Your bosses may ask
you to graph the data as well. Oracle(if you can afford it), MS-SQLServer,
MySQL, PostgreSQL, Even the Free MS-MSDE/SQL Express would work for you.
Most report writers have hooks to these DBMS's, or can use ODBC to get to
Granted, you have said that you know almost NOTHING about databases, but it
sounds to me like your app is a prime candidate for one, so maybe it's time
to learn. ;-) And, in my experience, sometimes the smallest project can
wind up a major project depending on how important or critical the need for
the data and it's presentation is. And no matter what reports you produce,
you'll always be called upon to produce more!
More information about the Python-list