967443 - (SQLite3.8.3) Upgrade to SQLite 3.8.3

Status: RESOLVED FIXED

(Toolkit :: Storage, defect)

Description

[NVD]

http://www.sqlite.org/news.html

http://www.sqlite.org/releaselog/3_8_3.html

SQLite version 3.8.3 is a regularly scheduled maintenance release. Upgrading from the previous release is optional.

The most visible change in version 3.8.3 is the addition of support for common table expressions. It is now possible to write a single SELECT statement that will query a tree or graph, using either a depth-first or a breadth-first search. A single SQLite query will even solve Sudoku puzzles or compute the Mandelbrot set. As part of this change, SQLite now accepts a VALUES clause anyplace that a SELECT statement is valid.

This release also includes many small performance enhancements which should give a small speed boost to legacy applications. And there are other minor enhancements such as the addition of the printf() SQL function.

Comment 2

[Marco Bonardo [:mak] (Away Apr 25 - May 5)]

Apart from the performance fixes, that are always nice, the WITH clause and the printf function are quite interesting for our use-cases, I think

Comment 3

[Ryan VanderMeulen [:RyanVM]]

Putting SQLite3.8.3 in parentheses in front of the summary doesn't automagically set the alias. You need to explicitly do it.

Try run (on top of m-c rev 1e9f169c9715 for any perf comparisons):
https://tbpl.mozilla.org/?tree=Try&rev=313144981455

Comment 4

[Ryan VanderMeulen [:RyanVM]]

Attachment: Upgrade to SQLite 3.8.3 - Mozilla changes

Comment 5

[Marco Bonardo [:mak] (Away Apr 25 - May 5)]

Comment on attachment 8371094 [details] [diff] [review]
Upgrade to SQLite 3.8.3 - Mozilla changes

Review of attachment 8371094 [details] [diff] [review]:
-----------------------------------------------------------------

I think we'll have fun with common table expressions and printf

Thanks!

Comment 6

[Ryan VanderMeulen [:RyanVM]]

https://hg.mozilla.org/integration/mozilla-inbound/rev/f33a4a05b6be
https://hg.mozilla.org/integration/mozilla-inbound/rev/8b72cbfcdbfd

Comment 7

[Carsten Book [:Tomcat]]

https://hg.mozilla.org/mozilla-central/rev/f33a4a05b6be
https://hg.mozilla.org/mozilla-central/rev/8b72cbfcdbfd

Comment 8

[Boaz Dodin]

Target Milestone should be mozilla30.

Comment 9

[Marco Bonardo [:mak] (Away Apr 25 - May 5)]

right, someone forgot to update bugzilla to mark mozilla30 as the current nightly