home / 24ways-fts4

24ways-fts4

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

Custom SQL query returning 5 rows (hide)

Query parameters

This data as json, CSV

titleauthordecode_matchinfo(matchinfo(articles_fts, "pcx"))matchinfo(articles_fts, "pcx")
Geotag Everywhere with Fire Eagle Ben Ward [2, 3, 0, 2, 2, 0, 0, 0, 1, 163, 31, 0, 2, 2, 0, 0, 0, 2, 92, 21] <Binary: 80 bytes>
Unobtrusively Mapping Microformats with jQuery Simon Willison [2, 3, 1, 2, 2, 0, 0, 0, 39, 163, 31, 0, 2, 2, 0, 0, 0, 6, 92, 21] <Binary: 80 bytes>
Front-End Code Reusability with CSS and JavaScript Trevor Morris [2, 3, 0, 2, 2, 0, 0, 0, 14, 163, 31, 0, 2, 2, 0, 0, 0, 1, 92, 21] <Binary: 80 bytes>
Finding Your Way with Static Maps Drew McLellan [2, 3, 0, 2, 2, 0, 0, 0, 1, 163, 31, 1, 2, 2, 0, 0, 0, 11, 92, 21] <Binary: 80 bytes>
Your jQuery: Now With 67% Less Suck Scott Kosman [2, 3, 1, 2, 2, 0, 0, 0, 19, 163, 31, 0, 2, 2, 0, 0, 0, 2, 92, 21] <Binary: 80 bytes>
Powered by Datasette · Queries took 1.615ms · Data source: https://github.com/simonw/sqlite-fts4