/********************************************************************* * Author:samson * date:07/09/2014 * Test PL Atform: * 3.11.0.11-generic #19-ubuntu * GNU bash, version 4.2.45 * **************************** ***************************************/
SQLite is an embedded SQL database engine that is OK with just one file. Small and convenient. So is a very good embedded database, in Mozilla Firefox using SQLite as a database.
For example: The file that stores cookies is a SQLite database file, usually exists in the ~/.mozilla/firefox/cojs83dh.default folder, then how to view it?
You can use VIM to open the file and see that the format used is sqlite3. Under GNU Linux, there is a command to view it: Sqlite3, the following is the detailed use of the steps:
0. Use the command to open this database:
$ sqlite3 Cookies.sqlite
Enter the Sqlite3 command line mode;
1. Check the name of the database in this file:
sqlite>. Databases
Seq Name file
--- --------------- ----------------------------------------------------------
0 Main/home/ufo/.mozilla/firefox/cojs83dh.default/cookies.sqlite
2. Then check that the data table already exists in this file:
Sqlite>. Tables
Moz_cookies
You can see that this file contains a table named Moz_cookies.
3. View the field names in this table:
sqlite>. Schema moz_cookies
CREATE TABLE moz_cookies (id integer PRIMARY KEY, Basedomain TEXT, appId integer DEFAULT 0, inbrowserelement integer defau LT 0, Name text, value text, host TEXT, path text, expiry integer, lastaccessed integer, CreationTime integer, issecure in Teger, Ishttponly INTEGER, CONSTRAINT moz_uniqueid UNIQUE (name, host, Path, AppId, inbrowserelement));
CREATE INDEX Moz_basedomain on Moz_cookies (Basedomain, AppId, inbrowserelement);
4. Display the data entry in the table:
sqlite>. Mode Line
The above sentence indicates that the display mode of the output table item is displayed for each field row of the mode.
The following statement outputs a table entry entry similar to the following:
Sqlite> select * from Moz_cookies;
ID = 10
Basedomain = bing.com
AppId = 0
inbrowserelement = 0
Name = Srchuid
Value = v=2&guid=ac1bddf445c84528931cf2960245b9a9
Host = cn.bing.com
Path =/
Expiry = 1466758101
lastaccessed = 1404991858781769
CreationTime = 1403686100491716
Issecure = 0
ishttponly = 0
ID = 11
Basedomain = bing.com
AppId = 0
inbrowserelement = 0
Name = Srchusr
Value = autoredir=0&geovar=&dob=20140624
Host =. Bing.com
Path =/
Expiry = 1466758101
lastaccessed = 1404991858781769
CreationTime = 1403686100493026
Issecure = 0
ishttponly = 0
Refer
Http://sqlite.org/about.html
Sqlite3 command reads the file contents of the Sqlite3 format case
