[Pythonmac-SIG] Python-friendly Databases for the Mac

[Bob Savage]

'Lo, all.

I did a small program using Gadfly and it worked quite nicely at first, but
as my data collection revved up I blew out the engine's capability, due to
its "in memory" model. If I remember correctly I was adding 10,000
datapoints (records) per month. If you aren't going to have anything near
that number of records, it should be fine. One great thing is it uses the
standard Python database interface, so you could use it to start, and switch
to a different backend that is compliant with Python-DB API 2.0 without much
trouble, if you need to do so later.


best of luck,

Bob

on 11/27/01 4:38 AM, Steve Spicklemire wrote:

> Hi Michal,
> 
> I think Gadfly is a great SQL database for testing, prototyping and
> small/simple production systems. If I recall correctly Aaron Watters
> originally developed it as a teaching tool for a SQL class he was
> teaching. It's provided as an example SQL database (with adaptor) in
> Zope, but is not otherwise used in Zope's internals (e.g., ZODB). It's
> nice since it's written completely in python so you can easily embed it
> in any python application with (essentially) no installation/maintenance
> headaches. It's also pretty darn fast, considering there are no
> extensions involved in it's implementation! It's limitations include the
> fact that all the database data is memory resident, and it doesn't live
> happily in heavily threaded environments (i.e., you can test with it in
> Zope, but don't expect it to work when multiple Zope threads need access
> to the database at the same time!).
> 
> Anyway.. all from memory, but I think mostly right.
> 
> take care,
> -steve