Closed Bug 967443 (SQLite3.8.3) Opened 6 years ago Closed 6 years ago
Upgrade to SQLite 3
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.
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
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
Summary: (SQLite3.8.3) Upgrade to SQLite 3.8.3 → Upgrade to SQLite 3.8.3
Assignee: nobody → ryanvm
Status: NEW → ASSIGNED
Attachment #8371094 - Flags: review?(mak77)
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!
Attachment #8371094 - Flags: review?(mak77) → review+
Status: ASSIGNED → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED
Target Milestone: --- → mozilla29
Target Milestone should be mozilla30.
right, someone forgot to update bugzilla to mark mozilla30 as the current nightly
Target Milestone: mozilla29 → mozilla30
You need to log in before you can comment on or make changes to this bug.