Documentation Source Text

Check-in [c0ac5630f2]
Login

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

Overview
Comment:More edits to the application-file-format document.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: c0ac5630f265ab1ae97dd8035b295f0b6affeebc
User & Date: drh 2014-03-14 22:27:50
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/appfileformat.in.

   188    188   One has merely to link against the SQLite library, or include the 
   189    189   [amalgamation | single "sqlite3.c" source file] with the rest of the
   190    190   application C code, and SQLite will take care of all of the application
   191    191   file I/O.  This can reduce application code size by many thousands of
   192    192   lines, with corresponding saving in development and maintenance costs.
   193    193   
   194    194   <p>SQLite is widely used and stable.  There are literally billions of
   195         -SQLite database files in use daily, on smartphones and in desktop applications.
          195  +SQLite database files in use daily, on smartphones and gadgets
          196  +and in desktop applications.
   196    197   SQLite is [tested | carefully tested] and proven reliable.  It is not
   197    198   a component that needs much tuning or debugging, allowing developers
   198    199   to stay focused on application logic.
   199    200   
   200    201   <li><p><b>Single-File Documents.</b>
   201    202   An SQLite database is contained in a single file, which is easily
   202    203   copied or moved or attached.  The "document" metaphor is preserved.
................................................................................
   251    252   since it allows the document content to be accessed years or decades in the
   252    253   future, long after all traces of the original application have been lost.
   253    254   Data lives longer than code.
   254    255   
   255    256   <li><p><b>Cross-Platform.</b>
   256    257   SQLite database files are portable between 32-bit and 64-bit machines and
   257    258   between big-endian and little-endian architectures and between any of the
   258         -various flavors of windows and unix-like operating systems.
          259  +various flavors of Windows and Unix-like operating systems.
   259    260   The application using an SQLite application file format can store
   260    261   binary numeric data without having to worry about the byte-order of
   261    262   integers or floating point numbers.
   262    263   Text content can be read or written as UTF-8, UTF-16LE, or UTF-16BE and 
   263    264   SQLite will automatically perform any necessary translations on-the-fly.
   264    265   
   265    266   <li><p><b>Atomic Transactions.</b>