persistent-postgresql

Backend for the persistent library using postgresql.

http://www.yesodweb.com/book/persistent

Version on this page:2.6.1
LTS Haskell 22.13:2.13.6.1
Stackage Nightly 2024-03-14:2.13.6.1
Latest on Hackage:2.13.6.1

See all snapshots persistent-postgresql appears in

MIT licensed by Felipe Lessa, Michael Snoyman
Maintained by Michael Snoyman
This version can be pinned in stack with:persistent-postgresql-2.6.1@sha256:218c0d908a46d011359ab0e8dc813c3e1d7cd1b595bec7d9b3e079f0052dfe33,1627

Module documentation for 2.6.1

Based on the postgresql-simple package

Changes

2.6.1

  • Match changes in persistent
  • Clean up warnings

2.6

  • Atomic upsert support for postgreSQL backend

2.5

  • changes for read/write typeclass split

2.2.2

  • Postgresql primary key is Int4, not Int8 #519

2.2.1.2

  • Allow postgresql-simple 0.5

2.2.1.1

Query pg_catalog instead of information_schema for metadata. This helps with permission issues as reported in issue #501

2.2.1

  • Fix treatment of NULLs inside arrays. For example, now you can use array_agg on a nullable column.

  • New derived instances for PostgresConf: Read, Data and Typeable.

  • New mockMigration function. Works like printMigration but doesn’t need a database connection.

  • Fix typo on error message of the FromJSON instance of PostgresConf.

2.2

  • Optimize the insertMany function to insert all rows and retrieve their keys in one SQL query. #407

2.1.6

  • Postgresql exceptions #353

2.1.5.3

Migrations for custom primary keys

2.1.5.2

Support foreign key references to composite primary keys #389

2.1.5

  • Allow timestamp value in database to be serialized (presumes UTC timezone) Yesod #391

2.1.4

  • Treat unknown extension types as PersistDbSpecific values #385

2.1.3

2.1.2.1

Documentation typo fix

2.1.1

Added FromJSON instance for PostgresConf.