Skip to main content

Category: SQLite

Help, Information, Examples of SQLite Database

How to Analyse and Improve your time spent on the Internet

program45_-rt8nb

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.

What is SQLite Browser and How to Install it on Windows

program45_-rt8nb

What is SQLite Browser and Where this tool useful

DB Browser for SQLite (DB4S) is an open source, high-quality visual tool for creating, designing, and editing SQLite database files.

DB4S is a database creation, search, and editing tool for users and developers. Complicated SQL commands do not need to be learned because DB4S employs a familiar spreadsheet-like interface.

What are SQLite Browser’s handy controls and wizards?

  • Make database files and compress them.
  • Tables can be created, defined, modified, and deleted.
  • Indexes can be created, defined, and deleted.
  • Records can be viewed, edited, added to, and deleted.
  • Perform a record search.
  • Text records can be imported and exported.
  • Tables can be imported and exported from/to CSV files.
  • Databases can be imported and exported from/to SQL dump files.
  • Execute SQL queries and examine the outcomes
  • Examine a log of all SQL instructions the application has issued.
  • Create simple graphs using data from a table or a query.

How to Install SQLite Browser on Windows Platform?

Open official Website https://sqlitebrowser.org/dl/

Download latest Release for Windows. Here we are downloading release 3.12.2 zip or installer file. DB.Browser.for.SQLite-3.12.2-win64.msi file we are downloading here.

Double click on Downloaded msi file DB.Browser.for.SQLite-3.12.2-win64.msi and Click on next Button.

SQLite Browser Setup First Screen

Accept the license terms by clicking on checkbox and click on next button

License Agreement SQLite Setup

Select DB Browser SQLIte or Cipher to create shortcuts or directly click on next button

Shortcut creation

Select feature or keep default selected and click on Next button

SQLLite Features

Click on Install button and wait for installation to complete

Ready to Install Screen

Once installed type db browser in search if you have created shortcuts while installing. If not then navigate to program files and select folder db browser for sql lite and click on exe DB Browser for SQLite.exe