Documentation Source Text

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

Changes to pages/features.in.

     7      7       are atomic, consistent, isolated, and durable (ACID)
     8      8       even after system crashes and power failures.</li>
     9      9   <li><a href="zeroconf.html">Zero-configuration</a>
    10     10        - no setup or administration needed.</li>
    11     11   <li>[Full-featured SQL] implementation
    12     12       with advanced capabilities like [partial indexes],
    13     13       [indexes on expressions], [json1|JSON],
    14         -    and [common table expressions].
           14  +    [common table expressions], and [window functions].
    15     15       (<a href="omitted.html">Omitted features</a>)</li>
    16     16   <li>A complete database is stored in a 
    17     17       <a href="onefile.html">single cross-platform disk file</a>.
    18     18       Great for use as an [application file format].</li>
    19     19   <li>Supports terabyte-sized databases and gigabyte-sized strings
    20     20       and blobs.  (See <a href="limits.html">limits.html</a>.)
    21     21   <li>Small code [footprint]: 

Changes to pages/index.in.

    18     18   <p>
    19     19   The SQLite [file format] is stable, cross-platform, and
    20     20   backwards compatible and the developers pledge to keep it
    21     21   that way through at least the year 2050.  SQLite database
    22     22   files are commonly uses as a container to transfer rich 
    23     23   content between systems
    24     24   [affshort|&#91;1&#93;]
    25         -[appformat|&#91;2&#93;]
           25  +[SQLAR|&#91;2&#93;]
           26  +[appformat|&#91;3&#93;]
    26     27   and as a long-term archival format 
    27     28   for data
    28         -[recommended storage format|&#91;3&#93;].
           29  +[recommended storage format|&#91;4&#93;].
    29     30   There are over 1 trillion SQLite databases in active use.
    30     31   
    31     32   <p>
    32     33   SQLite [https://sqlite.org/src|source code]
    33     34   is in the [public-domain] and is free to 
    34     35   everyone to use for any purpose.
    35     36   

Changes to pages/whynotgit.in.

    58     58   
    59     59   <p>
    60     60   Git allows you to go backwards in time easily.  Given the latest
    61     61   check-in on a branch, Git lets you see all the ancestors of that
    62     62   check-in.  But Git makes it difficult to move in the other
    63     63   direction.  Given some historical check-in, it is quite challenging
    64     64   in Git to find out what came next.  It can be done, but it is sufficiently
    65         -difficult and people rarely do it.  Common interfaces for Git,
           65  +difficult that people rarely do it.  Common interfaces for Git,
    66     66   such as GitHub, do not support the ability.
    67     67   
    68     68   <p>It is not impossible to find the descendents of a check-in
    69     69   in Git.  It is merely difficult.  For example,
    70     70   there is a 
    71     71   [https://stackoverflow.com/questions/27960605/find-all-the-direct-descendants-of-a-given-commit#27962018|stackoverflow page]
    72     72   showing the command sequence for finding the descendents of a check-in
................................................................................
   183    183   but that introduces another third-party dependency and a
   184    184   centralized service, which mitigate the key advantage of Git
   185    185   which is that it is "distributed".  There are various free
   186    186   alternatives to GitHub, such as GitLab, but those too have
   187    187   a lot of dependencies and require a lot of server setup.
   188    188   
   189    189   <p>
   190         -In contrast, Fossil is a single standalone binary which one
   191         -installs by placing it to $PATH.  That one binary contains all
          190  +In contrast, Fossil is a single standalone binary which is
          191  +installed by putting it on $PATH.  That one binary contains all
   192    192   the functionality of core Git and also GitHub and/or GitLab.  It
   193         -manages a community server with wiki and bug tracking, provides
   194         -packaged downloads for consumers, login managements, and so forth,
   195         -with no extra software required.
          193  +manages a community server with wiki, bug tracking, and forums, 
          194  +provides packaged downloads for consumers, login managements, 
          195  +and so forth, with no extra software required.
   196    196   
   197    197   <p>
   198    198   Less administration means that programmers spend more time working
   199    199   on the software (SQLite in this case) and less time fussing with
   200    200   the version control system.
   201    201   
   202    202   <h2>Git provides a poor user experience</h2>