Documentation Source Text

Check-in [e6aa1d2d9a]
Login

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

Overview
Comment:Futher homepage enhancements. Improvements and typo fixes on secondary pages.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:e6aa1d2d9aeb39403934e2e2d3b5c102306b553270ed8b08163bb2503e7d160a
User & Date: drh 2018-12-10 12:52:29
Context
2018-12-14
15:54
Rename the "security.html" document as "Defense Against Dark Arts". Add the additional recommendation to avoid memory-mapped I/O on untrusted database files. check-in: 11d0259504 user: drh tags: trunk
2018-12-10
12:52
Futher homepage enhancements. Improvements and typo fixes on secondary pages. check-in: e6aa1d2d9a user: drh tags: trunk
12:34
Further tweaks to the homepage. check-in: dd073d8325 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

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>