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;