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 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.