mirror of
https://github.com/sqlite/sqlite.git
synced 2025-10-24 09:53:10 +03:00
cdaff852bf
amalgamation, that integration might look something like this. FossilOrigin-Name: 2b43d5d7dcc5aee14a050c824a5e09b6a38a9c78ddcc25a994eba5d4c5ad9ba2
51 lines
2.4 KiB
Markdown
51 lines
2.4 KiB
Markdown
## Miscellaneous Extensions
|
|
|
|
This folder contains a collection of smaller loadable extensions.
|
|
See <https://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:
|
|
|
|
* **csv.c** — A [virtual table](https://sqlite.org/vtab.html)
|
|
for reading
|
|
[Comma-Separated-Value (CSV) files](https://en.wikipedia.org/wiki/Comma-separated_values).
|
|
|
|
* **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](https://sqlite.org/cli.html).
|
|
|
|
* **json1.c** — Various SQL functions and table-valued functions
|
|
for processing JSON. This extension is already built into the
|
|
[SQLite amalgamation](https://sqlite.org/amalgamation.html). See
|
|
<https://sqlite.org/json1.html> for additional information.
|
|
|
|
* **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](https://sqlite.org/vtab.html).
|
|
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](https://sqlite.org/swarmvtab.html) 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](https://sqlite.org/vtab.html)
|
|
that can read and write a
|
|
[ZIP archive](https://en.wikipedia.org/wiki/Zip_%28file_format%29).
|