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.
@joeyadams You're right, mingw + gcc comes with Haskell Platform and I can see the files under the directory you mentioned. I see mingw\bin is not in my PATH though. I don't think I did any manual editing of my PATH after installing HP so perhaps the issue is that PATH setup in the HP installer is not complete. I'll file a bug against the Haskell Platform.
Thanks for catching this!