Documentation Source Text

Check-in [818a7ac30c]
Login

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

Overview
Comment:Improvements to the homepage.
Timelines: family | ancestors | descendants | both | branch-3.26
Files: files | file ages | folders
SHA3-256: 818a7ac30c8acea3580cd6dc955b8a0fb51f1a6fadf642d11cd21d0a8776a000
User & Date: drh 2018-12-10 12:09:51
Context
2018-12-15
01:17
Merge defense-against-dark-arts fixes from trunk. check-in: a8707b40a7 user: drh tags: branch-3.26
2018-12-10
12:09
Improvements to the homepage. check-in: 818a7ac30c user: drh tags: branch-3.26
12:08
Improvements to the homepage. check-in: 893d161a74 user: drh tags: trunk
00:54
Fix the "Latest Release" on the front page. check-in: 2b5acd3ccf user: drh tags: branch-3.26
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/fullsql.in.

    25     25   <li>[Subqueries], including [correlated subqueries]
    26     26   <li>Up to 64-way joins
    27     27   <li>LEFT JOIN
    28     28   <li>DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET
    29     29   <li>UNION, UNION ALL, INTERSECT, and EXCEPT
    30     30   <li>A rich library of [Core Functions|standard SQL functions]
    31     31   <li>[Aggregate Functions|Aggregate functions] including DISTINCT aggregates
           32  +<li>[window functions|Window functions]
    32     33   <li>[UPDATE], [DELETE], and [INSERT] (of course)
    33     34   <li>[WITH|Common table expressions] including
    34     35       [recursive common table expressions]
    35     36   <li>[row value|Row values]
           37  +<li>[UPSERT]
    36     38   <li>An advanced [query planner]
    37     39   <li>[FTS5|Full-text search]
    38     40   <li>[R-Trees|R-tree indexes]
    39     41   <li>[json1|JSON support]
    40     42   <li>The [IS operator]
    41     43   <li>[table-valued function|Table-valued functions]
    42     44   <li>[REPLACE|REPLACE INTO]

Changes to pages/index.in.

     1      1   <title>SQLite Home Page</title>
     2      2   
     3         -<p>SQLite is a [self-contained], [high-reliability], 
     4         -[serverless|embedded],
     5         -[full-featured SQL|full-featured], [public-domain],
            3  +<h3>What Is SQLite?</h3>
            4  +
            5  +<p>SQLite is a C-language library that implements a
            6  +[footprint|small],
            7  +[faster than the filesystem|fast],
            8  +[self-contained], 
            9  +[high-reliability],
           10  +[full-featured SQL|full-featured],
     6     11   SQL database engine.
     7     12   SQLite is the [most used] database engine in the world.
     8         -<a class="button" href="about.html">More Info</a></p>
           13  +It is built into all mobile phones and most computers and
           14  +comes bundled inside countless other applications that people
           15  +use every day.
           16  +<a href="about.html">More Information...</a>
           17  +
           18  +<p>
           19  +SQLite [https://sqlite.org/src|source code]
           20  +is in the [public-domain] and is free to 
           21  +everyone to use for any purpose.
     9     22   
    10         -<hr class="xhr">
    11         -<span class="hdrfont">Latest Release:&nbsp;&nbsp;</span>
           23  +<h3>Latest Release</h3>
    12     24   <a href="releaselog/3_26_0.html">Version 3.26.0</a> ([dateof:3.26.0]).
    13     25   <a class="button" href="download.html">Download</a>
    14     26   <a class="button" href="chronology.html">Prior Releases</a>
    15     27   
    16         -<hr class="xhr">
    17     28   <h3>Common Links</h3>
    18     29   <tcl>common_links</tcl>