Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typo. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | branch-3.32 |
| Files: | files | file ages | folders |
| SHA3-256: |
4bcbd4ac5ead8fada967d04feb56152f |
| User & Date: | drh 2020-06-19 16:19:14 |
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
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
|