blob: fc47b2688805456d7b8a06882e242879ad8810e1 [file] [log] [blame] [edit]
# Sqlite Extensions - Usage (Sqlite @VERSION@)
This folder contains shared libraries (dll files) `sqlite3.exe` can be
instructed to load at run-time in order to add functions usable in `sqlite3` SQL code.
Here an example of how to call an extension from the command line (example with
extension `csv`, other extensions are in this directory):
- open a shell (e.g. the `@MSYSTEM@` shell)
- call `sqlite3.exe` (residing in `@MINGW_PREFIX@/bin`)
- load the sqlite extension (use an absolute path in Windows notation, see below
for an example of an absolute path)
~~~bash
sqlite3
sqlite3> .load "C:/msys64@MINGW_PREFIX@/share/sqlite/extensions/csv.dll"
~~~
Usage information to each extension is contained in the header of the c-file
corresponding to the extension you can find in this directory.
More information here: https://www.sqlite.org/loadext.html#loading_an_extension.