PgStorageBackend

Backend that stores data in a postgres database.

problems

• StorageBackend interface is too fine-grained for SQL based backends. It would be useful to have a better high level knowledge of what should be changed/stored. This would allow optimizations like batch-insert in SQL backends.
• No documentation of StorageBackend interface. Sometimes you have to guess what should happen.

database and user setup for tests

The tests assume a user "dstore-test" with the password "test" and a database named "dstore-test" where the user has full privileges (including schema modifications).

createuser dstore-test --pwprompt # enter "test" as password
createdb -O dstore-test -E UTF-8 dstore-test