Go to page content

epgsql — PostgreSQL driver


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.