stephan ba6510a399 Additional 'array index is signed char' warning cleanups for the shell and its embedded extensions, analog to [44bd44532d]. 18 hours ago
..
README.md 4297584d66 Updates to the README.md file for the ext/misc directory. No code changes. 7 years ago
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 week ago
anycollseq.c b65b3e429a Add the anycollseq.c loadable extension in etc/misc 8 years ago
appendvfs.c a959bf5311 Add NULL checks on all sqlite3_vfs_find(0) calls. This is not strictly 3 years ago
base64.c 290caec8e3 Trying to remove a warning from some compiler that I do not have access to. 1 month ago
base85.c 14bc98d8e2 Fix harmless "implicit fall through" warnings that suddenly appeared when 1 month ago
basexx.c 273c2a9425 Fix compilation issue seen with MSVC. 1 year ago
blobio.c 0a0e89fa21 Fix an error message on the blobread() extension function so that it says 5 years ago
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 week ago
carray.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
carray.h a794af53b4 Add the missing CARRAY_BLOB macro to the carray.h extension header. 2 years ago
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 months ago
closure.c 43afab28a0 GCC 13 has become more quite pedantic about the signature of functions matching the 1 month ago
completion.c ba6510a399 Additional 'array index is signed char' warning cleanups for the shell and its embedded extensions, analog to [44bd44532d]. 18 hours ago
compress.c ecaa021759 Fix harmless compiler warnings seen with MSVC. 9 months ago
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 week ago
dbdump.c 067b92ba00 Extend the refactoring into extensions. Clean up stray newlines. 4 years ago
decimal.c ba6510a399 Additional 'array index is signed char' warning cleanups for the shell and its embedded extensions, analog to [44bd44532d]. 18 hours ago
eval.c 2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 5 years ago
explain.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
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 months ago
fossildelta.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
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 week ago
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 week ago
memstat.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
memtrace.c d46b6f57c9 Fix a harmless compiler warning in the memtrace.c extension. 6 years ago
memvfs.c a959bf5311 Add NULL checks on all sqlite3_vfs_find(0) calls. This is not strictly 3 years ago
mmapwarm.c 208f5c65d4 Fix harmless compiler warnings. 1 year ago
nextchar.c 2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 5 years ago
noop.c 4c43f1881e When doing a text-affinity comparison between two values where one or both 1 year ago
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 week ago
pcachetrace.c 3a202be6f1 Add the --pcachetrace option to the CLI. 1 year ago
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 week ago
prefixes.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
qpvtab.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
randomjson.c 4449a1b66d Fix harmless compiler warning in the randomjson.c extension. 1 year ago
regexp.c 43afab28a0 GCC 13 has become more quite pedantic about the signature of functions matching the 1 month ago
remember.c aabebc27b7 Comment changes clarifying details of the pointer-type parameter. No 7 years ago
rot13.c 6d35956c86 Fix the rot13.c extension to be deterministic. Add the noop.c extension. 5 years ago
scrub.c 067b92ba00 Extend the refactoring into extensions. Clean up stray newlines. 4 years ago
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 week ago
sha1.c 165daef043 Add sha1() functions to the CLI. Fix sha1b() such that it actually returns 5 months ago
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 week ago
showauth.c 249489331c Add the "showauth" extension in ext/misc. 10 years ago
spellfix.c c707b2eb6d Squash sign-comparison warnings reported in [forum:5e605a763a65c3f8 | forum post 5e605a763a65c3f8]. 5 months ago
sqlar.c 1002bcff43 Fix problem in sqlar_uncompress() when being used to extract symbolic links. 10 months ago
sqlite3_stdio.c 50637ca5c5 Apparently I got the logic of [abfe488ed67e2e35] confused, even backwards. 1 month ago
sqlite3_stdio.h a55901a27c Port sqldiff over to use sqlite3_stdio. 5 months ago
stmt.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
stmtrand.c 31079226f7 Add the stmtrand() extension function for use in testing. 9 months ago
templatevtab.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
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 week ago
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 week ago
unionvtab.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
urifuncs.c be22a85406 Fix the urifuncs.c extension (used for testing and debugging only) so that 5 years ago
uuid.c 2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 5 years ago
vfslog.c a959bf5311 Add NULL checks on all sqlite3_vfs_find(0) calls. This is not strictly 3 years ago
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 week ago
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 week ago
vtablog.c 4397d28378 Improvements to the vtablog.c extension: Eliminate memory leaks. 11 months ago
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 week ago
wholenumber.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 year ago
zipfile.c 7119a6c16b Have the zipfile and fileio extensions use sqlite3_stdio.c when it is 5 months ago
zorder.c 510fea885e Add the zorder.c extension implementing zorder() and unzorder() SQL functions. 7 years ago

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.