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, "pcxnalyb"), "pcxnalyb")) |
|---|---|---|---|
| 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"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 5,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 2695,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 1,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 2,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
4,
4
],
"decoded": {
"phrase_0": "00100000000000000000000000000000",
"phrase_1": "00100000000000000000000000000000"
}
}
} |
| 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"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 5,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 2397,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 1,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 39,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 6,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
5,
4
],
"decoded": {
"phrase_0": "10100000000000000000000000000000",
"phrase_1": "00100000000000000000000000000000"
}
}
} |
| 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"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 8,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 1956,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 14,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 1,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
4,
4
],
"decoded": {
"phrase_0": "00100000000000000000000000000000",
"phrase_1": "00100000000000000000000000000000"
}
}
} |
| 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"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 6,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 1247,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 1,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 1,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 11,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
4,
5
],
"decoded": {
"phrase_0": "00100000000000000000000000000000",
"phrase_1": "10100000000000000000000000000000"
}
}
} |
| 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"
},
"n": {
"value": 336,
"title": "Number of rows in the FTS4 table",
"idx": 20
},
"a": {
"title": "Average number of tokens in each column across the whole table",
"value": [
{
"column_index": 0,
"average_num_tokens": 5,
"idx": 21
},
{
"column_index": 1,
"average_num_tokens": 2,
"idx": 22
},
{
"column_index": 2,
"average_num_tokens": 1653,
"idx": 23
}
]
},
"l": {
"title": "Number of tokens in each column of the current row of the FTS4 table",
"value": [
{
"column_index": 0,
"num_tokens": 7,
"idx": 24
},
{
"column_index": 1,
"num_tokens": 2,
"idx": 25
},
{
"column_index": 2,
"num_tokens": 1987,
"idx": 26
}
]
},
"y": {
"value": [
{
"phrase_index": 0,
"column_index": 0,
"hits_for_phrase_in_col": 1,
"idx": 27
},
{
"phrase_index": 0,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 28
},
{
"phrase_index": 0,
"column_index": 2,
"hits_for_phrase_in_col": 19,
"idx": 29
},
{
"phrase_index": 1,
"column_index": 0,
"hits_for_phrase_in_col": 0,
"idx": 30
},
{
"phrase_index": 1,
"column_index": 1,
"hits_for_phrase_in_col": 0,
"idx": 31
},
{
"phrase_index": 1,
"column_index": 2,
"hits_for_phrase_in_col": 2,
"idx": 32
}
],
"title": "Usable phrase matches for each phrase/column combination"
},
"b": {
"title": "Bitfield showing which phrases occur in which columns",
"value": [
5,
4
],
"decoded": {
"phrase_0": "10100000000000000000000000000000",
"phrase_1": "00100000000000000000000000000000"
}
}
} |