back to 4.1.0-doc
SQLite 3.7.17 experimental extensions
The most recent SQLite 3.7.17 (released on 2013-05-20) introduces many interesting news; please read the release notes:- fully memory mapped I/O is now supported.
- the load_extension() is now smarter than before.
Any platform-specifi file suffix identifying a dynamically loadable extension (e.g. .dll, .so, .dylib) can new be omitted at all, and will be internally handled as appropriate by SQLite itself.
Last but not least, many new experimental extensions are now available:
- amatch
- closure
- fuzzer
- ieee754
- nextchar
- regexp
- rot13
- spellfix
- wholenumber
All these extra extensions aren't yet officially included in SQLite; anyway you can eventually download the corresponding source code form the SQLite's own Fossil repository. For your convenience, you can download these sources also from here
Each source contains a reasonably decent and comprehensive documentation about the corresponding extension.
Please note: both spatialite-4.1.0 and spatialite_gui-1.7.0 Windows binaries include SQLite 3.7.17, so you can eventually test these further extra-extensions in the easiest way. You'll find the pre-built extensions' binaries on sqlite-3.7.17-extra-DLL-win-x86.zip and sqlite-3.7.17-extra-DLL-win-amd64.zip
Just a simple example: the extension module rot13 supports a popular symmetric obfuscated encoding often used for WEB applications.
SELECT load_extension('rot13');
SELECT rot13('Sandro Furieri is an Italian developer');
-----
Fnaqeb Shevrev vf na Vgnyvna qrirybcre
SELECT rot13('Fnaqeb Shevrev vf na Vgnyvna qrirybcre');
-----
Sandro Furieri is an Italian developer
You simply have to copy the loadable extension's DLL in the same folder already containing spatialite.exe or spatialite_gui.exe; then by simply invoking load_extension() you'll be able to load and initialize the required extra extensions.
back to 4.1.0-doc