Re: [sqlite] SQLite4 (don't scream)

2012-06-30 Thread Stephan Beal
On Fri, Jun 29, 2012 at 8:33 PM, Jim Morris wrote: > Are there significant improvements in speed for existing SQL? > In my _simple_ tests (which run _almost_ the same ops through mysql5, sqlite3, and now sqlite4), i'm seeing _huge_ boosts in speed in v4 (25x over v3!) BUT: a) this is not necess

Re: [sqlite] SQLite4 (don't scream)

2012-06-30 Thread Jim Morris
Are there significant improvements in speed for existing SQL? How does the compiled size compare with SQLite3? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite4 (don't scream)

2012-06-29 Thread Petite Abeille
On Jun 28, 2012, at 5:57 PM, Simon Slavin wrote: > "SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is not > going away." Argh… but more seriously… would that new incarnation provide proper error messages for constraint violations? Providing a proper data dictionary w

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Richard Hipp
On Thu, Jun 28, 2012 at 4:09 PM, Alexey Pechnikov wrote: > Will be covering indices on views available as replacement of materialized > views? > No. I don't know how to do that. > > 2012/6/28 Simon Slavin > > > First, the important bit: > > > > "SQLite4 is an alternative, not a replacement, f

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Alexey Pechnikov
Will be covering indices on views available as replacement of materialized views? 2012/6/28 Simon Slavin > First, the important bit: > > "SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is not > going away." > > Now the URL: > >

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Simon Slavin
On 28 Jun 2012, at 6:04pm, Roger Binns wrote: > http://news.ycombinator.com/item?id=4168645 LOL. Those Hacker News guys are hardcore. Make some of my mailing lists look almost civil. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org htt

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Stephan Beal
On Thu, Jun 28, 2012 at 7:09 PM, E. Timothy Uy wrote: > That's kind of cool, but how about $twentyseven! > $c1...$c27 (c==column)? -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqli

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread E. Timothy Uy
That's kind of cool, but how about $twentyseven! > On Thu, Jun 28, 2012 at 12:57 PM, Robert Myers > wrote: > > > Aghhh (just kidding) > > > > One request for a change - make bind and column start with the same > index. > > I always have to look up which one is zero based and which one is

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Richard Hipp
On Thu, Jun 28, 2012 at 12:57 PM, Robert Myers wrote: > Aghhh (just kidding) > > One request for a change - make bind and column start with the same index. > I always have to look up which one is zero based and which one is one based. > Right now, porting an app from SQLite3 to SQLite4 i

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/06/12 08:57, Simon Slavin wrote: > Just thought some people might enjoy reading and thinking about it. There has also been discussion on Hacker News and Reddit: http://news.ycombinator.com/item?id=4168645 http://www.reddit.com/r/programming/

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Ryan Johnson
On 28/06/2012 12:30 PM, Cory Nelson wrote: On Thu, Jun 28, 2012 at 11:20 AM, Stephan Beal wrote: On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin wrote: Now the URL: Just thought some people might enjoy reading and thinking about it. FW

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/06/12 09:20, Stephan Beal wrote: > size_t does not have a specified size and causes all sorts of grief in > porting i/o-based APIs between 32/64 bits, I have been one of the people complaining loudest about not using types like size_t. However

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Stephan Beal
On Thu, Jun 28, 2012 at 6:57 PM, Robert Myers wrote: > One request for a change - make bind and column start with the same index. > I always have to look up which one is zero based and which one is one based. > That particular convention comes not from sqlite3, but from SQL. i have no idea why,

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Robert Myers
Aghhh (just kidding) One request for a change - make bind and column start with the same index. I always have to look up which one is zero based and which one is one based. Rob On 6/28/2012 10:57 AM, Simon Slavin wrote: First, the important bit: "SQLite4 is an alternative, not a re

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Stephan Beal
On Thu, Jun 28, 2012 at 6:52 PM, Stephan Beal wrote: > fully specialized). _Which_ fixed-size int type it collides with is > platform-dependent and leads to convoluted workarounds like this: > > > http://code.google.com/p/v8-juice/source/browse/convert/include/cvv8/detail/convert_core.hpp#1207 >

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Stephan Beal
On Thu, Jun 28, 2012 at 6:46 PM, Stephan Beal wrote: > 64-bits. size_t has at least the following drawbacks compared to using a > fixed-size integer type: > - In C++ size_t is often problematic in template specializations because in invariably collides with one of the other integer types (which

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Stephan Beal
On Thu, Jun 28, 2012 at 6:30 PM, Cory Nelson wrote: > Probably not an issue -- I'm not sure how a public API would need inttypes > anyway. Also, perhaps you are seeing size_t be misused. A blanket "please > don't use" is nonsense. > Hi, Cory! That's what i thought to until i started porting my

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Richard Hipp
On Thu, Jun 28, 2012 at 12:20 PM, Stephan Beal wrote: > On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin > wrote: > > > Now the URL: > > > > > > > > Just thought some people might enjoy reading and thinking about it. > > > > FWIW, my 0.02 Euros

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Cory Nelson
On Thu, Jun 28, 2012 at 11:20 AM, Stephan Beal wrote: > On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin > wrote: > > > Now the URL: > > > > > > > > Just thought some people might enjoy reading and thinking about it. > > > > FWIW, my 0.02 Euros

Re: [sqlite] SQLite4 (don't scream)

2012-06-28 Thread Stephan Beal
On Thu, Jun 28, 2012 at 5:57 PM, Simon Slavin wrote: > Now the URL: > > > > Just thought some people might enjoy reading and thinking about it. > FWIW, my 0.02 Euros regarding this line: "SQLite4 makes use of standard data types such as siz

[sqlite] SQLite4 (don't scream)

2012-06-28 Thread Simon Slavin
First, the important bit: "SQLite4 is an alternative, not a replacement, for SQLite3. SQLite3 is not going away." Now the URL: Just thought some people might enjoy reading and thinking about it. Simon.