Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add news for the 3.25.0 release. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: | 884ea7b3ed16eb30c25e49b9eceb5f2e |
| User & Date: | drh 2018-09-14 16:54:24 |
Context
|
2018-09-14
| ||
| 17:42 | Fix minor typos detected by the spell checker. check-in: c68e153fc6 user: drh tags: trunk | |
| 16:54 | Add news for the 3.25.0 release. check-in: 884ea7b3ed user: drh tags: trunk | |
| 16:34 | The application_id is a signed integer. check-in: 3580ba4b5b user: drh tags: trunk | |
Changes
Changes to pages/news.in.
14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
hd_puts "<h3>$date - $title</h3>"
regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
regsub -all {[Tt]icket #(\d+)} $txt \
{<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
hd_resolve "<blockquote>$txt</blockquote>"
hd_puts "<hr width=\"50%\">"
}
newsitem {2018-06-04} {Release 3.24.0} {
SQLite [version 3.24.0] is a regularly scheduled maintenance release.
Highlights of this release include support for PostgreSQL-style
UPSERT and improved performance, especially for ORDER BY LIMIT queries.
}
|
> > > > > > > > > > > > > > > > > > > > > > > > > > |
14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
hd_puts "<h3>$date - $title</h3>"
regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
regsub -all {[Tt]icket #(\d+)} $txt \
{<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
hd_resolve "<blockquote>$txt</blockquote>"
hd_puts "<hr width=\"50%\">"
}
newsitem {2018-09-15} {Release 3.25.0} {
SQLite [version 3.25.0] is a regularly scheduled maintenance release.
Two big enhancements in this release:
<ol>
<li><p>
Support for [window functions] was added, using the PostgreSQL documentation
as the baseline.
<li><p>
The [ALTER TABLE] command was enhanced to support renaming of columns, and
so that column and table renames are propagated into trigger bodies and views.
</ol>
<p>In addition, there are various performance enhancements and minor fixes.
<p>One bug of note is
[https://www.sqlite.org/src/info/9936b2fa443fec03ff25|ticket 9936b2fa443fec]
which describes a hard-to-reach condition where the ORDER BY LIMIT
optimization might cause an infinite loop during query evaluation.
This ticket raised a lot of
concern on HackerNews and Reddit, probably due to my choice of the ticket
title. "Infinite Loop" sounds scary. But I argue that the bug isn't really
all that bad in that it is very difficult to reach, will show up during
testing (rather than magically appearing after a product is
deployed), does not cause any data loss, and does not return an
incorrect result. It was an important error, but not nearly as dire
as many people interpreted it to be. And, in any event, it is fixed now.
}
newsitem {2018-06-04} {Release 3.24.0} {
SQLite [version 3.24.0] is a regularly scheduled maintenance release.
Highlights of this release include support for PostgreSQL-style
UPSERT and improved performance, especially for ORDER BY LIMIT queries.
}
|