Hi Dixon
Dixon Hutchinson wrote:
> I am getting lots of errors of the sort:
>
> 'size_t' to 'int', possible loss of data
>
> I could just turn off the warnings, but that seems kind of wreckless.
> The output from the compile is attached.
Try this (But this is not really necessary.):
#pragma w
Hi,
I had a similar problem at a larger scale. One trick is to create
a temporary table from where you can fetch the rows quickly:
Create Table foo(id INTEGER PRIMARY KEY AUTOINCREMENT, x TEXT);
create index idx_foo on foo(x);
insert into foo(x) values('text001');
:
:
insert into fo
The warnings are normal and unless you want to rewrite sqlite, not much you
can do about them.
Not sure about the run-time check failure
_
From: Dixon Hutchinson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 20 September 2006 8:41 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Diff
I am having difficulty getting a clean build under Visual Studio. I
believe I have followed the advice given at
http://www.sqlite.org/cvstrac/wiki?p=VsNetSolution.
I am getting lots of errors of the sort:
...\\sqlite3\\vdbemem.c(194) : warning C4267: '=' :
conversion from 'size_t' to 'int', p
Mikey C uttered:
Hi,
Maybe I didn't make the question clear. I'm not talking about locking and
multiple writers. I'm talking about optimistic concurrency control in a
disconnected environment.
Two processes (say a webserver). One reads some data and presents it to a
user (open - read - clo
Hello
On Tue, 19 Sep 2006 11:24:02 -0700 (PDT), you wrote:
>Maybe I didn't make the question clear. I'm not talking about locking and
>multiple writers. I'm talking about optimistic concurrency control in a
>disconnected environment.
>
>IF anyone has changed the data since you last read i
Thanks for your answer Ms. Smith!
On 9/19/06, Christian Smith <[EMAIL PROTECTED]> wrote:
Cesar David Rodas Maldonado uttered:
> I meen, If SQLite has two index and very large Index (about 10.000.000each
> one) how do i merge it, I mean (index1 = index2 for every one and limit
it
> in thousand)
Hi,
Maybe I didn't make the question clear. I'm not talking about locking and
multiple writers. I'm talking about optimistic concurrency control in a
disconnected environment.
Two processes (say a webserver). One reads some data and presents it to a
user (open - read - close). The other re
Hello,
If you google something like, "making a lib from a def file" you will
find a lot of information and it will help you understand how to do
this.
It has been a while since I have done it, but you will easily find
what you are looking for.
Matt
tribalmedia
On Sep 11, 2006,
I have the following two tables and related indexes --
CREATE TABLE IF NOT EXISTS pt (
id INTEGER PRIMARY KEY,
xREAL,
yREAL,
attr TEXT
)
CREATE INDEX ix_pt_x ON pt (x)
CREATE INDEX ix_pt_y ON pt (y)
CREATE TABLE IF NOT EXISTS py (
id
Cesar David Rodas Maldonado uttered:
I meen, If SQLite has two index and very large Index (about 10.000.000 each
one) how do i merge it, I mean (index1 = index2 for every one and limit it
in thousand).
Understand?
I guess not.
Are you trying to do an INNER JOIN merger on the two indexes? SQ
Mikey C uttered:
What are peoples thoughts on implementing optimistic concurrency control in
SQLite?
Not an option. SQLite has a single writer database locking protocol which
can't handle multiple writers, so the issue of concurrency control is
moot.
One way is modify the where clause
PY uttered:
Hi All,
I have a problem about LIMIT & OFFSET profermance.
Due to the limitation of memory, I could not get all of the query result at
a time.
In our soluction, we use the LIMIT and OFFSET to avoid the problem of memory
issue.
we observed the performance of LIMIT & OFFSET, it looks
What are peoples thoughts on implementing optimistic concurrency control in
SQLite?
One way is modify the where clause to compare every column being updated,
old value to new value. This makes the SQL cumbersome.
Microsoft SQL Server has a column data type named TIMESTAMP/ROWVERSION which
is da
Dennis Jenkins wrote:
Teg wrote:
Hello Dennis,
I'm, probably going to be offering optional encryption too. Why did
you chose to use the SQLite encryption extensions versus just
encrypting the blobs after you read them back in and before you write
them out?
1) We wanted the entire database
Teg wrote:
Hello Dennis,
I'm, probably going to be offering optional encryption too. Why did
you chose to use the SQLite encryption extensions versus just
encrypting the blobs after you read them back in and before you write
them out?
1) We wanted the entire database encrypted. There is
On 9/18/06, PY <[EMAIL PROTECTED]> wrote:
Hi All,
I have a problem about LIMIT & OFFSET profermance.
Is there any chance you can use an index on your select?
If it has an index it might be able to calculate the position of the
offset and not have to read the entire result set. This is just a
gu
Hi
Are u using precompiled queries? If not try using it...
On 9/19/06, PY <[EMAIL PROTECTED]> wrote:
Hi All,
I have a problem about LIMIT & OFFSET profermance.
Due to the limitation of memory, I could not get all of the query result
at
a time.
In our soluction, we use the LIMIT and OFFSET to a
- Original Message -
From: "Robert Simpson" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, September 19, 2006 2:19 PM
Subject: RE: [sqlite] Quotation handling bug?
Single quotes are supposed to be used for string literals, and double
quotes/brackets for identifiers such as table names and colum
19 matches
Mail list logo
