Re: [sqlite] SQLite 2013 retrospective

2014-01-02 Thread big stone
Whish list for 2014 = . a simplified implementation of "Common Table Expressions", . amazing SQlite4 performance when in ":memory:". ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 2013 retrospective

2014-01-01 Thread Nico Williams
On Tue, Dec 31, 2013 at 10:37 AM, Richard Hipp wrote: > New tested and supported extensions added to the source tree: > >2. The transitive_closure virtual table: > www.sqlite.org/src/artifact/6360243 Funny you should mention this. I've written transitive closure computations using pure SQL

Re: [sqlite] SQLite 2013 retrospective

2014-01-01 Thread Constantine Yannakopoulos
If I may: On Thu, Jan 2, 2014 at 12:59 AM, Petite Abeille wrote: > Wish list for the new year :)) > > - information schema [1] > - merge statement [2] > - with clause [3][4] > - analytic functions [5][6] > - More informative error messages for FK violations. I consider this the only unworkaround

Re: [sqlite] SQLite 2013 retrospective

2014-01-01 Thread Petite Abeille
On Dec 31, 2013, at 5:37 PM, Richard Hipp wrote: > In addition to the above, there are countless new test cases and minor > feature and performance enhancements. Thank you so much for for all the hard work :) > Our goal is to maintain this aggressive pace of innovation and enhancement > in SQL

Re: [sqlite] SQLite 2013 retrospective

2014-01-01 Thread Niall O'Reilly
At Tue, 31 Dec 2013 11:37:05 -0500, Richard Hipp wrote: > > In addition to the above, there are countless new test cases and minor > feature and performance enhancements. > > Our goal is to maintain this aggressive pace of innovation and enhancement > in SQLite throughout 2014 and beyond.

Re: [sqlite] SQLite 2013 retrospective

2013-12-31 Thread Ryan Finnesey
:37 AM To: General Discussion of SQLite Database Subject: [sqlite] SQLite 2013 retrospective Here is a quick summary of the changes and enhancements to SQLite during 2013. The comparison is between trunk versions, http://www.sqlite.org/src/info/a611c75 versus http://www.sqlite.org/src/info

Re: [sqlite] SQLite 2013 retrospective

2013-12-31 Thread Simon Slavin
On 31 Dec 2013, at 7:36pm, jose isaias cabrera wrote: > It would be nice to know also if you have any major idea(s) for enhancements > for sqlite3 in 2014. You might consider SQLite4 to be major ideas for SQLite3 though as the page says, the

Re: [sqlite] SQLite 2013 retrospective

2013-12-31 Thread jose isaias cabrera
Richard Hipp wrote... Here is a quick summary of the changes and enhancements to SQLite during 2013. The comparison is between trunk versions, [clip] Thanks so much for this info. Our goal is to maintain this aggressive pace of innovation and enhancement in SQLite throughout 2014 and beyon

Re: [sqlite] SQLite 2013 retrospective

2013-12-31 Thread Jan Nijtmans
2013/12/31 Richard Hipp : > Here is a quick summary of the changes and enhancements to SQLite during > 2013. The comparison is between trunk versions, > http://www.sqlite.org/src/info/a611c75 versus > http://www.sqlite.org/src/info/cc72c5aec7 ... > Major new features added in 2013 include: > >

[sqlite] SQLite 2013 retrospective

2013-12-31 Thread Richard Hipp
Here is a quick summary of the changes and enhancements to SQLite during 2013. The comparison is between trunk versions, http://www.sqlite.org/src/info/a611c75 versus http://www.sqlite.org/src/info/cc72c5aec7 The amalgamation source file grew in side from 137619 lines to 145010 lines, or 4868834