Flat file, Python accessible database?

[Karlo Lozovina]

I've been Googling around for _small_, flat file (no server processes),
SQL-like database which can be easily access from Python. Speed and
perforamnce are of no issue, most important is that all data is contained
within single file and no server binary has to run in order to use the
dbase. Oh, and I'm using Python under Cygwin.

Ofcourse, ease of use and simplicity is most welcomed :). I'm currently
playing around SQLite+PySQLite and BerkeleyDB, but those two seem like an
overkill :(.

Thanks in advance...

--
_______ Karlo Lozovina - Mosor
| | |.-----.-----. web: http://www.mosor.net || ICQ#: 10667163
| || _ | _ | Parce mihi domine quia Dalmata sum.
|__|_|__||_____ |_____|

[Björn Lindström]

Karlo Lozovina <_karlo_@_mosor .net_> writes:

I've been Googling around for _small_, flat file (no server
processes), SQL-like database which can be easily access from Python.

If you need it to be SQL-like, SQLite seems to be the right thing.

It's not clear to me what you mean by "flat" file here, but if you mean
it should be human readable, maybe the csv module is the thing.

http://docs.python.org/lib/module-csv.html

--
Björn Lindström <bk**@stp.lingf il.uu.se>
Student of computational linguistics, Uppsala University, Sweden

[Kent Johnson]

Karlo Lozovina wrote:

I've been Googling around for _small_, flat file (no server processes),
SQL-like database which can be easily access from Python. Speed and
perforamnce are of no issue, most important is that all data is contained
within single file and no server binary has to run in order to use the
dbase. Oh, and I'm using Python under Cygwin.

Depending on what you mean by "SQL-like" you might like KirbyBase
http://www.netpromi.com/kirbybase.html

Kent

[Micah Elliott]

On Nov 01, Karlo Lozovina wrote:

I've been Googling around for _small_, flat file (no server
processes), SQL-like database which can be easily access from
Python. Speed and perforamnce are of no issue, most important is
that all data is contained within single file and no server binary
has to run in order to use the dbase. Oh, and I'm using Python under
Cygwin.

