The direct-sqlite package

[ Tags: bsd3, database, library ] [ Propose Tags ]

This package is not very different from the other SQLite3 bindings out there, but it fixes a few deficiencies I was finding. As compared to bindings-sqlite3, it is slightly higher-level, in that it supports marshalling of data values to and from the database. In particular, it supports strings encoded as UTF8, and BLOBs represented as ByteStrings.

Release history:

Version 2.3.2
Add execPrint, execWithCallback, and interruptibly functions. Add bindings for sqlite3_last_insert_rowid and sqlite3_changes. Change the Show instance of the Utf8 newtype to better match the IsString instance.
Version 2.3.1
Upgrade the bundled SQLite3 to 3.7.15. Add bindings for sqlite3_interrupt. Export Int rather than CInt.
Version 2.3
Mark some FFI calls "unsafe", for a substantial performance benefit.
Version 2.2.1
Bump down text library version to match with the latest Haskell Platform.
Version 2.2
actually does what version 2.1 claimed to, since the author made a mistake with git.
Version 2.1
improves handling of invalid UTF-8 and changes error handling to be more complete. It also adds a build flag to build against the system sqlite instead of the bundled one, optionally (disabled by default).
Version 2.0
uses Text for strings instead of String.
switches to the Faction packaging system and makes no other changes.
Version 1.1
adds the SQLite amalgamation file (version 3.7.5) to the project, so that there are no external dependencies.


Versions 1.0, 1.1, 2.0, 2.1, 2.2, 2.2.1, 2.3, 2.3.1, 2.3.2, 2.3.3,, 2.3.4, 2.3.5, 2.3.6, 2.3.7, 2.3.8, 2.3.9, 2.3.11, 2.3.12, 2.3.13, 2.3.14, 2.3.15, 2.3.16, 2.3.17, 2.3.18, 2.3.19, 2.3.20, 2.3.21
Dependencies base (>=4.1 && <5), bytestring (>= && <1), text (>=0.11 && <1) [details]
License BSD3
Copyright Copyright (c) 2012, 2013 Irene Knapp
Author Irene Knapp <>
Category Database
Home page
Bug tracker
Source repository head: git clone git://
Uploaded Fri Jan 4 19:24:59 UTC 2013 by IreneKnapp
Distributions LTSHaskell:2.3.21, NixOS:2.3.20, Stackage:2.3.21, Tumbleweed:2.3.20
Downloads 10361 total (199 in the last 30 days)
Rating 0.0 (0 ratings) [clear rating]
  • λ
  • λ
  • λ
Status Docs uploaded by user
Build status unknown [no reports yet]
Hackage Matrix CI





Use the system-wide sqlite library


Use -f <flag> to enable a flag, or -f -<flag> to disable that flag. More info


Maintainer's Corner

For package maintainers and hackage trustees