Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | More edits to the application-file-format document. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
c0ac5630f265ab1ae97dd8035b295f0b |
User & Date: | drh 2014-03-14 22:27:50.258 |
Context
2014-03-15
| ||
12:25 | One more pass, with a few minor corrections, over the application file format document. (check-in: 0dc508ed1b user: drh tags: trunk) | |
2014-03-14
| ||
22:27 | More edits to the application-file-format document. (check-in: c0ac5630f2 user: drh tags: trunk) | |
16:35 | Further tuning of the application file format document. (check-in: 1b422ce8de user: drh tags: trunk) | |
Changes
Changes to pages/appfileformat.in.
︙ | ︙ | |||
188 189 190 191 192 193 194 | One has merely to link against the SQLite library, or include the [amalgamation | single "sqlite3.c" source file] with the rest of the application C code, and SQLite will take care of all of the application file I/O. This can reduce application code size by many thousands of lines, with corresponding saving in development and maintenance costs. <p>SQLite is widely used and stable. There are literally billions of | | > | 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 | One has merely to link against the SQLite library, or include the [amalgamation | single "sqlite3.c" source file] with the rest of the application C code, and SQLite will take care of all of the application file I/O. This can reduce application code size by many thousands of lines, with corresponding saving in development and maintenance costs. <p>SQLite is widely used and stable. There are literally billions of SQLite database files in use daily, on smartphones and gadgets and in desktop applications. SQLite is [tested | carefully tested] and proven reliable. It is not a component that needs much tuning or debugging, allowing developers to stay focused on application logic. <li><p><b>Single-File Documents.</b> An SQLite database is contained in a single file, which is easily copied or moved or attached. The "document" metaphor is preserved. |
︙ | ︙ | |||
251 252 253 254 255 256 257 | since it allows the document content to be accessed years or decades in the future, long after all traces of the original application have been lost. Data lives longer than code. <li><p><b>Cross-Platform.</b> SQLite database files are portable between 32-bit and 64-bit machines and between big-endian and little-endian architectures and between any of the | | | 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 | since it allows the document content to be accessed years or decades in the future, long after all traces of the original application have been lost. Data lives longer than code. <li><p><b>Cross-Platform.</b> SQLite database files are portable between 32-bit and 64-bit machines and between big-endian and little-endian architectures and between any of the various flavors of Windows and Unix-like operating systems. The application using an SQLite application file format can store binary numeric data without having to worry about the byte-order of integers or floating point numbers. Text content can be read or written as UTF-8, UTF-16LE, or UTF-16BE and SQLite will automatically perform any necessary translations on-the-fly. <li><p><b>Atomic Transactions.</b> |
︙ | ︙ |