Ofcourse, ease of use and simplicity is most welcomed :). I'm
currently playing around SQLite+PySQLite and BerkeleyDB, but those
two seem like an overkill :(.

Not sure about "SQL-like", but the conf/ini file type could be
considered a reasonable database format for simple needs, and is
easy to parse/write. The ConfigParser is documented here:

http://www.python.org/doc/current/li...figParser.html

And Fredrik Lundh's examples usage is here:

http://effbot.org/librarybook/configparser.htm

And the Initialization File format is described here:

http://en.wikipedia.org/wiki/INI_file

--
_ _ ___
|V|icah |- lliott http://micah.elliott.name md*@micah.ellio tt.name
" " """

[Karlo Lozovina]

bk**@stp.lingfi l.uu.se (=?utf-8?Q?Bj=C3=B6rn_ Lindstr=C3=B6m? =) wrote in
news:87******** ****@lucien.dre aming:

If you need it to be SQL-like, SQLite seems to be the right thing.
Tried that one, but had some problems setting things up. On the other
hand, BerkeleyDB + Pybsddb worked like a charm, with no setting up (under
Cygwin).

The problem is, Pybsddb is as badly documented as Windows Registry, no
examples, no tutorials, no nothing :(. Does anyone have some small
(possibly documented) Python program which does some basic database
routines - select, insert, and such?
It's not clear to me what you mean by "flat" file here, but if you mean
it should be human readable, maybe the csv module is the thing.
http://docs.python.org/lib/module-csv.html

Well, no, that's not it, but anyway thnx for the link, I need to parse a
lot of CSV files, so this will speed me up :).

--
_______ Karlo Lozovina - Mosor
| | |.-----.-----. web: http://www.mosor.net || ICQ#: 10667163
| || _ | _ | Parce mihi domine quia Dalmata sum.
|__|_|__||_____ |_____|

[Peter Hansen]

Karlo Lozovina wrote:

bk**@stp.lingfi l.uu.se (=?utf-8?Q?Bj=C3=B6rn_ Lindstr=C3=B6m? =) wrote in
news:87******** ****@lucien.dre aming:

If you need it to be SQL-like, SQLite seems to be the right thing.

Tried that one, but had some problems setting things up. On the other
hand, BerkeleyDB + Pybsddb worked like a charm, with no setting up (under
Cygwin).

I'm very curious what problems you had. In my experience SQLite
requires *nothing* I'd call "setup". You install Pysqlite or APSW,
write your code, and it runs and works. There are no configuration
steps required, nothing but creating tables (and that's a standard step
with any SQL-like database). What environment were you using, and what
kind of issues did you encounter? (I ask because I often recommend
SQLite, but would like to temper that advice if in some cases these
setup problems would cause someone trouble.)

-Peter

[alex23]

Karlo Lozovina wrote:

I've been Googling around for _small_, flat file (no server processes),
SQL-like database which can be easily access from Python.

Although it doesn't support SQL queries, Metakit
(http://www.equi4.com/metakit/python.html) is a very lightweight and
easy to use db with a nicely pythonic API.

-alex23

[Ganesan Rajagopal]

>>>>> "Peter" == Peter Hansen <pe***@engcorp. com> writes:

Karlo Lozovina wrote:

bk**@stp.lingfi l.uu.se (=?utf-8?Q?Bj=C3=B6rn_ Lindstr=C3=B6m? =) wrote
in news:87******** ****@lucien.dre aming:

If you need it to be SQL-like, SQLite seems to be the right thing. Tried that one, but had some problems setting things up. On the
other hand, BerkeleyDB + Pybsddb worked like a charm, with no
setting up (under Cygwin).

I'm very curious what problems you had. In my experience SQLite
requires *nothing* I'd call "setup". You install Pysqlite or APSW,
write your code, and it runs and works.

I imagine that's the "setup" OP is talking about. You need to install it
separately as opposed to bsddb. I wish SQLite is bundled with Python 2.5. To
the OP, you could try gadfly (http://gadfly.sourceforge.net/gadfly.html) or
KirbyBase (http://www.netpromi.com/kirbybase.html) but they are also
separate packages to install. I would personally stick with SQLite.

Ganesan

--
Ganesan Rajagopal (rganesan at debian.org) | GPG Key: 1024D/5D8C12EA
Web: http://employees.org/~rganesan | http://rganesan.blogspot.com

[Roman Suzi]

On Tue, 1 Nov 2005, Karlo Lozovina wrote:

bk**@stp.lingfi l.uu.se (=?utf-8?Q?Bj=C3=B6rn_ Lindstr=C3=B6m? =) wrote in
news:87******** ****@lucien.dre aming:

If you need it to be SQL-like, SQLite seems to be the right thing.
Tried that one, but had some problems setting things up.

That is strange. SQLite + PySQLite are IMHO no harder
to install than BerkeleyDB + Pybsddb...

On the other
hand, BerkeleyDB + Pybsddb worked like a charm, with no setting up (under
Cygwin).

Sincerely yours, Roman Suzi
--
rn*@onego.ru =\= My AI powered by GNU/Linux RedHat 7.3

[Steve Holden]

Peter Hansen wrote:

Karlo Lozovina wrote:

bk**@stp.ling fil.uu.se (=?utf-8?Q?Bj=C3=B6rn_ Lindstr=C3=B6m? =) wrote in
news:87****** ******@lucien.d reaming:

If you need it to be SQL-like, SQLite seems to be the right thing.

Tried that one, but had some problems setting things up. On the other
hand, BerkeleyDB + Pybsddb worked like a charm, with no setting up (under
Cygwin).

I'm very curious what problems you had. In my experience SQLite
requires *nothing* I'd call "setup". You install Pysqlite or APSW,
write your code, and it runs and works. There are no configuration
steps required, nothing but creating tables (and that's a standard step
with any SQL-like database). What environment were you using, and what
kind of issues did you encounter? (I ask because I often recommend
SQLite, but would like to temper that advice if in some cases these
setup problems would cause someone trouble.)

-Peter

My experience on Cygwin was that I had to install sqlite before pySqlite
worked. Maybe that's what was meant.

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/