The "sql" command:

Usage: fossil sql ?OPTIONS?

Run the sqlite3 command-line shell on the Fossil repository identified by the -R option, or on the current repository. See https://www.sqlite.org/cli.html for additional information about the sqlite3 command-line shell.

WARNING: Careless use of this command can corrupt a Fossil repository in ways that are unrecoverable. Be sure you know what you are doing before running any SQL commands that modify the repository database. Use the --readonly option to prevent accidental damage to the repository.

Options:

--no-repository

Skip opening the repository database

--readonly

Open the repository read-only. No changes are allowed. This is a recommended safety precaution to prevent repository damage.

-R REPOSITORY

Use REPOSITORY as the repository database

--test

Enable some testing and analysis features that are normally disabled.

All of the standard sqlite3 command-line shell options should also work.

The following SQL extensions are provided with this Fossil-enhanced version of the sqlite3 command-line shell:

builtin

A virtual table that contains one row for each datafile that is built into the Fossil binary.

checkin_mtime(X,Y)

Return the mtime for the file Y (a BLOB.RID) found in check-in X (another BLOB.RID value).

compress(X)

Compress text X with the same algorithm used to compress artifacts in the BLOB table.

content(X)

Return the content of artifact X. X can be an artifact hash or hash prefix or a tag. Artifacts are stored compressed and deltaed. This function does all necessary decompression and undeltaing.

decompress(X)

Decompress text X. Undoes the work of compress(X).

delta_apply(X,D)

Apply delta D to source blob X and return the result.

delta_create(X,Y)

Create and return a delta that will convert X into Y.

delta_output_size(D)

Return the number of bytes of output to expect when applying delta D

delta_parse(D)

A table-valued function that deconstructs delta D and returns rows for each element of that delta.

files_of_checkin(X)

A table-valued function that returns info on all files contained in check-in X. Example:

SELECT * FROM files_of_checkin('trunk');

helptext

A virtual table with one row for each command, webpage, and setting together with the built-in help text.

now()

Return the number of seconds since 1970.

obscure(T)

Obfuscate the text password T so that its original value is not readily visible. Fossil uses this same algorithm when storing passwords of remote URLs.

regexp

The REGEXP operator works, unlike in standard SQLite.

symbolic_name_to_rid(X)

Return the BLOB.RID corresponding to symbolic name X.