dani-sqlite
============

An amalgamated fork of Irene Knapp's [direct-sqlite](https://github.com/IreneKnapp/direct-sqlite) and Janne Hellsten's [sqlite-simple](https://hackage.haskell.org/package/sqlite-simple).

- Unlike **direct-sqlite**, it doesn't include the code for the C library, so
you'll have to install the library separately.

  Example of `cabal.project.local` pointing to local libs on Windows:

      package dani-sqlite
          extra-include-dirs: C:/Users/somefolder/sqlite-amalgamation-3350300
          extra-lib-dirs: C:/Users/somefolder/sqlite-dll-win64-x64-3350300

- Requires SQLite >= 3.37.0.

- Supports [`sqlite3_open_v2`](https://www.sqlite.org/c3ref/open.html).

- Supports [extended result codes](https://www.sqlite.org/rescode.html).

- Unlike **sqlite-simple**, this library doesn't have a time type.

- Unlike **sqlite-simple**, this library doesn't have a quasiquoter.

Links
=====

- [FFI in the Haskell Report](https://www.haskell.org/onlinereport/haskell2010/haskellch8.html)

- [Foreign function interface (FFI) in the GHC user guide](https://downloads.haskell.org/ghc/latest/docs/html/users_guide/exts/ffi.html)

- [Using the latest version of SQLite with Haskell on Windows](https://danidiaz.medium.com/using-the-latest-version-of-sqlite-with-haskell-on-windows-1d6d4df2e683)

- [Foreign Function Interface at the Haskellwiki](https://wiki.haskell.org/Foreign_Function_Interface)

> I see very little reason to not use CApiFFI if your project doesn't need
to work on old GHCs.

- [Writing Haskell interfaces to C code: hsc2hs](https://downloads.haskell.org/ghc/latest/docs/html/users_guide/utils.html)

- [Using_the_FFI](https://wiki.haskell.org/GHC/Using_the_FFI). 

- [Haskell/FFI](https://en.wikibooks.org/wiki/Haskell/FFI)

- [hsctohs](https://www.reddit.com/r/haskell/comments/tthrq0/comment/i5dpir1/)

- [Chapter 17. Interfacing with C: the FFI](http://book.realworldhaskell.org/read/interfacing-with-c-the-ffi.html)

  > the #const keyword hsc2hs provides [...] We can bind to the constants manually, by listing the CPP symbols for them using the #const keyword

- [Writing Haskell interfaces to C code: hsc2hs](https://downloads.haskell.org/ghc/latest/docs/html/users_guide/utils.html?highlight=hsc2hs#writing-haskell-interfaces-to-c-code-hsc2hs)

- [Converting between `CInt` and `Int`](https://www.reddit.com/r/haskell/comments/tthrq0/monthly_hask_anything_april_2022/i60rc8l/)

  > Does that mean that I should always use functions like fromIntegral to convert between CInt and Int/Integer?

- [Videos about the Haskell FFI](https://twitter.com/DiazCarrete/status/1518325306448388096).

- [`foreign import capi "wrapper"`](https://gitlab.haskell.org/ghc/ghc/-/issues/21532#note_428196)

  > While the Report isn't entirely clear on this, but my understanding is that the calling convention (e.g. ccall) in a foreign import ... "wrapper" indicates the calling convention that the resulting FunPtr should expect to be invoked with. If this is true then it's not obvious what foreign import capi "wrapper" should mean; afterall capi isn't really a calling convention. Rather, it just says "delegate code generation for the call to the C compiler". However, we can't delegate like this in for a "wrapper" import, since this would be akin to writing foreign export capi, which don't support.

- [C-language Interface Specification for SQLite](https://www.sqlite.org/capi3ref.html)

- [parameters](https://www.sqlite.org/lang_expr.html#varparam)

  [The sqlite3_bind_parameter_name(P,N) interface returns the name of the N-th SQL parameter in the prepared statement P.](https://www.sqlite.org/c3ref/bind_parameter_name.html)

  [Return the index of an SQL parameter given its name. The index value returned is suitable for use as the second parameter to sqlite3_bind().](https://www.sqlite.org/c3ref/bind_parameter_index.html)

- [Closing A Database Connection](https://www.sqlite.org/c3ref/close.html)

  > Ideally, applications should finalize all prepared statements, close all BLOB handles, and finish all sqlite3_backup objects associated with the sqlite3 object prior to attempting to close the object.

Acknowledgements
================

- Irene Knapp and the rest of contributors to [direct-sqlite](https://github.com/IreneKnapp/direct-sqlite). 
- Janne Hellsten and the rest of contributors to  [sqlite-simple](https://hackage.haskell.org/package/sqlite-simple).