Re: [sqlite] Extending Porter Tokenizer

2016-07-09 Thread Abhinav Upadhyay
On Fri, Jul 8, 2016 at 3:01 AM, Matthias-Christian Ott wrote: > On 2016-07-05 18:11, Abhinav Upadhyay wrote: >> I'm wondering if it is possible to extend the functionality of the >> porter tokenizer. I would like to use the functionality of the Porter >> tokenizer but be

[sqlite] Extending Porter Tokenizer

2016-07-05 Thread Abhinav Upadhyay
fy it to suit my needs or there is a better way, to minimize code duplication? - Abhinav ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Preventing certain query keywords from getting stemmed

2016-05-29 Thread Abhinav Upadhyay
(such as ascii lf or some other acronyms). I'm wondering if there is an option to tell the tokenizer not to stem certain keywords and take them as it is? - Abhinav ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailingli

[sqlite] Remote connection to SQLite db

2012-10-18 Thread Abhinav
Hi, Does SQL lite have an option of processes connecting to it from remote hosts with a port number? Thanks, Abhinav Varshney ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Limit on the Compound Select Statements

2012-02-23 Thread Abhinav Upadhyay
On Thu, Feb 23, 2012 at 6:50 PM, Simon Slavin wrote: > > On 23 Feb 2012, at 1:16pm, Abhinav Upadhyay > wrote: > >> I do not remember the >> exact error message but it close to this. As per the documentation on >> the compound select statements >> (http:/

[sqlite] Limit on the Compound Select Statements

2012-02-23 Thread Abhinav Upadhyay
on this, so that I could my code to work within this limit :) Thanks Abhinav ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] File checking mechanism.

2012-02-01 Thread Abhinav Upadhyay
me or not. > If it is exist returns an error. > >         Is there any sqlite function to do file checking mechanism. > > > Regards, > Bhaskar Reddy Just do a stat(2) on the file. (see man 2 stat) -- Abhinav ___ sqlite-users mailing list

Re: [sqlite] [FTS] Executing Sql statements inside a custom tokenizer

2012-01-03 Thread Abhinav Upadhyay
Thanks Abhinav ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [FTS] Executing Sql statements inside a custom tokenizer

2012-01-03 Thread Abhinav Upadhyay
also executed when an SQL query is performed against the FTS table (when performing search), at which time I don't want my dictionary building code to execute. So perhaps this is not a good idea. What other options do I have ? Thanks Abhinav ___ s

Re: [sqlite] FTS3/FTS4 - Finding the term(s) that completes the input

2011-11-20 Thread Abhinav Upadhyay
t I'm having trouble > framing the queries, etc.  Are you able to nudge me in the correct > direction? > > Thanks, > Mohit. I think you might want to look at Token Prefix queries: http://sqlite.org/fts3.html#section_3 -- Abhinav ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Attaching an in-memory database

2011-08-27 Thread Abhinav Upadhyay
On Sat, Aug 27, 2011 at 9:52 PM, Simon Slavin wrote: > > On 27 Aug 2011, at 4:50pm, Abhinav Upadhyay wrote: > >> sqlite3_exec(db, "ATTACH DATABASE :memory AS metadb", NULL, NULL, &errmsg); > > Need a colon after 'memory': > > ATTACH DATABASE &

[sqlite] Attaching an in-memory database

2011-08-27 Thread Abhinav Upadhyay
etting an error exactly at the point where I am trying to execute the create table statement above: # ./makemandb Building temporary file cache makemandb: near ".": syntax error What might be wrong here ? From the documentation it seems that I should be expli

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
On Fri, Aug 12, 2011 at 12:28 AM, Richard Hipp wrote: > On Thu, Aug 11, 2011 at 2:48 PM, Abhinav Upadhyay < > er.abhinav.upadh...@gmail.com> wrote: > >> On Fri, Aug 12, 2011 at 12:05 AM, Michael Stephenson >> wrote: >> > If you use INTEGER PRIMARY KEY, t

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
On Fri, Aug 12, 2011 at 12:05 AM, Michael Stephenson wrote: > If you use INTEGER PRIMARY KEY, that column becomes your rowids; this does > not create a new, separate column in addition to the rowid column. Indeed, but the INTEGER PRIMARY KEY column would count as a user defined column and thus aff

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
On Thu, Aug 11, 2011 at 11:14 PM, Igor Tandetnik wrote: > On 8/11/2011 1:35 PM, Abhinav Upadhyay wrote: >> The documentation page of the VACUUM command says that "The VACUUM >> command may change the ROWIDs of entries in any tables that do not >> have an explicit INTEGER

