Looking for a database. Sugestions?

[ionel]

I'm looking for a thread-safe database.
Preferably an embedded, sql database.

What are the best choices in terms of speed ?

--
ionel.

[Paul McGuire]

SQLite is very easy to get started with. I loaded up a 9 Mb file of
process data and the performance was pretty good after I indexed on the
join columns (increased db file size to 15Mb).

Supports transactions, cursors, typed data. I *think* it is
thread-safe, but I'm not positive.

But it's great as a simple embedded SQL database.

-- Paul

[gsteff]

SQLite rocks, its definitely the way to go. Its binary is around 250K,
but it supports more of the SQL standard than MySQL. It CAN be thread
safe, but you have to compile it with a threadsafe macro enabled..
check out www.sqlite.org for more info. The windows binaries
apparently are compiled with this option, but the Linux binaries are
not, so if you're on Linux, you'll have to compile it yourself, which
isn't hard.

[Jeff Shell]

If it's embedded, is there any reason why it should be SQL? A solid
alternative could me MetaKit, which has Python bindings:

http://www.equi4.com/metakit/python.html

"""
Buzzwords - Metakit is an embeddable database which runs on Unix,
Windows, Macintosh, and other platforms. It lets you build applications
which store their data efficiently, in a portable way, and which will
not need a complex runtime installation. In terms of the data model,
Metakit takes the middle ground between RDBMS, OODBMS, and flat-file
databases - yet it is quite different from each of them.

Technology - Everything is stored variable-sized yet with efficient
positional row access. Changing an existing datafile structure is as
simple as re-opening it with that new structure. All changes are
transacted. You can mix and match software written in C++, Python, and
Tcl. Things can't get much more flexible...
"""

I've never tried MetaKit (most of my development has been against the
ZODB object database, or against RDBMS servers), but I've heard good
things about it.

[Gerhard Häring]

Ed Hotchkiss wrote:

On 15 Sep 2005 21:31:27 -0700, *gsteff* wrote:

SQLite rocks, its definitely the way to go. Its binary is around 250K,
but it supports more of the SQL standard than MySQL. It CAN be thread
safe, but you have to compile it with a threadsafe macro enabled. [...]

Is this for running an SQL database, then using a separate python
module to access the database?

SQLite being an embedded database, if you use it via pysqlite
(http://pysqlite.org/), it is part of your Python application, i. e.
there is no separate SQL server and client, the SQL engine is just part
of your application and the data is located in one local file.

pysqlite itself is a little larger than SQLite, of course, for example
the statically linked binary extension module on Windows is 331.776
bytes in the latest version:

C:\>dir c:\Python24\lib \site-packages\pysqli te2
Datenträger in Laufwerk C: ist Lokaler Datenträger
Volumeseriennum mer: 8C7F-873C

Verzeichnis von c:\Python24\lib \site-packages\pysqli te2

26.08.2005 11:00 <DIR> .
26.08.2005 11:00 <DIR> ..
16.05.2005 21:11 2.525 dbapi2.py
12.09.2005 10:49 2.425 dbapi2.pyc
12.09.2005 10:49 2.425 dbapi2.pyo
26.08.2005 11:00 <DIR> test
12.09.2005 00:56 331.776 _sqlite.pyd
16.05.2005 21:11 1.016 __init__.py
12.09.2005 10:49 131 __init__.pyc
12.09.2005 10:49 131 __init__.pyo
7 Datei(en) 340.429 Bytes
-- Gerhard

[Jorgen Grahn]

On 15 Sep 2005 22:22:30 -0700, Jeff Shell <eu*********@gm ail.com> wrote:

If it's embedded, is there any reason why it should be SQL? A solid
alternative could me MetaKit, which has Python bindings:

Or Berkeley DB, which has bindings in the standard Python library: the bsddb
module.

But we know almost nothing about the original poster's requirements, so
any advice may be completely meaningless.

/Jorgen

--
// Jorgen Grahn <jgrahn@ Ph'nglui mglw'nafh Cthulhu
\X/ algonet.se> R'lyeh wgah'nagl fhtagn!

[Jarek Zgoda]

ionel napisa³(a):

I'm looking for a thread-safe database.
Preferably an embedded, sql database.

What are the best choices in terms of speed ?

Interbase/Firebird is thread-safe, is SQL-compliant. And once it was
embedded. In a tank. M1 Abrams, specifically. At least the tale tells
that... ;)

--
Jarek Zgoda
http://jpa.berlios.de/