drh 92d252e06d Fix more harmless compiler warnings. 1 개월 전
..
README.md 4297584d66 Updates to the README.md file for the ext/misc directory. No code changes. 7 년 전
amatch.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
anycollseq.c b65b3e429a Add the anycollseq.c loadable extension in etc/misc 7 년 전
appendvfs.c a959bf5311 Add NULL checks on all sqlite3_vfs_find(0) calls. This is not strictly 3 년 전
base64.c 38c2052767 Handle newline-trimmed input TEXT correctly in base64, base85 UDFs. 1 년 전
base85.c 38c2052767 Handle newline-trimmed input TEXT correctly in base64, base85 UDFs. 1 년 전
basexx.c 273c2a9425 Fix compilation issue seen with MSVC. 1 년 전
blobio.c 0a0e89fa21 Fix an error message on the blobread() extension function so that it says 5 년 전
btreeinfo.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
carray.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
carray.h a794af53b4 Add the missing CARRAY_BLOB macro to the carray.h extension header. 1 년 전
cksumvfs.c 365b6e9769 Avoid spurious SQLITE_IOERR_DATA errors when reading partial pages from a cksumvfs database using a SQLITE_DIRECT_OVERFLOW_READ build. 9 달 전
closure.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
completion.c 9e278d7ec0 For shell completion, use pragma_table_xinfo instead of pragma_table_info, so that generated columns are handled, as reported in [forum:f0735e05d8d7e857|forum post f0735e05d8d7e857]. 6 달 전
compress.c ecaa021759 Fix harmless compiler warnings seen with MSVC. 7 달 전
csv.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
dbdump.c 067b92ba00 Extend the refactoring into extensions. Clean up stray newlines. 4 년 전
decimal.c 4d8eb16f07 Rename the decimal_sci() function to decimal_exp(). 1 년 전
eval.c 2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 5 년 전
explain.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
fileio.c 7119a6c16b Have the zipfile and fileio extensions use sqlite3_stdio.c when it is 3 달 전
fossildelta.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
fuzzer.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
ieee754.c 6aa5a42beb Add the ieee754_inc(r,N) function to the ieee754.c extension. 1 년 전
memstat.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
memtrace.c d46b6f57c9 Fix a harmless compiler warning in the memtrace.c extension. 6 년 전
memvfs.c a959bf5311 Add NULL checks on all sqlite3_vfs_find(0) calls. This is not strictly 3 년 전
mmapwarm.c 208f5c65d4 Fix harmless compiler warnings. 1 년 전
nextchar.c 2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 5 년 전
noop.c 4c43f1881e When doing a text-affinity comparison between two values where one or both 11 달 전
normalize.c 08b9208660 Fix harmless compiler warnings that surface in newer versions of GCC. 4 년 전
pcachetrace.c 3a202be6f1 Add the --pcachetrace option to the CLI. 1 년 전
percentile.c bf19927688 Fix the percentile extension so that works as an independent extension. 2 달 전
prefixes.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
qpvtab.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
randomjson.c 4449a1b66d Fix harmless compiler warning in the randomjson.c extension. 1 년 전
regexp.c 59b6a2bcbe Fix harmless compiler warning caused by [0772ddf56713d013]. 1 년 전
remember.c aabebc27b7 Comment changes clarifying details of the pointer-type parameter. No 7 년 전
rot13.c 6d35956c86 Fix the rot13.c extension to be deterministic. Add the noop.c extension. 5 년 전
scrub.c 067b92ba00 Extend the refactoring into extensions. Clean up stray newlines. 4 년 전
series.c 19c4fa92dd Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0. 2 달 전
sha1.c 165daef043 Add sha1() functions to the CLI. Fix sha1b() such that it actually returns 4 달 전
shathree.c 76412af157 Minor doc correction in ext/misc/shathree.c, as reported in the forum. No functional changes. 1 개월 전
showauth.c 249489331c Add the "showauth" extension in ext/misc. 10 년 전
spellfix.c c707b2eb6d Squash sign-comparison warnings reported in [forum:5e605a763a65c3f8 | forum post 5e605a763a65c3f8]. 3 달 전
sqlar.c 1002bcff43 Fix problem in sqlar_uncompress() when being used to extract symbolic links. 8 달 전
sqlite3_stdio.c e4d4d73397 Use Win32 APIs to read/write the console in Windows unless the 2 달 전
sqlite3_stdio.h a55901a27c Port sqldiff over to use sqlite3_stdio. 3 달 전
stmt.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
stmtrand.c 31079226f7 Add the stmtrand() extension function for use in testing. 7 달 전
templatevtab.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
totype.c 1cfc040bba Update extension ext/misc/totext.c to avoid both ubsan warnings and dubious real->integer conversions. 1 년 전
uint.c 3d42fb788a Fix harmless compiler warnings. 4 년 전
unionvtab.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
urifuncs.c be22a85406 Fix the urifuncs.c extension (used for testing and debugging only) so that 5 년 전
uuid.c 2b1c2aad9f Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set 5 년 전
vfslog.c a959bf5311 Add NULL checks on all sqlite3_vfs_find(0) calls. This is not strictly 3 년 전
vfsstat.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
vfstrace.c 92d252e06d Fix more harmless compiler warnings. 1 개월 전
vtablog.c 4397d28378 Improvements to the vtablog.c extension: Eliminate memory leaks. 9 달 전
vtshim.c 2f31d02049 In the 'vtshim' extension, avoid accessing freed memory when handling errors from xCreate/xConnect. 8 년 전
wholenumber.c 1935887a68 Ensure that all fields of static sqlite3_module objects are explicitly 1 년 전
zipfile.c 7119a6c16b Have the zipfile and fileio extensions use sqlite3_stdio.c when it is 3 달 전
zorder.c 510fea885e Add the zorder.c extension implementing zorder() and unzorder() SQL functions. 7 년 전

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.