Documentation Source Text

Check-in [ceb449161d]
Login

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

Overview
Comment:Updates to the distinctive features page.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: ceb449161d4c2c8f704770b59c071b6e1e6c8c41
User & Date: drh 2007-12-15 14:44:06
Context
2007-12-16
00:42
Working on global [...]-style hyperlinks. This is an interim check-in in order to transfer from one machine to another. check-in: a1c70893c6 user: drh tags: trunk
2007-12-15
14:44
Updates to the distinctive features page. check-in: ceb449161d user: drh tags: trunk
14:29
Tweaks to the most-widely-deployed page. check-in: e1613cdf0f user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/about.in.

     5      5   <table align="right" border="1" cellpadding="10" hspace="20" cellspacing="0">
     6      6   <tr><td><small>
     7      7   <b>See Also...</b>
     8      8   <p><ul>
     9      9   <li> <a href="features.html">Features</a> </li>
    10     10   <li> <a href="faq.html">Frequently Asked Questions</a> </li>
    11     11   <li> <a href="famous.html">Well-known Users</a> </li>
           12  +<li> <a href="different.html">Distinctive Features</a>
    12     13   <li> <a href="quickstart.html">Getting Started</a> </li>
    13     14   <li> <a href="lang.html">SQL Syntax</a> </li>
    14     15   <li> <a href="c3ref/intro.html">C/C++ Interface Spec</a> </li>
    15     16   <li> <a href="http://www.sqlite.org/cvstrac/timeline">Timeline</a> </li>
    16     17   <li> <a href="http://www.sqlite.org/cvstrac/wiki">Wiki</a> </li>
    17     18   </ul></p>
    18     19   </small></td></tr>

Changes to pages/different.in.

    73     73     files.  Often these files are in a standard location that only the
    74     74     database engine itself can access.  This makes the data more secure,
    75     75     but also makes it harder to access.  Some SQL database engines provide
    76     76     the option of writing directly to disk and bypassing the filesystem
    77     77     all together.  This provides added performance, but at the cost of
    78     78     considerable setup and maintenance complexity.
    79     79   }
           80  +
           81  +feature onefile {Stable Cross-Platform Database File} {
           82  +  The SQLite file format is cross-platform.  A database file written
           83  +  on one machine can be copied to and used on a different machine with
           84  +  a different architecture.  Big-endian or little-endian, 32-bit or
           85  +  64-bit does not matter.  All machines use the same file format.
           86  +  Furthermore, the developers have pledged to keep the file format
           87  +  stable and backwards compatible, so newer versions of SQLite can
           88  +  read and write older database files.
           89  +  <p>
           90  +  Most other SQL database engines require you to dump and restore
           91  +  the database when moving from one platform to another and often
           92  +  when upgrading to a newer version of the software.
           93  +}
    80     94   
    81     95   feature small {Compact} {
    82     96     When optimized for size, the whole SQLite library with everything enabled
    83     97     is less than 225KiB in size (as measured on an ix86 using the "size"
    84     98     utility from the GNU compiler suite.)  Unneeded features can be disabled
    85     99     at compile-time to further reduce the size of the library to under
    86    100     170KiB if desired.