Type-safe PureScript FFI bindings for PostgreSQL with typed query support.
spago install yoga-postgres yoga-sql-types
npm install pgimport Yoga.Postgres as PG
import Yoga.Postgres.TypedQuery as TQ
main = launchAff_ do
conn <- PG.connect { connectionString: "postgresql://localhost/mydb" }
-- Raw queries
rows <- PG.query conn "SELECT * FROM users" []
-- Typed queries
result <- TQ.query conn
(TQ.sql @"SELECT id, name FROM users WHERE id = $id")
{ id: 123 }
PG.disconnect connSee yoga-postgres-om for Om-wrapped operations.
MIT