persistent-sqlite

Backend for the persistent library using sqlite3.

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

Version on this page:2.6.2
LTS Haskell 22.37:2.13.3.0
Stackage Nightly 2024-10-10:2.13.3.0
Latest on Hackage:2.13.3.0

See all snapshots persistent-sqlite appears in

MIT licensed and maintained by Michael Snoyman
This version can be pinned in stack with:persistent-sqlite-2.6.2@sha256:725c7fbf0c049f677e333125bf4c16f3a1fbf7089f91131bcd9cbb82cd6ff606,2737

Module documentation for 2.6.2

This package includes a thin sqlite3 wrapper based on the direct-sqlite package, as well as the entire C library, so there are no system dependencies.

Changes

2.6.2

  • Turned on foreign key constraints #646
  • Added new SqliteConnectionInfo-based API

2.6.1

  • Added functions to monitor (status) and control (softHeapLimit) process-wide SQLite memory usage.

2.6.0.1

  • Ensure connection is closed if wrapConnectionWal fails

2.6

Compatibility for backend-specific upsert functionality. A lucky contributor could try to add upsert to the sqlite backend now. It would definitely be tricky though because sqlite does not really have this feature. http://stackoverflow.com/questions/418898/sqlite-upsert-not-insert-or-replace/4330694#4330694

2.5.0.2

2.5.0.1

2.5

  • changes for read/write typeclass split

2.2.2

  • Upgrade to SQLite 3.12.1 #551

2.2.1

  • Upgrade to SQLite 3.8.11.1 #444

2.2

Update to persistent 2.2

2.1.4.1

  • Add missing source files #382

2.1.4

  • Add log support to persistent-sqlite #381

2.1.3

  • Added a Show instance for SqliteConf.
  • Use SqliteException instead of calling fail #364

2.1.2

  • Turn on write-ahead log #363
    • Prepending WAL=off to your connection string will recover the previous behavior.

2.1.1.1

Fix rendering of UTCTime to match SQLite requirements (see issue #328).

2.1.1

Provide a FromJSON instance for SqliteConf.