Popularity
4.8
Growing
Activity
4.7
Declining
6
2
1
Monthly Downloads: 30
Programming language: Haskell
License: BSD 3-clause "New" or "Revised" License
Tags:
Database
PostgreSQL
Latest version: v0.1.0
postgresql-simple-interpolate alternatives and similar packages
Based on the "postgresql" category
-
postgresql-simple
Mid-Level PostgreSQL client library -
postgresql-simple-migration
PostgreSQL Schema Migrations -
postgresql-orm
An ORM (Object Relational Mapping) and migrations DSL for PostgreSQL. -
postgresql-libpq
low-level binding to libpq -
postgresql-transactional
a transactional monad on top of postgresql-simple -
postgresql-typed
A PostgreSQL library with compile-time SQL type inference and optional HDBC backend -
postgresql-simple-named
Implementation of named parameters for `postgresql-simple` library -
postgresql-pure
pure Haskell PostgreSQL driver -
postgresql-schema
PostgreSQL Schema Management -
postgresql-error-codes
PostgreSQL error codes -
postgresql-simple-typed
Typed extension for PostgreSQL simple -
postgresql-simple-opts
An optparse-applicative parser for postgresql-simple's connection options -
postgresql-syntax
PostgreSQL SQL syntax utilities -
postgresql-lo-stream
Utilities for streaming PostgreSQL LargeObjects
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest. Visit our partner's website for more details.
Do you think we are missing an alternative of postgresql-simple-interpolate or a related project?
README
postgresql-simple-interpolate
Write natural SQL statements in Haskell using a QuasiQuotes!
{-# LANGUAGE QuasiQuotes #-}
import Data.Char (toLower)
import qualified Database.PostgreSQL.Simple as Pg
import Database.PostgreSQL.Simple.SqlQQ.Interpolated (isql)
import Control.Exception (bracket)
main :: IO ()
main = do
bracket (Pg.connectPostgreSQL "host=localhost") Pg.close $ \conn -> do
let limit = 10
ages <- uncurry (query conn) [isql|SELECT age FROM table WHERE name = ${map toLower "CLIVE"} LIMIT ${limit}|]
print (ages :: [Pg.Only Int])
|]
Hacking
With Nix you can quickly play around with this using a PostgreSQL database:
nix-shell -p '(import ./. {}).haskellPackages.ghcWithPackages (p: [p.gargoyle-postgresql-connect p.postgresql-simple-interpolate])' --run ghci
Then run
:set -XQuasiQuotes
import Gargoyle.PostgreSQL.Connect (withDb)
import Data.Pool (withResource)
import Database.PostgreSQL.Simple (Only (..), query)
import Database.PostgreSQL.Simple.SqlQQ.Interpolated (isql)
[isql|SELECT ${1 + 1}|]
-- ("SELECT ?",[Plain "2"])
withDb "db" $ \pool -> withResource pool $ \c -> (uncurry (query c) [isql|SELECT ${1 + 1}, ${reverse "HELLO"}::text|] :: IO [(Int, String)])
-- [(2,"OLLEH")]
Acknowledgements
This library is basically just a copy of the here package by Taylor M. Hedberg with slight modifications!