sqlite-ext

NAME

SYNOPSIS

WA2LWinTools/lib/sqlite/extension.dll

AVAILABILITY

DESCRIPTION

This feature allows the code for extensions to be developed and tested separately from the application and then loaded on an as-needed basis.

An SQLite extension is a shared library or DLL. To load it, you need to supply SQLite with the name of the file containing the shared library or DLL and an entry point to initialize the extension.

For more information about extensions, see: https://sqlite.org/loadext.html

BUNDLED EXTENSIONS

crypto:

hashing, encoding and decoding data

define:

user-defined functions and dynamic sql

fileio:

read and write files

fuzzy:

fuzzy string matching and phonetics

ipaddr:

IP address manipulation

math:

math functions

regexp:

regular expressions

stats:

math statistics

text:

string functions and Unicode

time:

high-precision date/time

uuid:

Universally Unique IDentifiers

vsv:

CSV files as virtual tables

See: https://github.com/nalgeon/sqlean#main-set for a documentation of each extension.

OPTIONS

.load extension

load an extension in sqlite3(3).

ENVIRONMENT

%PATH%

the %PATH% environment variable is extended with var/lib/sqlite/ and lib/sqlite/ in wtshell to enable sqlite3(3) to use '.load extension' without the need to supply an absolute or relative path to the file.

To check/print the %PATH% in wtshell, the path -l command can be used.

EXIT STATUS

FILES

lib/sqlite/

extensions bundled with WA2L/WinTools.

var/lib/sqlite/

user supplied extensions.

EXAMPLES

1) load and use an extension

In this example the time extension is loaded and the function time_fmt_iso is used:

  [ H:\bin\WA2LWinTools\var\tmp ]
  [ fred@acme007 ][*wtshell*/cmd]: sqlite
  
  SQLite version 3.51.1 2025-11-28 17:28:25
  Enter ".help" for usage hints.
  Connected to a transient in-memory database.
  Use ".open FILENAME" to reopen on a persistent database.

  sqlite> .load time

  sqlite> select time_fmt_iso(time_date(2011, 11, 18));
  2011-11-18T00:00:00Z

  sqlite> .quit

SEE ALSO

NOTES

BUGS

AUTHOR

COPYRIGHT

This is free software; see WA2LWinTools/man/COPYING for copying conditions. There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.