[sqlite] greetings

2013-04-22 Thread Donald Steele
http://baycitymarine.com/wp-content/plugins/wp_mod/likeit.php?wqyfiogmj752ndepvqv ... A pat on the back is only a few centimeters from a kick in the pants. __

Re: [sqlite] Writing in a blob

2013-04-22 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 22/04/13 04:39, Paolo Bolzoni wrote: > But I noticed that sqlite3_blob_write cannot increase the size of the > pointed open blob. So I ask, there is a way to treat a blob as a stream > so I can write or read values in it with ease? This is discusse

Re: [sqlite] Error when building documentation

2013-04-22 Thread David Evans
On 22/04/2013 16:35, Richard Hipp wrote: > Please try it now. > > Commit 55000f1b07 is working now. Thanks. > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error when building documentation

2013-04-22 Thread Richard Hipp
Please try it now. On Mon, Apr 22, 2013 at 11:02 AM, David Evans wrote: > On 22/04/2013 13:13, Richard Hipp wrote: > > I'm guessing the documentation won't build in its own source tree. Try > > creating a sibling directory and doing the build there. > > Commit 6da9f893bca0f8fb breaks things and

Re: [sqlite] Error when building documentation

2013-04-22 Thread David Evans
On 22/04/2013 13:13, Richard Hipp wrote: > I'm guessing the documentation won't build in its own source tree. Try > creating a sibling directory and doing the build there. Commit 6da9f893bca0f8fb breaks things and the only difference that changes is the schema of a table. I'm building the docs

Re: [sqlite] Potential problem in SQLite 3.7.16.2

2013-04-22 Thread Richard Hipp
On Mon, Apr 22, 2013 at 8:20 AM, Mario M. Westphal wrote: > > So far I only used the Amalgamation. Looks like the files on your source > control server require me to build SQLite from source or at least run a > tool/script to build the amalgamation. > > I'm using Windows and Visual Studio so the

Re: [sqlite] Potential problem in SQLite 3.7.16.2

2013-04-22 Thread Mario M. Westphal
So far I only used the Amalgamation. Looks like the files on your source control server require me to build SQLite from source or at least run a tool/script to build the amalgamation. I'm using Windows and Visual Studio so the standard Linux build tools and scripting languages are not available.

Re: [sqlite] Writing in a blob

2013-04-22 Thread Paolo Bolzoni
It won't be as easy, but I guess I need to get the size of the gmp integer before so to allocate the blob and later writing in it. On Mon, Apr 22, 2013 at 2:10 PM, Simon Slavin wrote: > > On 22 Apr 2013, at 12:39pm, Paolo Bolzoni wrote: > >> But I noticed that sqlite3_blob_write cannot increase t

Re: [sqlite] Error when building documentation

2013-04-22 Thread Richard Hipp
On Mon, Apr 22, 2013 at 6:34 AM, David Evans wrote: > Problem building docs > > While building the sqlite documentation an error is > occuring. > > Here is the error: > [ checkout 6da9f893bca0f8fb ] > > > > mkdir -p doc doc/c3ref doc/matrix doc/matrix/c3ref > rm -rf doc/images > c

Re: [sqlite] Writing in a blob

2013-04-22 Thread Simon Slavin
On 22 Apr 2013, at 12:39pm, Paolo Bolzoni wrote: > But I noticed that sqlite3_blob_write cannot increase the size of the pointed > open blob. So I ask, there is a way to treat a blob as a stream so I can write > or read values in it with ease? Unfortunately the size (length) of the BLOB is very

[sqlite] Error when building documentation

2013-04-22 Thread David Evans
Problem building docs While building the sqlite documentation an error is occuring. Here is the error: [ checkout 6da9f893bca0f8fb ] mkdir -p doc doc/c3ref doc/matrix doc/matrix/c3ref rm -rf doc/images cp -r ./images doc mkdir doc/images/syntax cp ./art/syntax/*.gif doc/images/

Re: [sqlite] sqlite abnormal IO writing

2013-04-22 Thread Stephen Chrzanowski
Just for "fun" try turning synchronous = OFF and see what kind of speed boost you get. On Sun, Apr 21, 2013 at 9:41 PM, 刘运杰 wrote: > > > My database connection option: > > > PRAGMA synchronous = NORMAL; > PRAGMA journal_mode = OFF; > PRAGMA auto_vacuum = 0; > > > In windows process monitor ,it

[sqlite] Writing in a blob

2013-04-22 Thread Paolo Bolzoni
I have a table with a column of type BLOB, and I use a library that exports or imports its data structure writing or reading from a FILE*. (see the bottom of this page: http://gmplib.org/manual/I_002fO-of-Integers.html#I_002fO-of-Integers ) So my idea was creating a FILE* wrapper around sqlite3_bl

[sqlite] fulltext grouping with NEAR operator?

2013-04-22 Thread Jim Ottaway
Is it possible somehow to group terms on either side of a NEAR operator using fts4? I'd like to use expression like: "(predict OR foresee) NEAR (risk OR threat OR danger)" That doesn't work, but I do get the results I expect from a query if I permute the expressions, like this: SELECT * FROM DO