[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

[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

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, 刘运杰 yunjie@163.com wrote: My database connection option: PRAGMA synchronous = NORMAL; PRAGMA journal_mode = OFF; PRAGMA auto_vacuum = 0; In windows process

[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

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

Re: [sqlite] Error when building documentation

2013-04-22 Thread Richard Hipp
On Mon, Apr 22, 2013 at 6:34 AM, David Evans dave.evan...@googlemail.comwrote: 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

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 slav...@bigfraud.org wrote: On 22 Apr 2013, at 12:39pm, Paolo Bolzoni wrote: But I noticed that sqlite3_blob_write

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] 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 m...@mwlabs.de 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

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] 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 dave.evan...@googlemail.comwrote: 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

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] 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 discussed

[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.