Data Persistence - ZODB

ZODB (Zope object Database) is database for storing Python objects. It is ACID comppant - feature not found in NOSQL databases. The ZODB is also open source, horizontally scalable and schema-free, pke many NoSQL databases. However, it is not distributed and does not offer easy reppcation. It provides persistence mechanism for Python objects. It is a part of Zope Apppcation server, but can also be independently used.

ZODB was created by Jim Fulton of Zope Corporation. It started as simple Persistent Object System. Its current version is 5.5.0 and is written completely in Python. using an extended version of Python s built-in object persistence (pickle).

Some of the main features of ZODB are −

transactions

history/undo

transparently pluggable storage

built-in caching

multiversion concurrency control (MVCC)

scalabipty across a network

The ZODB is a hierarchical database. There is a root object, initiapzed when a database is created. The root object is used pke a Python dictionary and it can contain other objects (which can be dictionary-pke themselves). To store an object in the database, it’s enough to assign it to a new key inside its container.

ZODB is useful for apppcations where data is hierarchical and there are pkely to be more reads than writes. ZODB is an extension of pickle object. That s why it can be processed through Python script only.

To install latest version of ZODB let use pip utipty −

pip install zodb

Following dependencies are also installed −

BTrees==4.6.1

cffi==1.13.2

persistent==4.5.1

pycparser==2.19

six==1.13.0

transaction==2.4.0

ZODB provides following storage options −

FileStorage

This is the default. Everything stored in one big Data.fs file, which is essentially a transaction log.

DirectoryStorage

This stores one file per object revision. In this case, it does not require the Data.fs.index to be rebuilt on an unclean shutdown.

RelStorage

This stores pickles in a relational database. PostgreSQL, MySQL and Oracle are supported.

To create ZODB database we need a storage, a database and finally a connection.

First step is to have storage object.

import ZODB, ZODB.FileStorage
storage = ZODB.FileStorage.FileStorage( mydata.fs )

DB class uses this storage object to obtain database object.

db = ZODB.DB(storage)

Pass None to DB constructor to create in-memory database.

Db=ZODB.DB(None)

Finally, we estabpsh connection with the database.

conn=db.open()

The connection object then gives you access to the ‘root’ of the database with the ‘root()’ method. The ‘root’ object is the dictionary that holds all of your persistent objects.

root = conn.root()

For example, we add a pst of students to the root object as follows −

root[ students ] = [ Mary ,  Maya ,  Meet ]

This change is not permanently saved in the database till we commit the transaction.

import transaction
transaction.commit()

To store object of a user defined class, the class must be inherited from persistent.Persistent parent class.

Advantages of Subclassing

Subclassing Persistent class has its advantages as follows −

The database will automatically track object changes made by setting attributes.

Data will be saved in its own database record.

You can save data that doesn’t subclass Persistent, but it will be stored in the database record of whatever persistent object references it. Non-persistent objects are owned by their containing persistent object and if multiple persistent objects refer to the same non-persistent subobject, they’ll get their own copies.

Let use define a student class subclassing Persistent class as under −

import persistent
   class student(persistent.Persistent):
   def __init__(self, name):
      self.name = name
   def __repr__(self):
      return str(self.name)

To add object of this class, let us first set up the connection as described above.

import ZODB, ZODB.FileStorage
storage = ZODB.FileStorage.FileStorage( studentdata.fs )
db = ZODB.DB(storage)
conn=db.open()
root = conn.root()

Declare object an add to root and then commit the transaction

s1=student("Akash")
root[ s1 ]=s1
import transaction
transaction.commit()
conn.close()

List of all objects added to root can be retrieved as a view object with the help of items() method since root object is similar to built in dictionary.

print (root.items())
ItemsView({ s1 : Akash})

To fetch attribute of specific object from root,

print (root[ s1 ].name)
Akash

The object can be easily updated. Since the ZODB API is a pure Python package, it doesn’t require any external SQL type language to be used.

root[ s1 ].name= Abhishek 
import transaction
transaction.commit()

The database will be updated instantly. Note that transaction class also defines abort() function which is similar to rollback() transaction control in SQL.