Stability	experimental
Maintainer	Alp Mestanogullari <alp@zalora.com>
Safe Haskell	None

Servant.Context.PostgreSQL

Contents

PostgreSQL Context
PostgreSQL Context with connection pooling

Description

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.

Synopsis

PostgreSQL `Context`

contextOfConnInfo :: ConnectInfo -> Context Connection Source

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 Source

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 Source

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 Source

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).

PostgreSQL Context

PostgreSQL Context with connection pooling

PostgreSQL `Context`

PostgreSQL `Context` with connection pooling