sqlite

mirror of https://github.com/sqlite/sqlite.git synced 2024-11-24 16:18:08 +01:00

History

drh 178ce6287b Enhance the vfstrace extension such that the output can be controlled using the "PRAGMA vfstrace('...');" statement. See header comment on the source code for details. FossilOrigin-Name: 96105d33597765c23dbd490b3aa0c2273731d1970d7041720e9f043dbe3517b3		2024-11-15 20:39:41 +00:00
..
amatch.c
anycollseq.c
appendvfs.c
base64.c
base85.c
basexx.c
blobio.c
btreeinfo.c
carray.c
carray.h
cksumvfs.c
closure.c
completion.c
compress.c
csv.c
dbdump.c
decimal.c
eval.c
explain.c
fileio.c	Have the zipfile and fileio extensions use sqlite3_stdio.c when it is	2024-09-25 15:26:37 +00:00
fossildelta.c
fuzzer.c
ieee754.c
memstat.c
memtrace.c
memvfs.c
mmapwarm.c
nextchar.c
noop.c
normalize.c
pcachetrace.c
percentile.c	Fix the percentile extension so that works as an independent extension.	2024-11-04 20:16:30 +00:00
prefixes.c
qpvtab.c
randomjson.c
README.md
regexp.c
remember.c
rot13.c
scrub.c
series.c	Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0.	2024-11-05 18:25:32 +00:00
sha1.c
shathree.c
showauth.c
spellfix.c	Squash sign-comparison warnings reported in [forum:5e605a763a65c3f8 \| forum post 5e605a763a65c3f8].	2024-09-27 16:20:03 +00:00
sqlar.c
sqlite3_stdio.c	Use Win32 APIs to read/write the console in Windows unless the	2024-11-11 17:02:29 +00:00
sqlite3_stdio.h	Port sqldiff over to use sqlite3_stdio.	2024-09-24 17:40:54 +00:00
stmt.c
stmtrand.c
templatevtab.c
totype.c
uint.c
unionvtab.c
urifuncs.c
uuid.c
vfslog.c
vfsstat.c
vfstrace.c	Enhance the vfstrace extension such that the output can be controlled using	2024-11-15 20:39:41 +00:00
vtablog.c
vtshim.c
wholenumber.c
zipfile.c	Have the zipfile and fileio extensions use sqlite3_stdio.c when it is	2024-09-25 15:26:37 +00:00
zorder.c

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.