On Thu, 2007-08-23 at 13:02 -0500, Mark Brown wrote:
> Hi-
>
> We are currently creating databases using this open source tool. According
> to the documentation, it is using version 3.3.5 of SQLite. I was wondering
> if there are any problems with creating a database with the tool, but then
>
I
On 23/08/07, Russell Leighton <[EMAIL PROTECTED]> wrote:
>
>
> Could fts3 (the next fts) have the option to override the default
> 'match' function with one passed in (similar to the tokenizer)?
>
> The reason I ask is then the fts table could be used as smart index
> when the tokenizer is
>
Could fts3 (the next fts) have the option to override the default
'match' function with one passed in (similar to the tokenizer)?
The reason I ask is then the fts table could be used as smart index
when the tokenizer is
something like bigram, trigram, etc. and the 'match' function computes
Besides the suggestions from Dennis below, please search the archives
for emails by me on doing exactly this. I achieved fairly decent
performance on a database of 7.5 million rows doing lookups on 250k
rectangles. I was working on a quad-Xeon server with 4 Gb ram and Win
XP, using Perl to work on
David Thieme wrote:
Scott,
Yes, the SELECT is very simple, but slow. I have tens of thousands of
records and I need the data very fast (embedded realtime system). Some
databases natively support spatial searches, using KD-trees or R-Trees or
Quad-trees to improve the search speed. I found an
It's all interesting, but categorization is hard. Not so hard to get
some results, sort of hard to get quality results. Might work as a
nice adjunct to fts, so that you can throw the search terms into the
categorization engine and put up suggestions for re-running the search
with a tighter
On Thu, 23 Aug 2007 14:15:00 -0400, you wrote:
>On Thu, 23 Aug 2007 18:58:32 +0200, Kees Nuyt wrote:
>
>>Hi Chris,
>
>>On Thu, 23 Aug 2007 12:14:51 -0400, you wrote:
>
>>>On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote:
>>>
Will INSERT OR REPLACE do what you want?
>>>
Gerry
>>>
Hello Dennis,
Thursday, August 23, 2007, 6:05:09 PM, you wrote:
DA> I cannot open a new SQLite3 database file through the command prompt. In
DA> the
DA> windows "run" window, I type "SQLite3 mydatabase.db3" and I get the
DA> following error
DA> message:
DA>
What folder are you in at the command prompt when you type "SQLite3
mydatabase.db3"?
Does it actually contain SQLite3.exe? If not, you need to specify the full
path, or navigate to the folder first.
Michael Hooker
On 23/08/2007 23:05:09, Dennis Achá ([EMAIL PROTECTED]) wrote:
I cannot
I have an application that attaches 7 databases and then does
MANY updates to those databases (maybe a million or two inserts
in a day, spread out over maybe 10,000 separate transactions).
For some reason the client is seeing many master journal files
(-mj) left lying around. I'm asking for
I cannot open a new SQLite3 database file through the command prompt. In
the
windows "run" window, I type "SQLite3 mydatabase.db3" and I get the
following error
message:
**
"Cannot find the file 'SQLite3' (or one of its components). Make
On 23/08/07, Scott Hess <[EMAIL PROTECTED]> wrote:
> On 8/20/07, Cesar D. Rodas <[EMAIL PROTECTED]> wrote:
> > As I know ( I can be wrong ) SQLite Full Text Search is only match with hole
> > words right? It could not be
> > And also no FT extension to db ( as far I know) is miss spell tolerant,
>
On 8/20/07, Cesar D. Rodas <[EMAIL PROTECTED]> wrote:
> As I know ( I can be wrong ) SQLite Full Text Search is only match with hole
> words right? It could not be
> And also no FT extension to db ( as far I know) is miss spell tolerant,
Yes, fts is matching exactly. There is some primitive
Scott,
Yes, the SELECT is very simple, but slow. I have tens of thousands of
records and I need the data very fast (embedded realtime system). Some
databases natively support spatial searches, using KD-trees or R-Trees or
Quad-trees to improve the search speed. I found an article that explains
On Thu, 23 Aug 2007 10:03:00 -0700, David Thieme wrote:
>I've been looking for a WinCE embedded database that supports spatial
>searches. We are already using SQLite for a very small application; we're
>hoping that someone may have some tricks/hints on how to implement fast
>searches on spatial
On Thu, 23 Aug 2007 18:58:32 +0200, Kees Nuyt wrote:
>Hi Chris,
>On Thu, 23 Aug 2007 12:14:51 -0400, you wrote:
>>On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote:
>>
>>>Chris Peachment wrote:
I have a database with more than 200,000 records in the
core table. An update table of
Hi-
We are currently creating databases using this open source tool. According
to the documentation, it is using version 3.3.5 of SQLite. I was wondering
if there are any problems with creating a database with the tool, but then
using the database with an application that is using SQLite
David Thieme wrote:
> I've been looking for a WinCE embedded database that supports spatial
> searches. We are already using SQLite for a very small application; we're
> hoping that someone may have some tricks/hints on how to implement fast
> searches on spatial data with SQLite. A typical
Chris Peachment wrote:
On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote:
Chris Peachment wrote:
I have a database with more than 200,000 records in the
core table. An update table of similar record count contains
a proper subset of the core table columns.
I'm looking for a fast
Hi Chris,
On Thu, 23 Aug 2007 12:14:51 -0400, you wrote:
>On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote:
>
>>Chris Peachment wrote:
>>> I have a database with more than 200,000 records in the
>>> core table. An update table of similar record count contains
>>> a proper subset of the
I've been looking for a WinCE embedded database that supports spatial
searches. We are already using SQLite for a very small application; we're
hoping that someone may have some tricks/hints on how to implement fast
searches on spatial data with SQLite. A typical search would be finding
items
Chris Peachment <[EMAIL PROTECTED]>
wrote:
I have a database with more than 200,000 records in the
core table. An update table of similar record count contains
a proper subset of the core table columns.
I'm looking for a fast method of merging the values in the
two tables such that :
1. core
On Thu, 23 Aug 2007 08:52:40 -0700, Gerry Snyder wrote:
>Chris Peachment wrote:
>> I have a database with more than 200,000 records in the
>> core table. An update table of similar record count contains
>> a proper subset of the core table columns.
>>
>> I'm looking for a fast method of merging
Chris Peachment wrote:
I have a database with more than 200,000 records in the
core table. An update table of similar record count contains
a proper subset of the core table columns.
I'm looking for a fast method of merging the values in the
two tables such that :
1. core table columns are
I have a database with more than 200,000 records in the
core table. An update table of similar record count contains
a proper subset of the core table columns.
I'm looking for a fast method of merging the values in the
two tables such that :
1. core table columns are updated, and
2. non-existent
I use this framework to build sqlite on VS2005.SP1:
// \file import_sqlite.cpp
// \brief Import the SQLITE database.
//
#pragma warning(push, 0)
#pragma warning(disable: 4701)
#pragma runtime_checks("", off)
// enable multi-thread mode.
#define THREADSAFE 1
// optimize for performance by using
"Andrew Finkenstadt" <[EMAIL PROTECTED]> wrote:
> I realize that FTS1/2 has this slight flaw with the text indexes recording
> the _rowid_ of a table, in the expectation that a rowid was permanent. That
> would have caught me unawares, as in Oracle a ROWID is permanent... even if
> the row has
On 8/23/07, Andre du Plessis <[EMAIL PROTECTED]> wrote:
> Just wanted to check with you guys that my build is actually stable in
> Visual Studio 2005, I get about 250+ warnings when building SQLite I can
> come back to you with more details if this is not correct, just want to
> make sure that's
Just wanted to check with you guys that my build is actually stable in
Visual Studio 2005, I get about 250+ warnings when building SQLite I can
come back to you with more details if this is not correct, just want to
make sure that's seems correct, ive been getting the occasional weird
SQLite
At 1:54 PM +1000 8/23/07, T wrote:
Hi Darren,
It seems to me that you have a flawed design.
Displaying sparse like that should be a function of your
application display code, not the database
I had to chuckle that when I asked "How do I use this to do that",
your solution was "you shouldn't
30 matches
Mail list logo