Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Improvements to the homepage. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
893d161a74c9ee2c4bd6b52e02a5fe2c |
| User & Date: | drh 2018-12-10 12:08:42.889 |
Context
|
2018-12-10
| ||
| 12:34 | Further tweaks to the homepage. (check-in: dd073d8325 user: drh tags: trunk) | |
| 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) | |
| 11:48 | Update the change log. (check-in: 22f1dff034 user: drh tags: trunk) | |
Changes
Changes to pages/fullsql.in.
| ︙ | ︙ | |||
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
<li>[Subqueries], including [correlated subqueries]
<li>Up to 64-way joins
<li>LEFT JOIN
<li>DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET
<li>UNION, UNION ALL, INTERSECT, and EXCEPT
<li>A rich library of [Core Functions|standard SQL functions]
<li>[Aggregate Functions|Aggregate functions] including DISTINCT aggregates
<li>[UPDATE], [DELETE], and [INSERT] (of course)
<li>[WITH|Common table expressions] including
[recursive common table expressions]
<li>[row value|Row values]
<li>An advanced [query planner]
<li>[FTS5|Full-text search]
<li>[R-Trees|R-tree indexes]
<li>[json1|JSON support]
<li>The [IS operator]
<li>[table-valued function|Table-valued functions]
<li>[REPLACE|REPLACE INTO]
| > > | 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
<li>[Subqueries], including [correlated subqueries]
<li>Up to 64-way joins
<li>LEFT JOIN
<li>DISTINCT, ORDER BY, GROUP BY, HAVING, LIMIT, and OFFSET
<li>UNION, UNION ALL, INTERSECT, and EXCEPT
<li>A rich library of [Core Functions|standard SQL functions]
<li>[Aggregate Functions|Aggregate functions] including DISTINCT aggregates
<li>[window functions|Window functions]
<li>[UPDATE], [DELETE], and [INSERT] (of course)
<li>[WITH|Common table expressions] including
[recursive common table expressions]
<li>[row value|Row values]
<li>[UPSERT]
<li>An advanced [query planner]
<li>[FTS5|Full-text search]
<li>[R-Trees|R-tree indexes]
<li>[json1|JSON support]
<li>The [IS operator]
<li>[table-valued function|Table-valued functions]
<li>[REPLACE|REPLACE INTO]
|
| ︙ | ︙ |
Changes to pages/index.in.
1 2 | <title>SQLite Home Page</title> | > > > > > > | < | > > > | > > > > | | < | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | <title>SQLite Home Page</title> <h3>What Is SQLite?</h3> <p>SQLite is a C-language library that implements a [footprint|small], [faster than the filesystem|fast], [self-contained], [high-reliability], [full-featured SQL|full-featured], SQL database engine. SQLite is the [most used] database engine in the world. It is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day. <a href="about.html">More Information...</a> <p> SQLite [https://sqlite.org/src|source code] is in the [public-domain] and is free to everyone to use for any purpose. <h3>Latest Release</h3> <a href="releaselog/3_27_0.html">Version 3.27.0</a> ([dateof:3.27.0]). <a class="button" href="download.html">Download</a> <a class="button" href="chronology.html">Prior Releases</a> <h3>Common Links</h3> <tcl>common_links</tcl> |