Re: [sqlite] SQLite version 3.7.5

2011-02-15 Thread Sylvain Pointeau
Any news on System.Data.SQLite.org ? It was a so great news! When are the releases planned? Best regards, Sylvain ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.7.5

2011-02-02 Thread Michael Knigge
> As of this release, the popular ADO.NET provider for SQLite by Robert > Simpson, System.Data.SQLite, is hosted on the SQLite website. See > http://System.Data.SQLite.org/ for additional information. Release builds > of System.Data.SQLite will appears on the SQLite download page over the >

Re: [sqlite] SQLite version 3.7.5

2011-02-01 Thread Petite Abeille
On Feb 1, 2011, at 2:32 AM, Richard Hipp wrote: > performance is improved over the previous release by 1% or 2%. Hmmm... under 3.7.3, a little process of mine was handling around 52M records (~3GB) in about 113 minutes... now, with 3.7.5, the same process, running on the same machine, under

Re: [sqlite] SQLite version 3.7.5

2011-02-01 Thread Clark Christensen
- Original Message From: Richard Hipp <d...@sqlite.org> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>; sqlite-annou...@sqlite.org Sent: Mon, January 31, 2011 5:32:15 PM Subject: [sqlite] SQLite version 3.7.5 >As of this release, the popular A

[sqlite] SQLite version 3.7.5

2011-01-31 Thread Richard Hipp
SQLite version 3.7.5 is now available on the SQLite website http://www.sqlite.org/ Version 3.7.5 is a regularly scheduled bi-monthly release. However, upgrading is recommended due to an obscure bug fix that can under contrived conditions result in a corrupt database. See

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-26 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > A far better solution ... would be to bump > the VFS version number to 3 That is the only solution that will not break any existing code from anyone. ie you have to use VFS 3 to opt in to getting SYNC_OMITTED (probably best delivered to

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-26 Thread Richard Hipp
On Wed, Jan 26, 2011 at 12:20 AM, Roger Binns wrote: > - > A far better solution ... would be to bump > the VFS version number to 3 Suppose we rig the default VFSes so that they return SQLITE_OK for SQLITE_FCNTL_SYNC_OMITTED, instead of SQLITE_ERROR, so that your

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-25 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/25/2011 08:56 AM, Richard Hipp wrote: >> Thanks for the helpful feedback. Please let us know if you find this >> solution inadequate or if you encounter other problems. A far better solution to this kind of thing is to do them the other way

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-25 Thread Richard Hipp
On Tue, Jan 25, 2011 at 11:31 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > The issues I have with this file control are: > > - - It is documented as "internal" but my code sees it hence it is now part > of > the external interface of SQLite > You are

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-25 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/24/2011 09:27 PM, Dan Kennedy wrote: > Does the aspw xFileControl method modify the value of the output > parameter in this case? No. > The idea was that existing VFS implementations would return SQLITE_ERROR > since they do not recognize

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Dan Kennedy
On 01/25/2011 12:20 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 01/24/2011 06:05 PM, Roger Binns wrote: >> I'm finding custom VFS code is no longer working at all. > > The cause is a new xFileControl operation SQLITE_FCNTL_SYNC which appears to > needlessly

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/24/2011 06:05 PM, Roger Binns wrote: > I'm finding custom VFS code is no longer working at all. The cause is a new xFileControl operation SQLITE_FCNTL_SYNC which appears to needlessly duplicate the existing xSync method. Additionally unlike

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Dan Kennedy
On 01/25/2011 04:10 AM, Black, Michael (IS) wrote: > Is this if statement meant to be constant? Or should it be comparing the > requested encoding instead of SQLITE_UTF16NATIVE? > > SQLITE_PRIVATE int sqlite3Utf16ByteLen(const void *zIn, int nChar){ >int c; >unsigned char const *z = zIn;

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/24/2011 10:12 AM, Richard Hipp wrote: > Unless serious problems I'm finding custom VFS code is no longer working at all. Mine "inherits" from an existing one overriding or calling the original methods as appropriate. My code for this is

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Richard Hipp
; Northrop Grumman Information Systems > Advanced Analytics Directorate > > > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Richard Hipp [d...@sqlite.org] > Sent: Monday, January 24, 2011 12:1

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Black, Michael (IS)
Around line 59981 sqlite3StrAccumAppend(, zStart, zRawSql-zStart); The zRawSql-zStart is a 64-bit value (on a 64-bit machine) but gets down-converted to int. Seems a little more error checking is appropriate to ensure this doesn't exceed an int. Would be an awfully long SQL string but

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Black, Michael (IS)
SQLITE_PRIVATE int sqlite3Utf16ByteLen(const void *zIn, int nChar){ int c; should be unsigned int c; Otherwise I don't think the macros work right (they become constant expression warnings). Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Black, Michael (IS)
Is this if statement meant to be constant? Or should it be comparing the requested encoding instead of SQLITE_UTF16NATIVE? SQLITE_PRIVATE int sqlite3Utf16ByteLen(const void *zIn, int nChar){ int c; unsigned char const *z = zIn; int n = 0; if( SQLITE_UTF16NATIVE==SQLITE_UTF16BE ){

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Black, Michael (IS)
atabase Subject: EXTERNAL:[sqlite] SQLite version 3.7.5 - code freeze The current plan is to release SQLite version 3.7.5 on Wednesday of next week 2011-02-02. Please see draft release notes here: http://www.sqlite.org/draft/releaselog/3_7_5.html You can download a snapshot of the latest SQLi

Re: [sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Marian Cascaval
...". Marian Cascaval From: Richard Hipp <d...@sqlite.org> To: sqlite-...@sqlite.org; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Mon, January 24, 2011 8:12:44 PM Subject: [sqlite] SQLite version 3.7.5 - code freeze The current plan is to release

[sqlite] SQLite version 3.7.5 - code freeze

2011-01-24 Thread Richard Hipp
The current plan is to release SQLite version 3.7.5 on Wednesday of next week 2011-02-02. Please see draft release notes here: http://www.sqlite.org/draft/releaselog/3_7_5.html You can download a snapshot of the latest SQLite amalgamation from here: