Hi,
As per my understanding I see that SQLite supports only database locking, as
opposed to table/row locking. Does anyone know if you can read from a locked
database ? (i.e. if one application has locked the database for writing,
then can another application read/query it whilst its locked?
Than
--- Doug <[EMAIL PROTECTED]> wrote:
> 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 file
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
> u
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
> som
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 a
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 focus.
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 ope
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
l
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
s
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 suppo
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
h
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 d
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 3.4.1?
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 searc
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 core
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 who
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 ta
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 th
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 upda
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 la
"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 mig
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 se
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 error,
31 matches
Mail list logo