From 18657a960e125336f704ea058e25c27bd3900dcb Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 5 May 2024 19:28:19 +0200 Subject: Adding upstream version 3.40.1. Signed-off-by: Daniel Baumann --- www/formatchng.html | 166 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 166 insertions(+) create mode 100644 www/formatchng.html (limited to 'www/formatchng.html') diff --git a/www/formatchng.html b/www/formatchng.html new file mode 100644 index 0000000..2c9fccb --- /dev/null +++ b/www/formatchng.html @@ -0,0 +1,166 @@ + + + + + +File Format Changes in SQLite + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ + + +

File Format Changes in SQLite

+ +

+The underlying file format for SQLite databases does not +change in incompatible ways. There are literally trillions of +SQLite database files in circulation and the SQLite developers are +committing to supporting those files for decades into the future. +

+ +

+Prior to SQLite version 3.0.0 (2004-06-18), the file format did +sometimes change from one release to the next. But since that time, +the file format has been fully backwards compatible. +

+ +

+By "backwards compatible" we mean that +newer versions of SQLite can always read and write database files created +by older versions of SQLite. +It is often also the case that SQLite is "forwards compatible", that +older versions of SQLite can read and write database files created by +newer versions of SQLite. But there are sometimes forward compatibility +breaks. Sometimes new features are added to the file format. For +example, WAL mode was added in version 3.7.0 (2010-07-21). +SQLite 3.7.0 and later can read and write all database files created +by earlier versions of SQLite. And earlier versions of SQLite can +read and write database files created by SQLite 3.7.0 and later +as long as the database does not use WAL mode. But versions of +SQLite prior to version 3.7.0 cannot read nor write SQLite database files +that make use of WAL mode. +

+ +

Summary

+ + +

This page last modified on 2022-09-13 14:04:46 UTC

+ -- cgit v1.2.3