git.iko.soy/rowtype-yoga/purescript-yoga-postgres
on main help sign in
rowtype-yoga/purescript-yoga-postgres/README.md
36 lines 674 B history raw
1# yoga-postgres
3Type-safe PureScript FFI bindings for PostgreSQL with typed query support.
5## Installation
7```bash
8spago install yoga-postgres yoga-sql-types
9npm install pg
10```
12## Usage
14```purescript
15import Yoga.Postgres as PG
16import Yoga.Postgres.TypedQuery as TQ
18main = launchAff_ do
19 conn <- PG.connect { connectionString: "postgresql://localhost/mydb" }
21 -- Raw queries
22 rows <- PG.query conn "SELECT * FROM users" []
24 -- Typed queries
25 result <- TQ.query conn
26 (TQ.sql @"SELECT id, name FROM users WHERE id = $id")
27 { id: 123 }
29 PG.disconnect conn
30```
32See [yoga-postgres-om](../yoga-postgres-om) for Om-wrapped operations.
34## License
36MIT