Many Windows 7 hosts with only Haskell Platform do not have a C compiler installed. This makes it painful to install direct-sqlite as it compiles sqlite3.c as part of its build.
Here's how to install this package so that it links against a prebuilt sqlite3.dll
:
$ cabal install direct-sqlite -fsystemlib --extra-include-dirs=/c/Users/$USER/include \
--extra-lib-dirs=/c/Users/$USER/bin
The example needs to be modified to point --extra-include-dirs
and --extra-lib-dirs
to the right path on your system that contains a) sqlite3.h
and b) sqlite3.dll
.
When running your application linking against direct-sqlite, make sure your sqlite3.dll
is in the PATH.
Opened http://trac.haskell.org/haskell-platform/ticket/212 just in case this is not a known issue.