SQLite - Revision history

Lucidiot: Add Kaitai Struct schema

2024-12-26T17:38:31Z

Add Kaitai Struct schema

2023-12-28T15:11:19Z

Added sample files

2022-10-02T15:24:43Z

2021-11-20T00:49:30Z

2020-03-04T09:48:50Z

Add application/vnd.sqlite3

2020-01-21T23:59:29Z

2018-09-29T11:52:30Z

PRONOM update

2017-06-06T20:09:57Z

2017-05-13T23:44:32Z

add etilqs_ story

2017-05-13T23:38:22Z

Mu moved page DB (SQLite) to SQLite over redirect

@@ Line 4: / Line 4: @@
 |mimetypes={{mimetype|application/vnd.sqlite3}}, {{mimetype|application/x-sqlite3}}
 |pronom={{PRONOM|fmt/729}}, {{PRONOM|fmt/1135}}
 }}
 '''SQLite''' is 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.

@@ Line 33: / Line 33: @@
 * [[SQLite result codes]]
 * For more formats based on SQLite, see [[:Category:SQLite based file formats]].
 ==Resources==

@@ Line 27: / Line 27: @@
 ** of the file.
 </pre>
 ==Resources==

← Older revision		Revision as of 00:49, 20 November 2021
Line 37:		Line 37:
	[[category:SQL]]		[[category:SQL]]
	[[Category:SQLite based file formats\| ]]		[[Category:SQLite based file formats\| ]]
		+	[[Category:File formats with too many extensions]]

@@ Line 2: / Line 2: @@
 |subcat=Databases
 |extensions={{ext|db}}, {{ext|sqlite}}, {{ext|db-wal}}, {{ext|sqlite-wal}}, {{ext|db-shm}}, {{ext|sqlite-shm}}
-|mimetypes={{mimetype|application/x-sqlite3}}
+|mimetypes={{mimetype|application/vnd.sqlite3}}, {{mimetype|application/x-sqlite3}}
 |pronom={{PRONOM|fmt/729}}, {{PRONOM|fmt/1135}}
 }}

← Older revision		Revision as of 23:59, 21 January 2020
Line 36:		Line 36:
	[[category:File formats with extension .db]]		[[category:File formats with extension .db]]
	[[category:SQL]]		[[category:SQL]]
		+	[[Category:SQLite based file formats\| ]]

@@ Line 6: / Line 6: @@
 |pronom={{PRONOM|fmt/729}}
 }}
-==Introduction==
+'''SQLite''' is 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'''. Also, a shared-memory file is often used for a hash-table index of the write-ahead log, with a '''.db-shm''' or '''.sqlite-shm''' extension.
 ==Resources==