[ANN] PyDbLite 1.9

Pierre Quentel quentel.pierre at wanadoo.fr
Wed Jan 3 08:50:02 CET 2007


PyDbLite is a small, fast, pure-Python, in-memory database management
program

The database object supports the iterator protocol, so that requests
can be expressed with list comprehensions or generator expressions
instead of SQL. The equivalent of :

    cursor.execute("SELECT name FROM table WHERE age=30")
    rows = cursor.fetchall()

is :

    rows = [ row["name"] for row in table if row["age"] == 30 ]

Data is stored on disk in a single cPickled file. Records are indexed
by a unique record identifier, that can be used for direct access.
Since operations are processed in memory they are extremely fast,
nearly as fast as SQLite in the few tests I made. An index can be
created on a field to speed up selections

Home Page: http://quentel.pierre.free.fr/PyDbLite/index.html
Download URL: http://quentel.pierre.free.fr/PyDbLite/PyDbLite.py



More information about the Python-announce-list mailing list