Servant.Context.PostgreSQL

Useful functions and instances for using servant with a PostgreSQL database.

• Use contextOfConnInfo or contextOfConnStr to create a PostgreSQL Contexts. * If you want connection-pooling, use pooledContextOfConnInfo and pooledContextOfConnStr.

PostgreSQL Context

contextOfConnInfo :: ConnectInfo -> Context Connection

Create a Context Connection from the given ConnectInfo.

This means a new connection will be fired whenever you perform a database operation. If you want to avoid that, see the pooledContextOfXXX functions.

contextOfConnStr :: ByteString -> Context Connection

Create a Context Connection from the given connection string.

This means a new connection will be fired whenever you perform a database operation. If you want to avoid that, see the pooledContextOfXXX functions.

PostgreSQL Context with connection pooling

pooledContextOfConnInfo

Arguments

:: Int

Number of stripes (sub-pools). Minimum: 1

-> NominalDiffTime

amount of time during which an unused Connection is kept open

-> Int

Maximum number of resources to keep open per stripe. Minimum: 1

-> ConnectInfo

connection information

-> IO (Context Connection)

Create a Context that'll use a Pool of PostgreSQL Connections internally, from a ConnectInfo value.

pooledContextOfConnStr

Arguments

:: Int

Number of stripes (sub-pools). Minimum: 1

-> NominalDiffTime

amount of time during which an unused Connection is kept open

-> Int

Maximum number of resources to keep open per stripe. Minimum: 1

-> ByteString

connection string

-> IO (Context Connection)

Create a Context that'll use a Pool of PostgreSQL Connections internally, from a connection string (a ByteString).