Standalone client database for Python?

[Gustavo Campanelli]

What are our options for a standalone (that is one that's not
client/server) easily accesible from Python?
I'm not going to ask for special features as this is only to see what is
avaiable and used (most used most probably meaning well maintained
project).

Thanks in advance

Gedece

[Gerhard Häring]

Re: Standalone client database for Python?

Gustavo Campanelli wrote:[color=blue]
> What are our options for a standalone (that is one that's not
> client/server) easily accesible from Python? [...][/color]

If you need a "real" query language (read: SQL), then I can recommend
PySQLite (http://pysqlite.sourceforge.net/).

-- Gerhard

[Harry George]

Re: Standalone client database for Python?

Gustavo Campanelli <birdiepageANTI @SPAMciudad.FIL TERcom.ar> writes:
[color=blue]
> What are our options for a standalone (that is one that's not
> client/server) easily accesible from Python?
> I'm not going to ask for special features as this is only to see what
> is avaiable and used (most used most probably meaning well maintained
> project).
>
> Thanks in advance
>
> Gedece[/color]

For embedded dbms's, you can get bindings for gdbm, dbm, sqlite.

Maybe you could use a client server after all. E.g., you could set up
postgresql so that only a particular user on the local box can access
the database. In terms of access authorization this is equiv of an
embedded dbms.

For "most maintained", mysql and postgresql would be hard to beat in
client/server space. For embedded dbms's, I'd guess Berkeley DB would
be the winner (http://www.sleepycat.com/)


--
harry.g.george@ boeing.com
6-6M31 Knowledge Management
Phone: (425) 342-5601

[Mike C. Fletcher]

Re: Standalone client database for Python?

Gustavo Campanelli wrote:
[color=blue]
> What are our options for a standalone (that is one that's not
> client/server) easily accesible from Python?
> I'm not going to ask for special features as this is only to see what
> is avaiable and used (most used most probably meaning well maintained
> project).[/color]

Well, here's what jumps to mind:

PySQLite -- SQL based relational
Metakit -- Direct API based relational, the core library is *very*
widely used.
MkSQL -- Less-heavily-used SQL implementation on top of Metakit
Gadfly -- SQL based IIRC, never actually used it myself, is now
distributed with Zope 3 IIRC
KirbyBase -- Never used it, but apparently embeddable

AnyDBM -- e.g. BSDDB, very low-level string:value on-disk-dictionary
mechanisms
mxBeeBase -- low level mechanism for creating databases

Also, as a general rule, you can answer these kinds of questions by
browsing Parnassus', which is quite a useful little resource.

http://www.vex.net/parnassus/

Have fun,
Mike

_______________ _______________ _________
Mike C. Fletcher
Designer, VR Plumber, Coder

http://members.rogers.com/mcfletch/

[Thomas Guettler]

Re: Standalone client database for Python?

Am Wed, 17 Dec 2003 12:07:01 -0300 schrieb Gustavo Campanelli:
[color=blue]
> What are our options for a standalone (that is one that's not
> client/server) easily accesible from Python?
> I'm not going to ask for special features as this is only to see what is
> avaiable and used (most used most probably meaning well maintained
> project).[/color]

If you don't need a relational database (SQL)
you can look at ZODB.

It is easy accesible from python since
it is coded in python.

thomas

[Aaron Watters]

Re: Standalone client database for Python?

Harry George <harry.g.george @boeing.com> wrote in message news:<xqxfzfjlp fg.fsf@cola2.ca .boeing.com>...[color=blue]
> Gustavo Campanelli <birdiepageANTI @SPAMciudad.FIL TERcom.ar> writes:
> For "most maintained", mysql and postgresql would be hard to beat in
> client/server space. For embedded dbms's, I'd guess Berkeley DB would
> be the winner (http://www.sleepycat.com/)[/color]

Mysql and postgressql are also huge and complicated and not
easily distributed (eg if you want to install on both windows
and unix), unless something has changed. Berkeley DB is more
correctly called a btree and indexing library rather than a
true database in the tradition of SQL databases.

My favorite of courseis gadfly http://gadfly.sourceforge.net
which is

- small
- 100% python (with an optional add on C module for speed)
- SQL based, with recovery and transaction support
- in memory (so it's not appropriate for huge databases,
but it's pretty fast for small ones)
- originally written by me :)

I've also heard good things about pySQLLite and metakit although
they both require installing extension modules and supporting
libraries.

Lately I've been working on http://xsdb.sourceforge.net which is
also 100% python but more appropriate for larger databases.
Just added support for using berkeley db as a back end (in CVS).
I'm hoping to bridge xsdb and gadfly together at some point :).

-- Aaron Watters

===
nothing exceeds like excess

[Uwe Grauer]

Re: Standalone client database for Python?

Hi Gustavo,

I am using Firebird 1.5 RC7.
Very nice and Open Source.
see: http://www.firebirdsql.com

Uwe

Gustavo Campanelli wrote:[color=blue]
> What are our options for a standalone (that is one that's not
> client/server) easily accesible from Python?
> I'm not going to ask for special features as this is only to see what is
> avaiable and used (most used most probably meaning well maintained
> project).
>
> Thanks in advance
>
> Gedece[/color]

[Gerhard Häring]

Re: Standalone client database for Python?

Aaron Watters wrote:[color=blue]
> I've also heard good things about pySQLLite and metakit although
> they both require installing extension modules and supporting
> libraries.[/color]

Well, just for clarification: PySQLite does indeed depend on SQLite, but
the Windows binaries are completely standalone - they're statically
linked against SQLite.

Also, SQLite is pretty damn fast and scales to multi-gigabyte databases,
on disk or in-memory.

-- Gerhard

[mir nazim]

Re: Standalone client database for Python?

Gustavo Campanelli <birdiepageANTI @SPAMciudad.FIL TERcom.ar> wrote in message news:<brps08$fe 9$1@taurus.webc orp.pl>...[color=blue]
> What are our options for a standalone (that is one that's not
> client/server) easily accesible from Python?
> I'm not going to ask for special features as this is only to see what is
> avaiable and used (most used most probably meaning well maintained
> project).
>
> Thanks in advance
>
> Gedece[/color]

hi,
well if u don't want SQL based database there is one called KirbyBase.
it is written in python. it is a single file. sample multiuser server
is included.i have not used it but may be helpful for u. u can find
it here.

https://www.netpromi.com/kirbybase.html