Documentation Source Text

Check-in [4bcbd4ac5e]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix typo.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | branch-3.32
Files: files | file ages | folders
SHA3-256: 4bcbd4ac5ead8fada967d04feb56152f1155130acef6631c9b2925c89cb500b1
User & Date: drh 2020-06-19 16:19:14.404
Context
2020-06-29
01:26
Update the CVE list. (check-in: 7565236dfd user: drh tags: branch-3.32)
2020-06-19
16:19
Fix typo. (check-in: 4bcbd4ac5e user: drh tags: branch-3.32)
2020-06-18
19:12
Improved hyperlink to the change graph for 3.32.3. (check-in: a7e284e0ea user: drh tags: branch-3.32)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/lang_altertable.in.
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
enhancements to the internal schema representation.  Changing the
internal schema representation would be much more difficult if the
schema representation was exposed in the database file.  So, in other
words, storing the schema as text helps maintain backwards 
compatibility, and helps ensure that older database files can be
read and written by newer versions of SQLite.

<p>Storing the schema a text also makes the 
[SQLite database file format] easier to define, document, and 
understand. This helps make SQLite database files a
[recommended storage format] for long-term archiving of data.

<p>The downside of storing schema a text is that it can make
the schema tricky to modify.  And for that reason, the ALTER TABLE
support in SQLite has traditionally lagged behind other SQL







|







318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
enhancements to the internal schema representation.  Changing the
internal schema representation would be much more difficult if the
schema representation was exposed in the database file.  So, in other
words, storing the schema as text helps maintain backwards 
compatibility, and helps ensure that older database files can be
read and written by newer versions of SQLite.

<p>Storing the schema as text also makes the 
[SQLite database file format] easier to define, document, and 
understand. This helps make SQLite database files a
[recommended storage format] for long-term archiving of data.

<p>The downside of storing schema a text is that it can make
the schema tricky to modify.  And for that reason, the ALTER TABLE
support in SQLite has traditionally lagged behind other SQL