SQLite
From Just Solve the File Format Problem
(Difference between revisions)
Dan Tobias (Talk | contribs) (There are also files with a .sqlite extension, like Firefox cookies.) |
Dan Tobias (Talk | contribs) |
||
| Line 1: | Line 1: | ||
{{FormatInfo | {{FormatInfo | ||
|subcat=Database | |subcat=Database | ||
| − | |extensions={{ext|db}}, {{ext|sqlite}} | + | |extensions={{ext|db}}, {{ext|sqlite}}, {{ext|db-wal}}, {{ext|sqlite-wal}} |
|mimetypes= | |mimetypes= | ||
{{mimetype|application/x-sqlite3}} | {{mimetype|application/x-sqlite3}} | ||
}} | }} | ||
| + | |||
=Introduction= | =Introduction= | ||
SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. | SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. | ||
| + | |||
| + | =Write-Ahead Logging= | ||
| + | Some versions of SQLite use write-ahead logging to store new changes to the database before they are written to the main database file, allowing a rollback of the current set of changes before they are committed. Database access uses both files to get the latest changed version even if part of it is still in the "WAL" file. This file is a separate file from the main database, using '''-wal''' at the end of the file extension so that it becomes '''.db-wal''' or '''.sqlite-wal'''. | ||
| + | |||
=Resources= | =Resources= | ||
* [http://www.sqlite.org/fileformat.html SQLite.org: The SQLite Database File Format] | * [http://www.sqlite.org/fileformat.html SQLite.org: The SQLite Database File Format] | ||
| + | * [http://www.sqlite.org/draft/wal.html Write-Ahead Logging]] | ||
[[category:File formats with extension .db]] | [[category:File formats with extension .db]] | ||
[[category:SQL]] | [[category:SQL]] | ||
Revision as of 18:01, 1 December 2012
Introduction
SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private.
Write-Ahead Logging
Some versions of SQLite use write-ahead logging to store new changes to the database before they are written to the main database file, allowing a rollback of the current set of changes before they are committed. Database access uses both files to get the latest changed version even if part of it is still in the "WAL" file. This file is a separate file from the main database, using -wal at the end of the file extension so that it becomes .db-wal or .sqlite-wal.
