MIT licensed by Travis Athougies
Maintained by
This version can be pinned in stack with:beam-sqlite-,3671

Module documentation for

beam-sqlite: Beam backend for the SQLite embedded database

beam-sqlite is a beam backend for the SQLite embedded database.

SQLite is mostly standards compliant, but there are a few cases that beam-sqlite cannot handle. These cases may result in run-time errors. For more information, see the documentation. Due to SQLite’s embedded nature, there are currently no plans to get rid of these. However, proposals and PRs to fix these corner cases are welcome, where appropriate.


Added features

  • Aeson 2.0 support

Added features

  • GHC 9.2 and 9.0 support

Bug fixes

  • Support inserting default values for all columns (except with upsert)

Added features

  • MonadBase and MonadBaseControl instances for SqliteM

Interface changes

  • Removed instances for machine-dependent ambiguous integer types Int and Word

Added features

  • Support for in_ on row values
  • Upsert support using HasInsertOnConflict
  • Fix build on Android and OpenBSD

Bug fixes

  • Fix emitting and detection of DECIMAL and DOUBLE PRECISION types
  • Fix bitLength, charLength_, and octectLength_ by emulating with CAST and LENGTH
  • Fix runInsertReturningList for when the database column order and beam column order disagree.

Add Semigroup instances to prepare for GHC 8.4 and Stackage nightly

Add runBeamSqlite and runBeamSqliteDebug functions

  • Re-introduce backend parameter to Database class

First split of sqlite backend from main beam package