Re: [sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
On Thu, Aug 11, 2011 at 11:15 PM, Simon Slavin wrote: > > On 11 Aug 2011, at 6:35pm, Abhinav Upadhyay wrote: > >> The documentation page of the VACUUM command says that "The VACUUM >> command may change the ROWIDs of entries in any tables that do not >> have an e

[sqlite] Use of VACUUM

2011-08-11 Thread Abhinav Upadhyay
Hi, The documentation page of the VACUUM command says that "The VACUUM command may change the ROWIDs of entries in any tables that do not have an explicit INTEGER PRIMARY KEY." So what are the possible cases in which the ROWIDs might change ? Than

Re: [sqlite] [FTS3] Understanding the Flow of data through the tokenizer

2011-07-25 Thread Abhinav Upadhyay
On Mon, Jul 25, 2011 at 9:54 AM, Dan Kennedy wrote: > On 07/24/2011 08:16 PM, Abhinav Upadhyay wrote: >> Hi, >> >> I am trying to write my own custom tokenizer to filter stopwords apart >> from doing normalization and stemming. I have gone through the >> comments

[sqlite] [FTS3] Understanding the Flow of data through the tokenizer

2011-07-24 Thread Abhinav Upadhyay
one */ ); }; It would be better if you could explain what is the role of these parameters: piEndOffset , piStartOffset ? Thanks Abhinav ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [FTS3] Header to include for a custom tokenizer

2011-07-23 Thread Abhinav Upadhyay
On Sun, Jul 24, 2011 at 1:40 AM, Abhinav Upadhyay wrote: > On Sat, Jul 23, 2011 at 11:00 PM, Richard Hipp wrote: >> On Sat, Jul 23, 2011 at 1:01 PM, Abhinav Upadhyay < >> er.abhinav.upadh...@gmail.com> wrote: >> >>> Hi, >>> >>>  I am usi

Re: [sqlite] [FTS3] Header to include for a custom tokenizer

2011-07-23 Thread Abhinav Upadhyay
On Sat, Jul 23, 2011 at 11:00 PM, Richard Hipp wrote: > On Sat, Jul 23, 2011 at 1:01 PM, Abhinav Upadhyay < > er.abhinav.upadh...@gmail.com> wrote: > >> Hi, >> >>  I am using the Sqlite3 amalgamation. I am trying to register a custom >> tokenizer with sq

[sqlite] [FTS3] Header to include for a custom tokenizer

2011-07-23 Thread Abhinav Upadhyay
m the sqlite3 source ? Thanks Abhinav ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [FTS3] The Compress and Uncompress functions and extension

2011-07-22 Thread Abhinav Upadhyay
On Fri, Jul 22, 2011 at 1:32 PM, Abhinav Upadhyay wrote: > On Fri, Jul 22, 2011 at 12:38 PM, Alexey Pechnikov > wrote: >> But why you don't use compress/uncompress functions from DRH? See >> http://www.mail-archive.com/sqlite-users%40sqlite.org/msg17018.html >> >&

Re: [sqlite] [FTS3] The Compress and Uncompress functions and extension

2011-07-22 Thread Abhinav Upadhyay
above are three column values that I am trying select in my query. "pring a document" is a query that I tried to execute. Although this is definitely an improvement from before :) Thanks Abhinav ___ sqlite-users mailing list sqlite-users@sqlite.o

Re: [sqlite] [FTS3] The Compress and Uncompress functions

2011-07-20 Thread Abhinav Upadhyay
On Wed, Jul 20, 2011 at 7:51 PM, Abhinav Upadhyay wrote: > Hi, > > I have an FTS table with compress and uncompress options enabled. I am > using zlib(3) for doing the compression. The compression function > seems to be doing ok as I can see the size of the database coming down >

[sqlite] [FTS3] The Compress and Uncompress functions

2011-07-20 Thread Abhinav Upadhyay
l_out == 0); inflateEnd(&strm); sqlite3_result_text(pctx, (const char *)dest, -1, NULL); return; } // concat is a utility function that concatenates its 2nd parameter at the end of its Ist parameter.It returns a negative value on error. -- Abhinav _

[sqlite] Data type of the blob returned by matchinfo()

2011-07-12 Thread Abhinav Upadhyay
*) ? Although common sense says it should be unsigned int *, but just wanted to confirm . Thanks Abhinav ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite over NFS

2010-03-29 Thread Kumar, Abhinav
, Abhinav ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users