473,327 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Looking for a database. Sugestions?

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

What are the best choices in terms of speed ?

--
ionel.
Sep 15 '05 #1
6 1550
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

Sep 16 '05 #2
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.

Sep 16 '05 #3
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.

Sep 16 '05 #4
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\pysqlite2
Datenträger in Laufwerk C: ist Lokaler Datenträger
Volumeseriennummer: 8C7F-873C

Verzeichnis von c:\Python24\lib\site-packages\pysqlite2

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
Sep 16 '05 #5
On 15 Sep 2005 22:22:30 -0700, Jeff Shell <eu*********@gmail.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!
Sep 17 '05 #6
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/
Sep 17 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Angie | last post by:
Hello, My name is Angela Mastrodonato. I'm a web designer who would like the assistance of a php programmer. Some of my clients have requested more dynamic web sites, and I am in the beginning...
0
by: ionel | last post by:
I'm looking for a thread-safe database. Preferably an embedded, sql database. What are the best choices in terms of speed ? -- ionel.
3
by: Michael Sherf | last post by:
I'm looking for "real life" experiences of companies running DB2 in an 24x7 OLTP environment. Seems like most folks are using DB2 for DSS applications, rather than OLTP. If your DB2 production...
15
by: Matthias Kwiedor | last post by:
Hi! In my current Project i use MS Access as Database. I know some Databases like SQL Server, Oracle, mySQL and the DB/2 from IBM, but no more "Stand- alone" Databases. Did anyone know a...
1
by: Johann Blake | last post by:
I am looking for a good solution on how to implement data access in an application so that there is a clean separation between the data access layer, the business layer and the GUI layer. I am...
1
by: Shapper | last post by:
Hello, I am looking for a good Menu Control. I found a few ones in Control Gallery of this web site. Some Examples: http://www.telerik.com/Default.aspx?PageId=1415...
2
by: shs | last post by:
Hi, I've got the second db opened from the first db. However after the initial opening of the second db, when loading different forms, they are not visible. I'm using the followig code to open...
1
by: gluchu | last post by:
how to public ms database ? any sugestions ?i have to publish a dynamic page. maybe something in asp or access pages ? i need an instruction step by step . PLEASE help me !
0
by: AMDRIT | last post by:
I am looking for better concrete examples, as I am a bit dense, on design patterns that facilitate my goals. I have been out to the code project, planet source code, and microsoft's patterns and...
2
by: Mephster | last post by:
Hi all I have been going though a booked called "C++ Primer plus" inwhich I got from a second hand store for 2.99CAD anyway after doing some reading and trying everything in the book up to chapter...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.