Database.Selda.PostgreSQL

PostgreSQL backend for Selda.

Documentation

data PGConnectInfo

PostgreSQL connection information.

Constructors

PGConnectInfo

Fields

• pgHost :: Text

  Host to connect to.

• pgPort :: Int

  Port to connect to.

• pgDatabase :: Text

  Name of database to use.

• pgUsername :: Maybe Text

  Username for authentication, if necessary.

• pgPassword :: Maybe Text

  Password for authentication, if necessary.

withPostgreSQL :: (MonadIO m, MonadThrow m, MonadMask m) => PGConnectInfo -> SeldaT m a -> m a

Perform the given computation over a PostgreSQL database. The database connection is guaranteed to be closed when the computation terminates.

on :: Text -> Text -> PGConnectInfo infixl 7

Connect to the given database on the given host, on the default PostgreSQL port (5432):

withPostgreSQL ("my_db" `on` "example.com") $ do
  ...

auth :: PGConnectInfo -> (Text, Text) -> PGConnectInfo infixl 4

Add the given username and password to the given connection information:

withPostgreSQL ("my_db" `on` "example.com" `auth` ("user", "pass")) $ do
  ...

For more precise control over the connection options, you should modify the PGConnectInfo directly.

pgBackend

Arguments

:: Text

Unique database identifier. Preferably the connection string used to open the connection.

-> Connection

PostgreSQL connection object.

-> SeldaBackend

Create a SeldaBackend for PostgreSQL Connection

pgConnString :: PGConnectInfo -> ByteString

Convert PGConnectInfo into ByteString