Don't use annotations for images
Supporting hi dpi icons requires new storage anyway.
Favicons are cached for 7 days.
Use a DB but a separate one. Then use attach database to do queries across databases.
SQLite has solid full text indexing capabilities.
Not done because we lack a good tokenizer and don't have resources. International tokenization is hard. We do have ICU under intl.
We could just enable the SQLite extension and link to ICU. Needs platform support to change the build in this way.
We can ignore this for now and use thunderbird's tokenizer.
The current heuristic is a hack around how hard it is to do normalized scoring.
Moz_historyvisits contains visit type which we can use like from_visit with a WITH clause.
SQLite actually has a great query planner. We are part of the SQLite consortium.
Keep historyvisits as small as possible because we record every visit. Other browsers don't keep all the redirects.
Keeping historyvisits under 50mb is ideal. We pin it at 100, but there's no reason.
The Google team created Places during ff 3 early stages, then left to work on chrome.
There was an effort to put html in the awesomebar, but it was abandoned because of accessibility concerns.
Suggestion: put booleans or very small integers in places, create a new db for everything else, like strings or blobs.