Help: sqlite3

The "sqlite3" 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 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.


Skip opening the repository database
Open the repository read-only. No changes are allowed. This is a recommended safety precaution to prevent repository damage.
Use REPOSITORY as the repository database
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:

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

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

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

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 text X. Undoes the work of compress(X).

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

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

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

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

A table-valued function that returns info on all files contained in check-in X. Example:
SELECT * FROM files_of_checkin('trunk');

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

Return the number of seconds since 1970.

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.

The REGEXP operator works, unlike in standard SQLite.

Return the BLOB.RID corresponding to symbolic name X.