persistent-sqlite

Backend for the persistent library using sqlite3.

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

Version on this page:2.6.0.1
LTS Haskell 22.18:2.13.3.0
Stackage Nightly 2024-04-22: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.0.1@sha256:e309af658d4c4a233f44ab81b885a64433e1602475de4978d54b68ec3d4f6440,2641

Module documentation for 2.6.0.1

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.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.