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

[Steve Spicklemire]

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

On Monday, November 26, 2001, at 11:13 PM, Michal Seta wrote:

> And how about gadfly?
> it works on a Mac and it's SQL-aware.  It's called kwP now.  And isn't 
> ZODB
> based on gadfly?
> Sorry if I'm completely off.
>
> ./MiS
>
> On 11/26/01 1:53 PM, Tom Loredo @ loredo@astrosun.astro.cornell.edu 
> wrote:
>
>>
>> Hi-
>>
>> If you need SQL-ish capability, this won't help you.  But if you
>> just need a handy and very Pythonic way to store and retrieve
>> objects, I've compiled the Zope Object Database (ZODB) for
>> the Mac.  I will put it online soon, but I'm swamped this week
>> (and out of town most of it), so it won't happen for at least
>> a week.  If you need it more quickly, drop me an email and
>> I'll try to email you a Stuffit file.  It is for MacPython 2.1.1
>> on the PPC.
>>
>> -Tom Loredo
>>
>> _______________________________________________
>> Pythonmac-SIG maillist  -  Pythonmac-SIG@python.org
>> http://mail.python.org/mailman/listinfo/pythonmac-sig
>>
>
>
> _______________________________________________
> Pythonmac-SIG maillist  -  Pythonmac-SIG@python.org
> http://mail.python.org/mailman/listinfo/pythonmac-sig