Skip to main content

How to Analyse and Improve your time spent on the Internet

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

Summary of Total Number of Websites Visited with count

To analyze the google chrome history browser file here are the steps.

Step 1) Install DbBrowser SQLite locally.

Step 2) Open SQLite DB Browser

Step 3) Windows users can navigate to the directory

C:\Users\<UserName>\AppData\Local\Google\Chrome\User Data\Default\

MAC user can navgiate to directory

Users//Library/Application Support/Google/Chrome/Default/

Step 4) Copy History File to any other Location you want

History File location in Windows Environment under C Drive
Chrome History file location

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.

DB Browser SQLite Home Screen
History File in SQLite DB Browser

Run below Query in Execute SQL Tab

SELECT 
  SUBSTR(SUBSTR(url, INSTR(url, '//') + 2), 0, INSTR(SUBSTR(url, INSTR(url, '//') + 2), '/')) AS domain,
  SUM(visit_count) AS total_visits
FROM urls
    WHERE url LIKE 'http%'
    GROUP BY domain
    ORDER BY total_visits DESC;
Query Result screen

By Executing the above query you will get results like how many times you are visiting a specific website.

Also we by using SQL Queries we are able to fetch the time invested on each website.

Compare Result with Different Search Engine using batch file

To see what results in different search engines provide for a specific query then copy the below code in notepad. Save that file as “abc.bat” and double-click on it.
By using an alternative search engine we can see different results for the same query.

@start www.google.com/search?q=ethosspace+Software+Testing+Services
@start https://www.bing.com/search?q=ethosspace+Software+Testing+Services
@start https://duckduckgo.com/?q=ethosspace+software+testing+services
@start https://search.yahoo.com/search?q=ethosspace+Software+Testing+Services
@start https://www.ecosia.org/search?q=ethosspace+software+testing+services
@start https://yandex.com/search/?text=ethosspace+software+testing+services
@start https://duckduckgo.com/?q=ethosspace+software+testing+services
@start https://www.lukol.com/s.php?q=ethosspace+software+testing+services
@start https://metager.org/meta/meta.ger3?eingabe=ethosspace+software+testing+services

Most of the search engines use parameters as search?q with the search string. Some search engines use parameter as ?q with search string.

For example, here we have used the search string as “ethosspace+Software+Testing+Services” so the same can be used differently for different search engines. The format is mentioned above code.

Online C Compilers easy to debug and run

Online C compilers provide facility to code from anywhere and run it. There are many online compilers available online but here is the one which is more useful and tested.

  1. OnlineGDB
  • This compile program in C , Turbo C as per option we select.
  • Editor provide to copy and paste the code. We can type new code and after that run and debug it.
  • This online code compiler provide facility to share written program.
  • User can pass command line arguments as well.
  • Facility to organize written code in tabular format.
  • Three different editor mode are provided like normal, Emacs, VIM.
  • It takes no time to return program output
  • facility to save program, projects by signing up.
  • Easy to share and Embed written code to any other website.

Online GDB complier is useful for languages like C, C++, Python, Java, PHP, C#, HTML, CSS, RUBY, PERL, Pascal, R, Fortran, Haskell, SQLite, Prolog, Swift, Rust, Go, Bash.

Other compilers which are available and also useful are

2) Programiz

3) Tutorialspoint

4) Onecompiler

5) Jdoodle

How to Create multiple directories using command prompt

Using windows command prompt we can create multiple directories at once in easy steps as defined below.

Step 1) Open Windows command prompt by typing “cmd” in type here to search and press enter. After Pressing enter windows will open command prompt.

Type CMD to open command Prompt
Windows Command Prompt

Step 2) Change Directory where you need to create multiple directory. For example here we are creating multiple directories under “F:\multipledirectory\” folder so we need to navigate to that directory.

So first command we are giving is f: and pressing enter key

f:\

now second command we are giving is ” cd multipledirectory ” and pressing Enter key

cd multipledirectory

Now type “dir” and press enter to check if any existing subdirectories are available or not.

Now to create multiple directory in one command you need to use “md” command by providing directory names like below

md one two three four

multiple directories using command prompt

So if you observe here using command prompt we have created multiple directories only by using single command “md”

Most useful Microsoft Excel shortcuts

Below are daily required shortcuts for Microsoft excel. These shortcuts save lot of time while working.

  1. Ctrl+W: Close a workbook
  2. Ctrl+O: Open a workbook
  3. Alt+H: Go to the Home tab
  4. Ctrl+S: Save a workbook
  5. Ctrl+C: Copy Content
  6. Ctrl+V: Paste Content
  7. Ctrl+Z: Undo action
  8. Delete: Remove cell contents
  9. Alt+H, H: Choose a fill color
  10. Ctrl+X: Cut
  11. Alt+N: Go to Insert tab
  12. Ctrl+B: Bold
  13. Alt+H, A, C: Center align cell contents
  14. Alt+P: Go to Page Layout tab
  15. Alt+A: Go to Data tab
  16. Alt+W: Go to View tab
  17. Shift+F10, or: Open context menu
  18. Context key: Alt+H, B: Add borders
  19. Alt+H, D, C: Delete column
  20. Alt+M: Go to Formula tab
  21. Ctrl+9: Hide the selected rows
  22. Ctrl+0: Hide the selected columns

source: Microsoft

Most Useful shortcuts for chrome in Windows

Below are most useful shortcuts for chrome browser in windows operating system.

  1. Ctrl + n: Open a new window
  2. Ctrl + Shift + n: Open a new window in Incognito mode
  3. Ctrl + t: Open a new tab
  4. Ctrl + Shift + t: Reopen closed tabs
  5. Ctrl + Tab or Ctrl + PgDn: Switch to next open tab
  6. Ctrl + Shift + Tab or Ctrl + PgUp: Jump to the previous open tab
  7. Ctrl + 1 through Ctrl + 8: Swtich to Jumpt to a specific tab
  8. Ctrl + 9: Jump to the rightmost tab
  9. Alt + Home: Open home page in the current tab
  10. Alt + Left arrow: Open the previous page from history in the current tab
  11. Alt + Right arrow: Open the next page from browsing history in the current tab
  12. Ctrl + w or Ctrl + F4: Close the current tab
  13. Ctrl + Shift + w or Alt + F4: Close the current window
  14. Alt + Space then n: Minimize the current window
  15. Alt + Space then x: Maximize the current window
  16. Alt + f then x: Quit Google Chrome

source google