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.
• Its not possible to use foreign keys with the current storage backend interface, because entities are not stored in the correct order.
• No documentation of StorageBackend interface. Sometimes you have to guess what should happen.

database setup for tests

The tests assume a user "dstore-test" with the password "test" on a server running at localhost on the default port. The tests will setup their own test databases. This means that the user needs to have the CREATEDB privilege.

To setup such a user you can run the following command in the commandline as postgresql user once.

psql -c "CREATE USER \"dstore-test\" WITH CREATEDB ENCRYPTED PASSWORD 'test';"

It is also possible to use other database connection data by setting the following system properties.

com.dc2f.dstore.test.pghost
com.dc2f.dstore.test.pgport
com.dc2f.dstore.test.pguser
com.dc2f.dstore.test.pgpassword