ZODB Database

Introduction

This chapter is about working with ZODB database directly, like tuning database settings.

Plone uses ZODB database. The default ZODB version with Plone 3.x is ZODB 3.7.x. ZODB 3.8.x is not officially supported, but has been reported to work.

• ZODB overview
• ZODB programming guide
• http://www.ibm.com/developerworks/aix/library/au-zodb/

ZODB tips and tricks

Please see

• http://plone.org/events/regional/nola05/collateral/Chris%20McDonough-ZODB%20Tips%20and%20Tricks.pdf

Packing the database offline

See this blog post.

Example how to pack a copy of Data.fs in offline using Python snippet:

import time
import ZODB.FileStorage
import ZODB.serialize

storage=ZODB.FileStorage.FileStorage('/tmp/Data.fs.copy')
storage.pack(time.time(),ZODB.serialize.referencesf)

Visualizing database object graphs

• http://blog.hannosch.eu/2009/05/visualizing-persistent-structure-of.html
• http://david.wglick.org/2009/visualizing-the-zodb-with-graphviz/

Cache size

• Understanding ZODB cache size option