stephan ba6510a399 Additional 'array index is signed char' warning cleanups for the shell and its embedded extensions, analog to [44bd44532d]. 2 napja
..
README.md 4297584d66 Updates to the README.md file for the ext/misc directory. No code changes. 7 éve
amatch.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
anycollseq.c b65b3e429a Add the anycollseq.c loadable extension in etc/misc 8 éve
appendvfs.c a959bf5311 Add NULL checks on all sqlite3_vfs_find(0) calls. This is not strictly 3 éve
base64.c 290caec8e3 Trying to remove a warning from some compiler that I do not have access to. 1 hónapja
base85.c 14bc98d8e2 Fix harmless "implicit fall through" warnings that suddenly appeared when 1 hónapja
basexx.c 273c2a9425 Fix compilation issue seen with MSVC. 1 éve
blobio.c 0a0e89fa21 Fix an error message on the blobread() extension function so that it says 5 éve
btreeinfo.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
carray.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
carray.h a794af53b4 Add the missing CARRAY_BLOB macro to the carray.h extension header. 2 éve
cksumvfs.c 365b6e9769 Avoid spurious SQLITE_IOERR_DATA errors when reading partial pages from a cksumvfs database using a SQLITE_DIRECT_OVERFLOW_READ build. 11 hónapja
closure.c 43afab28a0 GCC 13 has become more quite pedantic about the signature of functions matching the 1 hónapja
completion.c ba6510a399 Additional 'array index is signed char' warning cleanups for the shell and its embedded extensions, analog to [44bd44532d]. 2 napja
compress.c ecaa021759 Fix harmless compiler warnings seen with MSVC. 9 hónapja
csv.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
dbdump.c 067b92ba00 Extend the refactoring into extensions. Clean up stray newlines. 4 éve
decimal.c ba6510a399 Additional 'array index is signed char' warning cleanups for the shell and its embedded extensions, analog to [44bd44532d]. 2 napja
eval.c 2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 5 éve
explain.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
fileio.c 8d6e3f513c Avoid using Int32x32To64() with a 64-bit argument in fileio.c - this level of micro-optimization is not really necessary there. 2 hónapja
fossildelta.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
fuzzer.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
ieee754.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
memstat.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
memtrace.c d46b6f57c9 Fix a harmless compiler warning in the memtrace.c extension. 6 éve
memvfs.c a959bf5311 Add NULL checks on all sqlite3_vfs_find(0) calls. This is not strictly 3 éve
mmapwarm.c 208f5c65d4 Fix harmless compiler warnings. 1 éve
nextchar.c 2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 5 éve
noop.c 4c43f1881e When doing a text-affinity comparison between two values where one or both 1 éve
normalize.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
pcachetrace.c 3a202be6f1 Add the --pcachetrace option to the CLI. 1 éve
percentile.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
prefixes.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
qpvtab.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
randomjson.c 4449a1b66d Fix harmless compiler warning in the randomjson.c extension. 1 éve
regexp.c 43afab28a0 GCC 13 has become more quite pedantic about the signature of functions matching the 1 hónapja
remember.c aabebc27b7 Comment changes clarifying details of the pointer-type parameter. No 7 éve
rot13.c 6d35956c86 Fix the rot13.c extension to be deterministic. Add the noop.c extension. 5 éve
scrub.c 067b92ba00 Extend the refactoring into extensions. Clean up stray newlines. 4 éve
series.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
sha1.c 165daef043 Add sha1() functions to the CLI. Fix sha1b() such that it actually returns 5 hónapja
shathree.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
showauth.c 249489331c Add the "showauth" extension in ext/misc. 10 éve
spellfix.c c707b2eb6d Squash sign-comparison warnings reported in [forum:5e605a763a65c3f8 | forum post 5e605a763a65c3f8]. 5 hónapja
sqlar.c 1002bcff43 Fix problem in sqlar_uncompress() when being used to extract symbolic links. 10 hónapja
sqlite3_stdio.c 50637ca5c5 Apparently I got the logic of [abfe488ed67e2e35] confused, even backwards. 1 hónapja
sqlite3_stdio.h a55901a27c Port sqldiff over to use sqlite3_stdio. 5 hónapja
stmt.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
stmtrand.c 31079226f7 Add the stmtrand() extension function for use in testing. 9 hónapja
templatevtab.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
totype.c 5d60f47001 Approximately 50 typo fixes, spanning the whole tree, contributed via [forum:006c8fa165083ac3|forum post 006c8fa165083ac3] and individually checked for correctness. Affects only code comments, docs, and a single line of debug output in a test app. 1 hete
uint.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
unionvtab.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
urifuncs.c be22a85406 Fix the urifuncs.c extension (used for testing and debugging only) so that 5 éve
uuid.c 2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 5 éve
vfslog.c a959bf5311 Add NULL checks on all sqlite3_vfs_find(0) calls. This is not strictly 3 éve
vfsstat.c 5d60f47001 Approximately 50 typo fixes, spanning the whole tree, contributed via [forum:006c8fa165083ac3|forum post 006c8fa165083ac3] and individually checked for correctness. Affects only code comments, docs, and a single line of debug output in a test app. 1 hete
vfstrace.c da5f813878 Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|forum post 0db9827f0464bc33] and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. 1 hete
vtablog.c 4397d28378 Improvements to the vtablog.c extension: Eliminate memory leaks. 11 hónapja
vtshim.c 5d60f47001 Approximately 50 typo fixes, spanning the whole tree, contributed via [forum:006c8fa165083ac3|forum post 006c8fa165083ac3] and individually checked for correctness. Affects only code comments, docs, and a single line of debug output in a test app. 1 hete
wholenumber.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 éve
zipfile.c 7119a6c16b Have the zipfile and fileio extensions use sqlite3_stdio.c when it is 5 hónapja
zorder.c 510fea885e Add the zorder.c extension implementing zorder() and unzorder() SQL functions. 7 éve

README.md

Miscellaneous Extensions

This folder contains a collection of smaller loadable extensions. See https://www.sqlite.org/loadext.html for instructions on how to compile and use loadable extensions. Each extension in this folder is implemented in a single file of C code.

Each source file contains a description in its header comment. See the header comments for details about each extension. Additional notes are as follows:

  • carray.c — This module implements the carray table-valued function. It is a good example of how to go about implementing a custom table-valued function.

  • csv.c — A virtual table for reading Comma-Separated-Value (CSV) files.

  • dbdump.c — This is not actually a loadable extension, but rather a library that implements an approximate equivalent to the ".dump" command of the command-line shell.

  • json1.c — Various SQL functions and table-valued functions for processing JSON. This extension is already built into the SQLite amalgamation. See https://sqlite.org/json1.html for additional information.

  • memvfs.c — This file implements a custom VFS that stores an entire database file in a single block of RAM. It serves as a good example of how to implement a simple custom VFS.

  • rot13.c — This file implements the very simple rot13() substitution function. This file makes a good template for implementing new custom SQL functions for SQLite.

  • series.c — This is an implementation of the "generate_series" virtual table. It can make a good template for new custom virtual table implementations.

  • shathree.c — An implementation of the sha3() and sha3_query() SQL functions. The file is named "shathree.c" instead of "sha3.c" because the default entry point names in SQLite are based on the source filename with digits removed, so if we used the name "sha3.c" then the entry point would conflict with the prior "sha1.c" extension.

  • unionvtab.c — Implementation of the unionvtab and swarmvtab virtual tables. These virtual tables allow a single large table to be spread out across multiple database files. In the case of swarmvtab, the individual database files can be attached on demand.

  • zipfile.c — A virtual table that can read and write a ZIP archive.