63
edits
Firefox/Projects/about:me: Difference between revisions
→Design
No edit summary |
(→Design) |
||
| Line 74: | Line 74: | ||
= Design = | = Design = | ||
potential sections | Original design ideas for some potential sections and datapoints. | ||
History & Bookmarks | == History & Bookmarks == | ||
* number of history visits | * number of history visits | ||
SELECT COUNT(1) | SELECT COUNT(1) | ||
| Line 88: | Line 88: | ||
* fav sites (top 5-10, total visits, avg visits per day) | * fav sites (top 5-10, total visits, avg visits per day) | ||
SELECT * | SELECT * | ||
FROM moz_places | FROM moz_places | ||
| Line 94: | Line 93: | ||
LIMIT 10 | LIMIT 10 | ||
avg visits per day | * avg visits per day | ||
* day of week stats (eg: "sat broader, sun has more revisits") - would need total visits (sunday is 0) | |||
* day of week stats (eg: "sat broader, sun has more revisits") | |||
would need total visits (sunday is 0) | |||
SELECT COUNT(1) | SELECT COUNT(1) | ||
FROM moz_historyvisits | FROM moz_historyvisits | ||
| Line 104: | Line 101: | ||
GROUP BY strftime('%w', ROUND(visit_date / 1000000)) | GROUP BY strftime('%w', ROUND(visit_date / 1000000)) | ||
number of unique URLs for each day of the week (sunday is 0) | * number of unique URLs for each day of the week (sunday is 0) | ||
I don't think it is possible to construct a query for this | |||
* graph of history volume over time (visits per week since start of history accumulation) | * graph of history volume over time (visits per week since start of history accumulation) | ||
| Line 129: | Line 126: | ||
** percentage of visits that are bookmarked or tagged pages | ** percentage of visits that are bookmarked or tagged pages | ||
Downloads | == Downloads == | ||
* total bytes downloaded | * total bytes downloaded | ||
| Line 155: | Line 152: | ||
* graph of download activity over time | * graph of download activity over time | ||
Other | == Other == | ||
* avg num open tabs | * avg num open tabs | ||