Compiling direct-sqlite 2.2 on Windows
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
$ 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-lib-dirs to the right path on your system that contains a)
sqlite3.h and b)
When running your application linking against direct-sqlite, make sure your
sqlite3.dll is in the PATH.