epgsql — PostgreSQL driver
http://bitbucket.org/will/epgsql/
epgsql Is a pure Erlang database driver for PostgreSQL.
Epgsql supports conversion of db types to native Erlang types and the PostgreSQL binary format for common types.
Zotonic uses PostgreSQL as the datastore. epgsql Is the driver for accessing the datastore. It is used in combination with epgsql_pool for connection pooling.
In Zotonic we use a slightly adapted version of epgsql. Most notably are that we:
- use local time internally, we translate all timestamps to and from UTC
- allow the value undefined for null references
- allow atoms as character varying input
- allow encoding of Erlang property lists into a bytea column
epgsql Is maintained by Will Glozer.
Comments
vish
Posted 1 year, 5 months ago.
Have you tried using Riak as your database and if not what do you think the effort is to add that capability. We are interested in using Zotonic if we can connect it to Riak.
Marc Worrell
Posted 1 year, 5 months ago.
Work on a distributed version of Zotonic is on its way. We are using Riak Core, though we are seriously considering to not use the other Riak components due to performance and cache synchronisation issues.
Brandon
Posted 1 year, 3 months ago.
I'd be very interested in hearing more about the status of your distributed version. Could you post an update about it? Thanks!
Marc Worrell
Posted 1 year, 3 months ago.
We are quite busy which makes progress slower than we want. Though code is there, just way of from production quality.