Skip to content

Instantly share code, notes, and snippets.

@nurpax
Created October 17, 2012 18:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nurpax/3907344 to your computer and use it in GitHub Desktop.
Save nurpax/3907344 to your computer and use it in GitHub Desktop.

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.

@nurpax
Copy link
Author

nurpax commented Oct 18, 2012

Opened http://trac.haskell.org/haskell-platform/ticket/212 just in case this is not a known issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment