Contents
========
* Source
* Notes

Source
======
I compiled sqlite 3.46.1 with DJGPP. The modifications can be found
in the src/ directory.

The original source and offline documentation can be found at:

<https://sqlite.org/2024/sqlite-src-3460100.zip>

<https://sqlite.org/2024/sqlite-doc-3460100.zip>

Notes
=====

FTS (Full Text Search)
----------------------
I found the following article helpful for using the FTS5 feature.

<https://kimsereylam.com/sqlite/2020/03/06/
full-text-search-with-sqlite.html>

List all FTS5 terms
-------------------

CREATE VIRTUAL TABLE content_vocab
USING fts5vocab('recipes_fts', 'col');
.mode csv
.output test.csv
SELECT term FROM content_vocab;
.output stdout
.q

<https://sqlite.org/fts5.html#the_fts5vocab_virtual_table_module>

UPDATE FROM (join)
------------------

UPDATE recipes_fts
SET title = z.title
FROM (SELECT id, title FROM recipes) AS z
where z.id = recipes_fts.id;