Database experiences in Python: Good or Bad?

[Brad Clements]

I'm currently the maintainer for gvIB (Interbase/Firebird DA for Python) and
gvibDA (for Zope), originally done by Bob Tierney at Going Virtual (thanks
Bob!)

I had started with Kinterbas but had some problems, so when gvIB was
released I switched.

Anyway ... I'm using Firebird (formerly was using Interbase) on Linux with
Python and Zope in about 6 commercial projects.

I am starting to run into problems -- mostly due to the lack of threading
support in the Interbase/Firebird client library (gds.so)

There are some problems with having multiple database connections from the
same process, even if these connections are used "one at a time" through a
lock.

If I had the time, I'd try to fix gds itself, but I don't have any more free
time and can't get my clients to pay for it.

The firebird site isn't helpful, just lists it as a bug and I can't see any
discussion on the issue.

I'd consider switching if I could find another database that supports
transactions, same datatypes, good performance and low cost.

--
Novell DeveloperNet Sysop #5

_
"John Hall" <wweexxsseessssaa at telusplanet.net> wrote in message
news:b5ovku0l8qsaou61fhv75i8atl8l5hin0n at 4ax.com...
> Does anyone know if/how well Python plays with Firebird?
> (Firebird is an OSS DBMS derived from an Open version of
> Borland/Inprise/Borland's Interbase.)
> http://firebird.sourceforge.net/
> http://www.ibphoenix.com/
>
> I feel that Firebird is 'better' by several measures than MySQL and
> PostgreSQL, particularly on Windows, but being better does not count
> for much unless it's also fashionable, which it isn't, yet.
>
> I already have more unknowns than I'd like in a project I'm working
> on, so if Firebird/Python is currently dubious, I'll stay with MySQL
> for now, and consider changing the DB later.
>
> --
> John W Hall <wweexxsseessssaa at telusplanet.net>
> Calgary, Alberta, Canada.
> "Helping People Prosper in the Information Age"




-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
   http://www.newsfeed.com       The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----