postgresql-typed

A PostgreSQL library with compile-time SQL type inference and optional HDBC backend

https://github.com/dylex/postgresql-typed

Version on this page:0.5.0
LTS Haskell 23.21:0.6.2.5
Stackage Nightly 2025-05-06:0.6.2.5
Latest on Hackage:0.6.2.5

See all snapshots postgresql-typed appears in

BSD-3-Clause licensed by Dylan Simon
Maintained by Dylan Simon
This version can be pinned in stack with:postgresql-typed-0.5.0@sha256:25d39c62257f17f9d8b7ff399be314d654c44fb161c7526566400c925e818152,4186

Module documentation for 0.5.0

Automatically type-check SQL statements at compile time. Uses Template Haskell and the raw PostgreSQL protocol to describe SQL statements at compile time and provide appropriate type marshalling for both parameters and results. Allows not only syntax verification of your SQL but also full type safety between your SQL and Haskell. Supports many built-in PostgreSQL types already, including arrays and ranges, and can be easily extended in user code to support any other types.

Also includes an optional HDBC backend that, since it uses the raw PostgreSQL protocol, may be more efficient than the normal libpq backend in some cases (though provides no more type safety than HDBC-postgresql when used without templates).

Originally based on Chris Forno's templatepg library.