On Thu, Feb 23, 2012 at 6:50 PM, Simon Slavin slav...@bigfraud.org wrote:
On 23 Feb 2012, at 1:16pm, Abhinav Upadhyay er.abhinav.upadh...@gmail.com
wrote:
I do not remember the
exact error message but it close to this. As per the documentation on
the compound select statements
(http
Hi,
I have a single column table, in which I wish to store around several
thousands of rows. I was wondering if I could insert them using a
single INSERT query and came across this Stackoverflow answer:
http://stackoverflow.com/a/1734067/348637 . According to that answer
it is possible to insert
On Wed, Feb 1, 2012 at 1:37 PM, bhaskarReddy uni...@gmail.com wrote:
Hi Friends,
Is there any File checking mechanism in sqilte3.
Suppose i have a file ABCD.db, before i want to create the data
base file, i want to check whether it is already exit with the same or not.
If
Hi,
I would like to build up a table of all the unique words occurring in
my corpus (for spelling suggestion feature). Presently I am using the
Porter stemming tokenizer and I would not like to stop using the
stemmer at any cost. Although if I was not using the Porter stemmer
then I could easily
Two FTS tables? One with the Porter stemmer, for search, one without, to
build the auxiliary tables?
Yeah, that is the last option, if nothing else works. For a small set
of documents the extra processing time might be ok but for a larger
set of documents building the FTS tables twice might be
On Mon, Nov 21, 2011 at 12:17 AM, Mohit Sindhwani m...@onghu.com wrote:
Hi, I'm finding my way through FTS3/FTS4 to replace some of the old code
that we have for searching terms within titles. I now know that FTS3/4
should be the way to proceed.
So far, I have this:
- an FTS4 table that has
Hi,
I am trying to attach an in-memory database and then create a table in
it. Here is the code that I am using:
/* I have already opened a connection to a database before the following */
sqlite3_exec(db, ATTACH DATABASE :memory AS metadb, NULL, NULL, errmsg);
if (errmsg != NULL) {
On Sat, Aug 27, 2011 at 9:52 PM, Simon Slavin slav...@bigfraud.org 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 ':memory:' AS metadb;
I don't think you need
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 ?
Thanks
Abhinav
On Thu, Aug 11, 2011 at 11:15 PM, Simon Slavin slav...@bigfraud.org 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 explicit INTEGER PRIMARY
On Thu, Aug 11, 2011 at 11:14 PM, Igor Tandetnik itandet...@mvps.org 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 PRIMARY KEY
On Fri, Aug 12, 2011 at 12:05 AM, Michael Stephenson
domehead...@gmail.com 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
On Fri, Aug 12, 2011 at 12:28 AM, Richard Hipp d...@sqlite.org 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
domehead...@gmail.com wrote:
If you use INTEGER PRIMARY KEY, that column becomes
On Mon, Jul 25, 2011 at 9:54 AM, Dan Kennedy danielk1...@gmail.com 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 in fts3_tokenizer.h
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 in fts3_tokenizer.h and also read the implementation of the
simple tokenizer. While overall I am able to understand what I need to
do to implement
Hi,
I am using the Sqlite3 amalgamation. I am trying to register a custom
tokenizer with sqlite for my FTS application. The custom tokenizer is
in it's separate source file. I have included sqlite3.h header with
the tokenizer source but sqlite3.h does not contain the declaration of
the various
On Sat, Jul 23, 2011 at 11:00 PM, Richard Hipp d...@sqlite.org 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 sqlite for my FTS application. The custom
On Sun, Jul 24, 2011 at 1:40 AM, Abhinav Upadhyay
er.abhinav.upadh...@gmail.com wrote:
On Sat, Jul 23, 2011 at 11:00 PM, Richard Hipp d...@sqlite.org 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
On Fri, Jul 22, 2011 at 12:38 PM, Alexey Pechnikov
pechni...@mobigroup.ru wrote:
But why you don't use compress/uncompress functions from DRH? See
http://www.mail-archive.com/sqlite-users%40sqlite.org/msg17018.html
I did wrap these into extension and add SQLITE_COMPRESS_MIN_LENGTH
On Fri, Jul 22, 2011 at 1:32 PM, Abhinav Upadhyay
er.abhinav.upadh...@gmail.com wrote:
On Fri, Jul 22, 2011 at 12:38 PM, Alexey Pechnikov
pechni...@mobigroup.ru wrote:
But why you don't use compress/uncompress functions from DRH? See
http://www.mail-archive.com/sqlite-users%40sqlite.org
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
drastically. But I the uncompress function is not working properly.
For example if I
On Wed, Jul 20, 2011 at 7:51 PM, Abhinav Upadhyay
er.abhinav.upadh...@gmail.com 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
Hi,
Quoting the ranking function given in the appendix of the FTS3
documentation page (http://www.sqlite.org/fts3.html#appendix_a)
static void rankfunc(sqlite3_context *pCtx, int nVal, sqlite3_value **apVal){
int *aMatchinfo;/* Return value of matchinfo() */
...
...
aMatchinfo
23 matches
Mail list logo