RelStorage 1.4.0

RelStorage version 1.4.0 is released on November 2009.  It promised performance improvement and better way to work with memcached.

http://pypi.python.org/pypi/RelStorage/1.4.0b1

Shane Hathaway's blog: http://shane.willowrise.com/, he is the author of RelStorage, his blog talks a lot about it.

A overview slide about RelStorage from six feet up: http://www.slideshare.net/W9ZEB/pse2010-rel-storage

Installation with PostgreSQL

First step is installing PostgreSQL database.  If you install the postgresql from binary package, make sure the devel package been installed.  The devel package has very helpful utility pg_config, which will make the buildout easy to perform.

Preparing the PostgreSQL database for ZODB:

$ su - postgres
$ createuser --pwprompt zodbuser
$ createdb -O zodbuser zodb 

How to connect PostgreSQL database? - psycopg2 http://initd.org/psycopg/.  By using buildout, the installation will be very easy.  pg_config binary is required to install psycopg2 by using buildout!

eggs = 
    psycopg2 == 2.2.2
    RelStorage == 1.4.0c3 
[instance]
rel-storage=
    type postgresql
    dsn dbname='zodb' user='zodbuser' host='localhost' password='password'
    blob-dir ${buildout:directory}/var/blobstorage 

we need some tweaking in pg_hda.conf: http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html

that's it!

About blob support

the parameter blob-dir is for relstorage section in zope.conf.

There is a error for blob file on page manage_change_history_page: POSKeyError: 0x0ed1.