24ways-fts4
Data source: https://github.com/simonw/sqlite-fts4
title | author | decode_matchinfo(matchinfo(articles_fts, "pcx")) | json_object("pre", annotate_matchinfo(matchinfo(articles_fts, "pcx"), "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] | { "p": { "value": 2, "title": "Number of matchable phrases in the query", "idx": 0 }, "c": { "value": 3, "title": "Number of user defined columns in the FTS table", "idx": 1 }, "x": { "value": [ { "phrase_index": 0, "column_index": 0, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 2, 3, 4 ] }, { "phrase_index": 0, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 5, 6, 7 ] }, { "phrase_index": 0, "column_index": 2, "hits_this_column_this_row": 1, "hits_this_column_all_rows": 163, "docs_with_hits": 31, "idxs": [ 8, 9, 10 ] }, { "phrase_index": 1, "column_index": 0, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 11, 12, 13 ] }, { "phrase_index": 1, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 14, 15, 16 ] }, { "phrase_index": 1, "column_index": 2, "hits_this_column_this_row": 2, "hits_this_column_all_rows": 92, "docs_with_hits": 21, "idxs": [ 17, 18, 19 ] } ], "title": "Details for each phrase/column combination" } } |
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] | { "p": { "value": 2, "title": "Number of matchable phrases in the query", "idx": 0 }, "c": { "value": 3, "title": "Number of user defined columns in the FTS table", "idx": 1 }, "x": { "value": [ { "phrase_index": 0, "column_index": 0, "hits_this_column_this_row": 1, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 2, 3, 4 ] }, { "phrase_index": 0, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 5, 6, 7 ] }, { "phrase_index": 0, "column_index": 2, "hits_this_column_this_row": 39, "hits_this_column_all_rows": 163, "docs_with_hits": 31, "idxs": [ 8, 9, 10 ] }, { "phrase_index": 1, "column_index": 0, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 11, 12, 13 ] }, { "phrase_index": 1, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 14, 15, 16 ] }, { "phrase_index": 1, "column_index": 2, "hits_this_column_this_row": 6, "hits_this_column_all_rows": 92, "docs_with_hits": 21, "idxs": [ 17, 18, 19 ] } ], "title": "Details for each phrase/column combination" } } |
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] | { "p": { "value": 2, "title": "Number of matchable phrases in the query", "idx": 0 }, "c": { "value": 3, "title": "Number of user defined columns in the FTS table", "idx": 1 }, "x": { "value": [ { "phrase_index": 0, "column_index": 0, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 2, 3, 4 ] }, { "phrase_index": 0, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 5, 6, 7 ] }, { "phrase_index": 0, "column_index": 2, "hits_this_column_this_row": 14, "hits_this_column_all_rows": 163, "docs_with_hits": 31, "idxs": [ 8, 9, 10 ] }, { "phrase_index": 1, "column_index": 0, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 11, 12, 13 ] }, { "phrase_index": 1, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 14, 15, 16 ] }, { "phrase_index": 1, "column_index": 2, "hits_this_column_this_row": 1, "hits_this_column_all_rows": 92, "docs_with_hits": 21, "idxs": [ 17, 18, 19 ] } ], "title": "Details for each phrase/column combination" } } |
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] | { "p": { "value": 2, "title": "Number of matchable phrases in the query", "idx": 0 }, "c": { "value": 3, "title": "Number of user defined columns in the FTS table", "idx": 1 }, "x": { "value": [ { "phrase_index": 0, "column_index": 0, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 2, 3, 4 ] }, { "phrase_index": 0, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 5, 6, 7 ] }, { "phrase_index": 0, "column_index": 2, "hits_this_column_this_row": 1, "hits_this_column_all_rows": 163, "docs_with_hits": 31, "idxs": [ 8, 9, 10 ] }, { "phrase_index": 1, "column_index": 0, "hits_this_column_this_row": 1, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 11, 12, 13 ] }, { "phrase_index": 1, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 14, 15, 16 ] }, { "phrase_index": 1, "column_index": 2, "hits_this_column_this_row": 11, "hits_this_column_all_rows": 92, "docs_with_hits": 21, "idxs": [ 17, 18, 19 ] } ], "title": "Details for each phrase/column combination" } } |
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] | { "p": { "value": 2, "title": "Number of matchable phrases in the query", "idx": 0 }, "c": { "value": 3, "title": "Number of user defined columns in the FTS table", "idx": 1 }, "x": { "value": [ { "phrase_index": 0, "column_index": 0, "hits_this_column_this_row": 1, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 2, 3, 4 ] }, { "phrase_index": 0, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 5, 6, 7 ] }, { "phrase_index": 0, "column_index": 2, "hits_this_column_this_row": 19, "hits_this_column_all_rows": 163, "docs_with_hits": 31, "idxs": [ 8, 9, 10 ] }, { "phrase_index": 1, "column_index": 0, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 2, "docs_with_hits": 2, "idxs": [ 11, 12, 13 ] }, { "phrase_index": 1, "column_index": 1, "hits_this_column_this_row": 0, "hits_this_column_all_rows": 0, "docs_with_hits": 0, "idxs": [ 14, 15, 16 ] }, { "phrase_index": 1, "column_index": 2, "hits_this_column_this_row": 2, "hits_this_column_all_rows": 92, "docs_with_hits": 21, "idxs": [ 17, 18, 19 ] } ], "title": "Details for each phrase/column combination" } } |