{"id":1248,"date":"2022-01-11T07:23:03","date_gmt":"2022-01-11T07:23:03","guid":{"rendered":"https:\/\/ethosspace.com\/programmers\/?p=1248"},"modified":"2022-01-12T09:31:14","modified_gmt":"2022-01-12T09:31:14","slug":"how-to-analyse-and-improve-your-time-spent-on-the-internet","status":"publish","type":"post","link":"https:\/\/ethosspace.com\/programmers\/how-to-analyse-and-improve-your-time-spent-on-the-internet\/","title":{"rendered":"How to Analyse and Improve your time spent on the Internet"},"content":{"rendered":"\n

If you spend time on the internet and browse websites. Then this post will assist you in determining where you spend the majority of your productive time.<\/p>\n\n\n\n

So to identify result like below follow the steps as mentioned<\/p>\n\n\n\n

\"Summary<\/figure>\n\n\n\n

To analyze the google chrome history browser file here are the steps. <\/p>\n\n\n\n

Step 1) Install DbBrowser SQLite<\/a> locally.<\/p>\n\n\n\n

Step 2) Open SQLite DB Browser <\/p>\n\n\n\n

Step 3) Windows users can navigate to the directory <\/p>\n\n\n\n

C:\\Users\\<UserName><\/strong>\\AppData\\Local\\Google\\Chrome\\User Data\\Default\\<\/p>\n\n\n\n

MAC user can navgiate to directory<\/p>\n\n\n\n

Users\/\/Library\/Application Support\/Google\/Chrome\/Default\/<\/p>\n\n\n\n

Step 4) Copy History File to any other Location you want<\/p>\n\n\n\n

\"History
Chrome History file location<\/figcaption><\/figure>\n\n\n\n

Step 5) Now open the history file in DBBrowser SQLite. By Clicking on Open Database menu and providing History file where you copied in step 4.<\/p>\n\n\n\n

\"DB
History File in SQLite DB Browser<\/figcaption><\/figure>\n\n\n\n

Run below Query in Execute SQL Tab <\/p>\n\n\n\n

SELECT \n  SUBSTR(SUBSTR(url, INSTR(url, '\/\/') + 2), 0, INSTR(SUBSTR(url, INSTR(url, '\/\/') + 2), '\/')) AS domain,\n  SUM(visit_count) AS total_visits\nFROM urls\n    WHERE url LIKE 'http%'\n    GROUP BY domain\n    ORDER BY total_visits DESC;<\/code><\/pre><\/div>\n\n\n\n
\"Query<\/figure>\n\n\n\n
By Executing the above query you will get results like how many times you are visiting a specific website.<\/p>\n\n\n\n
Also we by using SQL Queries we are able to fetch the time invested on each website.<\/p>\n","protected":false},"excerpt":{"rendered":"
If you spend time on the internet and browse websites. Then this post will assist you in determining where you spend the majority of your productive time. So to identify result like below follow the steps as mentioned To analyze the google chrome history browser file here are the steps. Step 1) Install DbBrowser SQLite […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[24,17,20,26,27],"tags":[],"class_list":["post-1248","post","type-post","status-publish","format-standard","hentry","category-configuration-and-setup","category-miscellaneous","category-software-automation-testing","category-software-testing","category-sqlite"],"aioseo_notices":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"sparkling-featured":false,"sparkling-featured-fullwidth":false,"tab-small":false},"uagb_author_info":{"display_name":"program45_-rt8nb","author_link":"https:\/\/ethosspace.com\/programmers\/author\/program45_-rt8nb\/"},"uagb_comment_info":0,"uagb_excerpt":"If you spend time on the internet and browse websites. Then this post will assist you in determining where you spend the majority of your productive time. So to identify result like below follow the steps as mentioned To analyze the google chrome history browser file here are the steps. Step 1) Install DbBrowser SQLite…","_links":{"self":[{"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/posts\/1248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/comments?post=1248"}],"version-history":[{"count":6,"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/posts\/1248\/revisions"}],"predecessor-version":[{"id":1272,"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/posts\/1248\/revisions\/1272"}],"wp:attachment":[{"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/media?parent=1248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/categories?post=1248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ethosspace.com\/programmers\/wp-json\/wp\/v2\/tags?post=1248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}