Difference between pages "SQLite" and "SQLite database format"

From ForensicsWiki
(Difference between pages)
Jump to: navigation, search
 
(External Links)
 
Line 1: Line 1:
 
{{expand}}
 
{{expand}}
  
{{Infobox_Software |
+
SQLite databases are used by many programs including several forensics tools, e.g. [[Autopsy]] 3.
  name = SQLite |
+
SQLite 3 is current and older SQLite packages cannot use sqlite3 databases so use sqlite3 tools.
  maintainer = [http://sqlite.org/consortium.html SQLite Consortium] |
+
  os = {{Linux}}, {{Windows}}, {{Mac OS X}} |
+
  genre = [[Database]] |
+
  license = {{Public Domain}} |
+
  website = [http://sqlite.org/ sqlite.org] |
+
}}
+
  
<i>SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.</i> --SQLite project definition
+
= SQLite3 =
  
More details about the software and general use are available from the [http://sqlite.org/ project site].
+
== Write-Ahead Log (WAL) ==
 +
The default method by which SQLite implements atomic commit and rollback is a rollback journal. In version 3.7.0 a "Write-Ahead Log" option was added.
  
== See Also ==
+
== Web Browser Data ==
* [[SQLite database format]]
+
[[Mozilla Firefox]] and [[Google Chrome]] both use SQLite version 3 databases for user data such as history, downloaded files.
  
 
== External Links ==
 
== External Links ==
* [http://sqlite.org/ Project site]
+
* [http://sqlite.org/fileformat2.html The SQLite Database File Format], by the [[SQLite|SQLite project]]
 +
* [http://sqlite.org/wal.html Write-Ahead Logging], by the [[SQLite|SQLite project]]
 +
* [http://linuxsleuthing.blogspot.ch/2013/09/recovering-data-from-deleted-sqlite.html Recovering Data from Deleted SQLite Records: Redux], by [[John Lehr]], September 13, 2013
 +
 
 +
== Tools ==
 +
* [[SQLite]]
 +
* [[SQLite Forensic Reporter]]
 +
 
 +
[[Category:File Formats]]

Revision as of 01:44, 30 October 2013

Information icon.png

Please help to improve this article by expanding it.
Further information might be found on the discussion page.

SQLite databases are used by many programs including several forensics tools, e.g. Autopsy 3. SQLite 3 is current and older SQLite packages cannot use sqlite3 databases so use sqlite3 tools.

SQLite3

Write-Ahead Log (WAL)

The default method by which SQLite implements atomic commit and rollback is a rollback journal. In version 3.7.0 a "Write-Ahead Log" option was added.

Web Browser Data

Mozilla Firefox and Google Chrome both use SQLite version 3 databases for user data such as history, downloaded files.

External Links

Tools