persistent

Type-safe, multi-backend data serialization.

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

Version on this page:2.9.1@rev:1
LTS Haskell 22.14:2.14.6.1
Stackage Nightly 2024-03-28:2.14.6.1
Latest on Hackage:2.14.6.1

See all snapshots persistent appears in

MIT licensed by Michael Snoyman
This version can be pinned in stack with:persistent-2.9.1@sha256:205a146f5a90569da1b5c9e078a9e0aaf0baddef83e67d2be8ae3a751b4bcfc6,4921

persistent

Type-safe, data serialization. You must use a specific backend in order to make this useful. For more information, see the chapter in the Yesod book.

Changes

Changelog for persistent

2.9.1

  • Fix #847: SQL error with putMany on Sqlite when Entity has no unique index.

2.9.0

  • Added support for SQL isolation levels to via SqlBackend. [#812]
  • Move Database.Persist.Sql.Raw.QQ to a separate persistent-qq package #827
  • Fix 832: repsertMany now matches mapM_ (uncurry repsert) and is atomic for supported sql back-ends.

2.8.2

  • Added support for sql= to the unique constraints quasi-quoter so that users can specify the database names of the constraints.

2.8.1

  • DRY-ed up and exposed several util functions in Database.Persist.Sql.Util.
    • Upstream-ed updatePersistValue, mkUpdateText, and commaSeparated from Database.Persist.MySQL.
    • De-duplicated updatePersistValue from various Database.Persist.Sql.Orphan.* modules.
  • Batching enhancements to reduce db round-trips.
    • Added getMany and repsertMany for batched get and repsert.
    • Added putMany with a default/slow implementation. SqlBackend’s that support native UPSERT should override this for batching enhancements.
    • Updated insertEntityMany to replace slow looped usage with batched execution.
  • See #770

2.8.0

  • Switch from MonadBaseControl to MonadUnliftIO
  • Reapplies #723, which was reverted in version 2.7.3.

2.7.3.1

  • Improve error messages when failing to parse database results into Persistent records. #741
  • A handful of fromPersistField implementations called error instead of returning a Left Text. All of the implementations were changed to return Left. #741
  • Improve error message when a SQL insert fails with a custom primary key #757

2.7.3

  • Reverts #723, which generalized functions using the BackendCompatible class. These changes were an accidental breaking change.
  • Recommend the PersistDbSpecific docs if someone gets an error about converting from PersistDbSpecific

2.7.2 [DEPRECATED ON HACKAGE]

  • Many of the functions have been generalized using the BackendCompatible class. #723
    • This change was an accidental breaking change and was reverted in 2.7.3.
    • These change will be released in a future version of Persistent with a major version bump.
  • Add raw sql quasi quoters #717

2.7.1

  • Added an insertUniqueEntity function #718
  • Added BackendCompatible class #701

2.7.0

  • Fix upsert behavior #613
  • Atomic upsert query fixed for arithmatic operations #662
  • Haddock and test coverage improved for upsert

2.6.1

  • Fix edge case for \<-. [Nothing]
  • Introduce connMaxParams
  • Add ‘getJustEntity’ and ‘insertRecord’ convenience function
  • Minor Haddock improvment

2.6

  • Add connUpsertSql type for providing backend-specific upsert sql support.

2.5

  • read/write typeclass split
  • add insertOrGet convenience function to PersistUnique

2.2.4.1

  • Documentation updates #515

2.2.4

  • Workaround for side-exiting transformers in runSqlConn #516

2.2.3

  • PersistField instance for Natural
  • better oracle support in odbc

2.2.2

  • Add liftSqlPersistMPool function
  • support http-api-data for url serialization

2.2.1

  • Migration failure message with context
  • Fix insertKey for composite keys

2.2

  • Add a RawSql instance for Key. This allows selecting primary keys using functions like rawSql. #407
  • SqlBackend support for an optimized insertMany

2.1.6

Important! If persistent-template is not upgraded to 2.1.3.3 you might need to make sure Int64 is in scope for your model declarations.

  • add showMigration function
  • explicitly use Int64 for foreign key references

2.1.5

Add dbIdColumnsEsc to Sql.Utils. Used in persistent-postgresql 2.1.5.2

2.1.4

  • Fix getBy with a primary key. #342

2.1.3

  • Break self-referencing cycles in the entity declarations

2.1.2

  • Error with Doubles without a decimal part #378
  • runSqlPool does not perform timeout checks.

2.1.1.6

  • One extra feature for #939: use logDebugN instead

2.1.1.5

2.1.1.3

Parse UTCTime in 8601 format #339

2.1.1.1

Support for monad-control 1.0