mirror of
https://github.com/sqlite/sqlite.git
synced 2025-10-22 22:13:04 +03:00
1d574d3d71
See [forum:/forumpost/91811439aa|forum post 91811439aa] for the complaint that prompted me to take down this demonstration code. I have other things to do rather than argue about posts such as the foregoing, so it is easier to just take the code down. If you need this code, you can downloading older check-ins. The beauty of DAG-based version control systems like Fossil (and Git) is that nothing is ever lost; it is just stops appearing on trunk. FossilOrigin-Name: eb79110dcac80dde3bcca0929d67a8f8f6d2eea5695184b2b7c6788283f06902
56 lines
2.6 KiB
Markdown
56 lines
2.6 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:
|
|
|
|
* **carray.c** — This module implements the
|
|
[carray](https://sqlite.org/carray.html) table-valued function.
|
|
It is a good example of how to go about implementing a custom
|
|
[table-valued function](https://sqlite.org/vtab.html#tabfunc2).
|
|
|
|
* **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).
|