Debian Codegraph @

www/formatchng.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="sqlite.css" rel="stylesheet">
6 <title>File Format Changes in SQLite</title>
7 <!-- path= -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="index.html">
12 <img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='about.html'>About</a>
23 <li class='desktoponly'><a href="docs.html">Documentation</a>
24 <li class='desktoponly'><a href="download.html">Download</a>
25 <li class='wideonly'><a href='copyright.html'>License</a>
26 <li class='desktoponly'><a href="support.html">Support</a>
27 <li class='desktoponly'><a href="prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='about.html'>About</a>
35 <li><a href='docs.html'>Documentation</a>
36 <li><a href='download.html'>Download</a>
37 <li><a href='support.html'>Support</a>
38 <li><a href='prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118
119
120 <h2>File Format Changes in SQLite</h2>
121
122 <p>
123 The <a href="fileformat2.html">underlying file format</a> for SQLite databases does not
124 change in incompatible ways. There are literally trillions of
125 SQLite database files in circulation and the SQLite developers are
126 committing to supporting those files for decades into the future.
127 </p>
128
129 <p>
130 Prior to SQLite version 3.0.0 (2004-06-18), the file format did
131 sometimes change from one release to the next. But since that time,
132 the file format has been fully backwards compatible.
133 </p>
134
135 <p>
136 By "backwards compatible" we mean that
137 newer versions of SQLite can always read and write database files created
138 by older versions of SQLite.
139 It is often also the case that SQLite is "forwards compatible", that
140 older versions of SQLite can read and write database files created by
141 newer versions of SQLite. But there are sometimes forward compatibility
142 breaks. Sometimes new features are added to the file format. For
143 example, <a href="wal.html">WAL mode</a> was added in version 3.7.0 (2010-07-21).
144 SQLite 3.7.0 and later can read and write all database files created
145 by earlier versions of SQLite. And earlier versions of SQLite can
146 read and write database files created by SQLite 3.7.0 and later
147 <i>as long as the database does not use WAL mode</i>. But versions of
148 SQLite prior to version 3.7.0 cannot read nor write SQLite database files
149 that make use of WAL mode.
150 </p>
151
152 <h2>Summary</h2>
153
154 <ul>
155 <li><p>
156 Newer versions of SQLite can always read and/or write database files
157 created by older versions of SQLite, back to version 3.0.0 (2004-06-18).
158
159 <li><p>
160 Older versions of SQLite back to version 3.0.0 can read and write
161 database files created by newer versions of SQLite as long as the
162 database does not make use of newer features that are unknown to that
163 older version.
164 </ul>
165 <p align="center"><small><i>This page was last updated on 2022-09-13 14:04:46Z </small></i></p>
166