SQLite is the most widely used database system in the world. Every installation of Mozilla Firefox uses this database, SQLite is also applicable in mobile phones with the operating systems Android, Windows Phone, iOS, SymbianOS. This database system is pleasantly small and works very quickly. For the Firefox browser, there is an SQ-Lite Manager, with which you can evaluate the data of this database system very comfortably. You can integrate the manager as a free add-on in Firefox.
The search for intimate data begins
From the Firefox menu, choose Extras / Add-ons. Type the term SQLite in the search box. A list of search results appears. Install SQLite Manager from this list. After the installation, you must restart the browser.
What files were downloaded from the Internet?
Only then can you use SQLite Manager. On the Firefox menu, click Tools / SQLite Manager. Select the database of your Firefox application. Enable the places.sqlite database from the Profil database database box. It contains many hidden information.
When did the download take place?
In the left pane (full view), you will now see the individual tables of this database. Click on the table moz_places. In the right pane, click the Browse tab. You see what no one should see. The last visited websites (url) and the frequency of the visits of these pages (visit_count) are immediately noticeable. To explore the structure of the table structure, click the Structure tab in the upper tabs.
Which sites were visited as often?
In this view, you also recognize the individual column names as well as the corresponding data types, in addition to the number of records. Use the Export button to transfer the database to the formats CSV, SQL or XML for further analyzes. The DB Settings tab sets basic settings.
First, you need to locate the databases you want to search on your system. They can be found in the respective subfolders of the users. Each user can have different profiles. You can recognize these folders by an eight-digit combination of numbers and letters with the suffix.default. In XP, the folder is located in drive c: \ Documents and Settings \ username \ Application Data \ Mozilla \ Firefox \ Profiles \.
In Windows Vista and Windows 7, in c: \ Users \ AppData \ Roaming \ Mozilla \ Firefox \ Profiles \. To view the directories, open Windows Explorer, press the [Alt] key, and then click Tools / Folder Options. Select the View tab and remove the checkmark Hide extensions for known file types as well as Hide protected system files and check the Show hidden files, folders and drives option. Click OK.
Windows: The 5 best security tips
To connect the database to the SQLite Manager in Firefox, click Database on the main menu and select Connect to Database. Select downloads.sqlite and click the Open button.
In the left part of the window, click the moz_downloads table. On the Browse tab, you will see all the data downloaded with this profile. To make the columns wider, drag the column width between the column names apart. For quick sorting, click on a column heading. Each time the mouse clicks, the color of the heading changes to
Click the Execute SQL button. Only the selected columns are displayed. By clicking on the Actions button you decide whether you prefer the table view or the view in CSV format. You would also like to know which application the download might include? For this, there is the field preferredApplication.
It is certainly of interest when a download took place. Write the SQL command at
The times are stored in the startTime and endTime fields. This can even be used to calculate the time that the download took. The database stores the times as UTC times (Universal Time Coordinated) in the datetim format. Since the data is stored in UNIX format with an exact timestamp, a division of 1,000,000 is necessary.
View the history of visited pages
The 10 best free security tools
The modifier unixepoch modifies the Unix format and the localtime modifier converts the result to the local time zone. The additions AS field names assign a unique field name to the converted value. It does not matter if you write the instructions large or small. For better readability, however, you should write large SQL commands.
Do you know how often you visited certain pages, such as Facebook or Google? To do this, connect the SQLite manager to the places.sqlite database. The table moz_places contains all the information you need. With the SQL statement you get the desired data
If you want to refine the search for Facebook, add the following
Displayed here with the corresponding URL
Now the number of visits is also to be sorted still descending, with the highest hit rate above. For this, there is the command ORDER BY and the addition ASC for ascending and DESC for descending sorting order
E in another social network, such as Google+, is installed quickly
It is often claimed that you have accidentally landed on a page, which is possible when you click on a link. Or was the address line entered manually? You'll quickly find out. The typed column consists of the values 0 and 1. The 1 means that the Internet address has been entered manually. In SQL
If you want to restrict the query to a web address with certain fields, modify the query
The page was visited only once? When you open the moz_historyvisits table, you will find all the information you need. However, in order to evaluate them meaningfully, you must link this file to the table moz_places. Just so you get the desired data readable to face. It is important to know the common key of these two tables.
In this case, this is the field id from the table moz_places and the field place_id from the table moz_historyvisits. These two tables must be linked via SQL using an INNER JOIN. In order to select the fields uniquely, you always specify the table name in the query, so instead of only url, please moz_places.url
Green = ascending order, red = descending order, black = not sorted
No comments:
Post a Comment