Documentation Source Text

Check-in [893d161a74]
Login

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

Overview
Comment:Improvements to the homepage.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:893d161a74c9ee2c4bd6b52e02a5fe2c6e7001956d932933d1da542467109148
User & Date: drh 2018-12-10 12:08:42
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

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






3
4
5
6
7



8
9
10





11
12
13
14
15
16
17
18
<title>SQLite Home Page</title>







<p>SQLite is a [self-contained], [high-reliability], 
[serverless|embedded],
[full-featured SQL|full-featured], [public-domain],
SQL database engine.
SQLite is the [most used] database engine in the world.



<a class="button" href="about.html">More Info</a></p>

<hr class="xhr">





<span class="hdrfont">Latest Release:&nbsp;&nbsp;</span>
<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>

<hr class="xhr">
<h3>Common Links</h3>
<tcl>common_links</tcl>


>
>
>
>
>
>
|
<
|


>
>
>
|

<
>
>
>
>
>
|




<


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>