590
edits
Firefox/Projects/about:me: Difference between revisions
Jump to navigation
Jump to search
→Design
Comrade693 (talk | contribs) (→Design: Adding query) |
Comrade693 (talk | contribs) (→Design) |
||
| Line 25: | Line 25: | ||
* number of history visits | * number of history visits | ||
SELECT COUNT(1) | SELECT COUNT(1) | ||
FROM moz_historyvisits | |||
WHERE visit_type NOT IN (0, 4) | |||
* number of unique URLs | * number of unique URLs | ||
SELECT COUNT(1) | SELECT COUNT(1) | ||
FROM moz_places | |||
WHERE hidden <> 1 | |||
* fav sites (top 5-10, total visits, avg visits per day) | * fav sites (top 5-10, total visits, avg visits per day) | ||
total visits | |||
SELECT * | |||
FROM moz_places | |||
ORDER BY visit_count | |||
LIMIT 10 | |||
avg visits per day | |||
* day of week stats (eg: "sat broader, sun has more revisits") | |||
would need total visits (sunday is 0) | |||
SELECT COUNT(1) | |||
FROM moz_historyvisits | |||
WHERE visit_type NOT IN (0, 4) | |||
GROUP BY strftime('%w', ROUND(visit_date / 1000000)) | |||
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) | ||
* total browsing uptime (via history, maybe goes in App) | * total browsing uptime (via history, maybe goes in App) | ||
| Line 54: | Line 59: | ||
* top URLs most selected from the awesomebar | * top URLs most selected from the awesomebar | ||
* number of bookmarks | * number of bookmarks | ||
* url and date of oldest bookmark | SELECT COUNT(1) | ||
FROM moz_bookmarks | |||
WHERE parent <> :tag_root | |||
AND parent <> :places_root | |||
* url and date of oldest bookmark (oldest by what?) | |||
* graph of bookmark activity over time | * graph of bookmark activity over time | ||
* number of tags | * number of tags | ||
SELECT COUNT(1) | |||
FROM moz_bookmarks | |||
WHERE parent = :tag_root | |||
* revisitation | * revisitation | ||
** average or median visits per URL | ** average or median visits per URL | ||