[BangPypers] Can we create proprietary database in Python

[Carl Karsten]

On Sun, Sep 27, 2009 at 11:46 PM, srid <sridhar.ratna at gmail.com> wrote:
> On Sat, Sep 26, 2009 at 12:15 PM, Arun Python <arunpython at ymail.com> wrote:
>>
>> b) Can we create proprietary or sequential database like in C++
>> in python for database applications which are not so huge.
>
>> Sequential database in the sense, like creating a data structure
>> in the class and getting data from the user and storing it as a file.
>
> sqlalchemy + sqlite may fit your use case. sqlalchemy provides this
> "datastructure in the class" (class mappers) and sqlite stores your
> database in a file (no servers). quick start:
> http://www.rmunn.com/sqlalchemy-tutorial/tutorial.html

sqlalchemy + sqlite is probably the right thing, but given the
description I think it is worth mentioning pickle and shelve:

"""
A “shelf” is a persistent, dictionary-like object. The difference with
“dbm” databases is that the values (not the keys!) in a shelf can be
essentially arbitrary Python objects — anything that the pickle module
can handle. This includes most class instances, recursive data types,
and objects containing lots of shared sub-objects. The keys are
ordinary strings.
"""  http://docs.python.org/library/shelve.html



-- 
Carl K