A Julia interface to the SQLite3 library that implements the DBI.jl protocol.
Testing status:
This package implements the interface described in the DBI.jl docs.
To function, this package needs to have access to a custom build of SQLite3
that has the SQLITE_ENABLE_COLUMN_METADATA compile-time option enabled. The
steps below describe one possible way to enable this option:
Step 1: Download a copy of the autoconf-ready source code for SQLite3
here. This package has been tested
against sqlite-autoconf-3080300.tar.gz.
Step 2: Modify the first line of the sqlite3.c file to include the
following code:
// For use with DBI.jl, we always build SQLite3 with column metadata enabled
#define SQLITE_ENABLE_COLUMN_METADATA
Step 3: Compile and install the modified SQLite3 library:
./configure
make
make install
On most systems that provide SQLite3, the SQLITE_ENABLE_COLUMN_METADATA
option is not enabled. Under these circumstances, most of the functionality of
this library will work, except for the tableinfo and columninfo functions.