HDBC-sqlite3: Sqlite v3 driver for HDBC

[ bsd3, database, library ] [ Propose Tags ]

This is the Sqlite v3 driver for HDBC, the generic database access system for Haskell

[Skip to Readme]




Automatic Flags

Choose the new smaller, split-up package.


Build the executable to run unit tests


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


Maintainer's Corner

Package maintainers

For package maintainers and hackage trustees


  • No Candidates
Versions [RSS],,,,,,,,,,,,
Change log CHANGELOG.md
Dependencies base (>=4 && <5), bytestring, containers, convertible, HDBC (>=, HUnit, mtl, old-locale, old-time, testpack, time, utf8-string [details]
License BSD-3-Clause
Copyright Copyright (c) 2005-2011 John Goerzen
Author John Goerzen
Maintainer Erik Hesselink <hesselink@gmail.com>
Category Database
Home page https://github.com/hdbc/hdbc-sqlite3
Uploaded by ErikHesselink at 2015-04-24T09:32:52Z
Distributions Debian:, NixOS:
Reverse Dependencies 19 direct, 34 indirect [details]
Executables runtests
Downloads 18926 total (35 in the last 30 days)
Rating (no votes yet) [estimated by Bayesian average]
Your Rating
  • λ
  • λ
  • λ
Status Docs available [build log]
Last success reported on 2015-04-24 [all 1 reports]

Readme for HDBC-sqlite3-

[back to package description]
Welcome to HDBC, Haskell Database Connectivity.

This package provides a database backend driver for Sqlite version 3.

Please see HDBC itself for documentation on use.  If you don't already
have it, you can browse this documentation at

This package provides one function in module Database.HDBC.Sqlite3:

{- | Connect to an Sqlite version 3 database.  The only parameter needed is
the filename of the database to connect to.

All database accessor functions are provided in the main HDBC module. -}
connectSqlite3 :: FilePath -> IO Connection


SQLite is unable to return the number of modified rows from a table
when you run a "DELETE FROM" command with no WHERE clause.

On the topic of thread safety, SQLite has some limitations, and thus
HDBC programs that use SQLite will share those limitations.  Please
see http://www.sqlite.org/faq.html#q8 for more details.

describeTable and describeResult are not supported by this module.


Before installing this package, you'll need to have HDBC 0.99.0 or
above installed.  You can download HDBC from http://quux.org/devel/hdbc.

You'll need either GHC 6.8.x or above, or Hugs 2006xx or above.  


The steps to install are:

1) ghc --make -o setup Setup.lhs

2) ./setup configure

3) ./setup build

4) ./setup install   (as root)

If you're on Windows, you can omit the leading "./".


To use with hugs, you'll want to use hugs -98.

To use with GHC, you'll want to use:

 -package HDBC -package HDBC-sqlite3

Or, with Cabal, use:

  Build-Depends: HDBC>=2.0.0, HDBC-sqlite3

-- John Goerzen
   January 2009
   December 2005