24ways-fts4

Data source: https://github.com/simonw/sqlite-fts4

Custom SQL query

articles

title, contents, year, author, author_slug, published, url, topic

336 rows

articles_fts (hidden)

title, author, contents

Many rows

articles_fts_docsize (hidden)

docid, size

336 rows

articles_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

4 rows

articles_fts_segments (hidden)

blockid, block

487 rows

articles_fts_stat (hidden)

id, value

1 row

Download SQLite DB: 24ways-fts4.db 5.5 MB