Hello,
if a running sqlite database is in WAL mode and a backup is performed on that
db using the sqlite3_backup API, does that process is considered like a reader
and can proceed concurrently with other readers and with the other writer?
Thanks a lot for your answer.
--
Marco Bambini
http://ww
On 11/30/2010 05:03 PM, Marco Bambini wrote:
> Hello,
>
> if a running sqlite database is in WAL mode and a backup is performed on that
> db using the sqlite3_backup API, does that process is considered like a
> reader and can proceed concurrently with other readers and with the other
> writer?
On 30.11.2010 11:32, Dan Kennedy wrote:
> On 11/30/2010 05:03 PM, Marco Bambini wrote:
>> Hello,
>>
>> if a running sqlite database is in WAL mode and a backup is performed on
>> that db using the sqlite3_backup API, does that process is considered like a
>> reader and can proceed concurrently wi
As said off topic - but I have never heard of a cell ID being recorded
with an SMS message. You can find more info on the SMS message format
by search for "sms pdu" (protocol description unit) you can see from
this somewhat complex structure that the cell ID is not part of the
transmitted message f
> BTW:
> Is there any chance that in the future the wal mode
> will avoid that the backup API will restart on DB
> changes during the backup loop ?
> Currently, even in wal mode, it does restart when changes
> are detected while the backup is ongoing.
What happens if you open a read transaction o
On 30.11.2010 11:50, Dan Kennedy wrote:
>
>> BTW:
>> Is there any chance that in the future the wal mode
>> will avoid that the backup API will restart on DB
>> changes during the backup loop ?
>> Currently, even in wal mode, it does restart when changes
>> are detected while the backup is ongoing
Hi recently I noticed that i can't search with the like '%searchword%'
syntax on an FTS3 virtual table.
And with "match" i can't search on example sentences (the indexed data
is a japanese dictionary an therefore has no spaces in example sentences
and there is no perfekt tokenizer atm i tried mec
Hi, I'm working on a multi-threaded image server and I have 2 questions:
1) How "expensive" is a call to sqlite3_open. Does a call to
sqlite3_enable_shared_cache make it "cheaper"?
2) If sqlite3_open is an expensive operation then I would like to keep a list
(cache) of open database connections
> 1) How "expensive" is a call to sqlite3_open. Does a call to
> sqlite3_enable_shared_cache make it "cheaper"?
Its cost depends on the size of your schema as it gets parsed during
open. Shared cache doesn't make it cheaper. It can make somewhat
cheaper (in some cases) to use several connections
Hello,
I have 2 threads in my program, 1st thread is doing inserts into a
table and 2nd thread is trying to update the already inserted columns.
1. I have bundled the 1000 inserts per transaction in 1st thread.
2. When I try to start a transaction in the 2nd thread for my updates (when
th
Quoth cricketfan , on 2010-11-30 07:49:36 -0800:
> Also not that both threads are
> using the same handle passed by main.
No, don't do that. Using the same handle in two threads concurrently
can break depending on the SQLite threading mode, and will gain you no
parallelism in the modes where it w
On 30 Nov 2010, at 3:49pm, cricketfan wrote:
>I have 2 threads in my program, 1st thread is doing inserts into a
> table and 2nd thread is trying to update the already inserted columns.
> 1. I have bundled the 1000 inserts per transaction in 1st thread.
> 2. When I try to start a transac
Thanks Igor.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Igor Tandetnik
Sent: Monday, November 29, 2010 7:11 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Just compiled SQLite in Visual Studio
john darnell wrote:
I've just discovered EXPLAIN QUERY PLAN; it looks quite useful, but one part of
the output is somewhat opaque.
The command returns three columns: order, from, and detail. "order" is
evidently the order in which the indices are applied; the "detail" explains
which table and index is involved.
I know this is a fundamental question, but in the book I'm using to learn
SQLite, there is no reference that I can find for what one needs to do to
create a database. I thought that simply using a CREATE statement with a
database name included might do the trick, but alas it does not.
I went t
On Tue, Nov 30, 2010 at 10:40:52AM -0600, john darnell scratched on the wall:
> I know this is a fundamental question, but in the book I'm using to
> learn SQLite, there is no reference that I can find for what one needs
> to do to create a database. I thought that simply using a CREATE
> statemen
Okay, I seem to have figured it out. One needs to create the database and
then add a table before the database will be created.
Sorry for the baby steps.
R,
John A.M. Darnell
Senior Programmer
Walsworth Publishing Company
Brookfield, MO
John may also be reached at
johnamdarn...@gmail.com
On 11/30/2010 11:38 PM, Duquette, William H (316H) wrote:
> I've just discovered EXPLAIN QUERY PLAN; it looks quite useful, but one part
> of the output is somewhat opaque.
>
> The command returns three columns: order, from, and detail. "order" is
> evidently the order in which the indices are a
Thanks, Dan!
On 11/30/10 9:05 AM, "Dan Kennedy" wrote:
On 11/30/2010 11:38 PM, Duquette, William H (316H) wrote:
> I've just discovered EXPLAIN QUERY PLAN; it looks quite useful, but one part
> of the output is somewhat opaque.
>
> The command returns three columns: order, from, and detail. "
Pavel,
> > 1) How "expensive" is a call to sqlite3_open. Does a call to
> sqlite3_enable_shared_cache make it "cheaper"?
>
>Its cost depends on the size of your schema as it gets parsed during
>open.
Isn't this contradictory with an answer by Igor made in a recent thread?
>Subject: Re: [sqlite
>> > 1) How "expensive" is a call to sqlite3_open. Does a call to
>> sqlite3_enable_shared_cache make it "cheaper"?
>>
>>Its cost depends on the size of your schema as it gets parsed during
>>open.
>
> Isn't this contradictory with an answer by Igor made in a recent thread?
It's not contradictory.
On Mon, Nov 29, 2010 at 9:08 AM, Pascal Schnurr wrote:
> Hi recently I noticed that i can't search with the like '%searchword%'
> syntax on an FTS3 virtual table.
I'm no expert, but are you sure? This exact example, using LIKE,
appears in the FTS3 docs:
http://www.sqlite.org/fts3.html#section_1
It does but as you can see the like is only performed on a normal table
and the match you find only entrys like " sql " or maby " selserver "
but not "blablalbasqlstatic"
Am Dienstag, den 30.11.2010, 11:50 -0800 schrieb Sam Roberts:
> On Mon, Nov 29, 2010 at 9:08 AM, Pascal Schnurr wrote:
> >
Drake, I am using SQLITE in threadsafe mode. Transaction inside another
transaction isnt that equivalent of nested transactions? Should that be
allowed? I have no problem opening another handle but just trying to
understand the intricacies, thanks.
Drake Wilson-3 wrote:
>
> Quoth cricketfan , o
Quoth cricketfan , on 2010-11-30 12:11:52 -0800:
> Drake, I am using SQLITE in threadsafe mode. Transaction inside another
> transaction isnt that equivalent of nested transactions? Should that be
> allowed?
SQLite has named savepoints, but not nested BEGIN transactions. It's
hard to tell what ex
On Tue, Nov 30, 2010 at 12:29 AM, Shane Harrelson wrote:
>
It turns out the same problem exists on Linux (I used sqlite3-3.7.3.bin);
for example:
sqlite> create table t1(d float);
sqlite> insert into t1 values(9.87e+31);
sqlite> select * from t1;
9.870001e+31
So it seems that extende
>It's not contradictory. I say that "real cost" of sqlite3_open is
>parsing the schema. Igor says that this cost is actually deferred from
>inside sqlite3_open call to the first "substantive" sqlite3_step call.
>So you will have to pay this price anyway, just profiler output would
>be somewhat con
Drake,
It is in serialized mode. Opening another handle did resolve the
issue. I am doing inserts in one thread and then if necessary update the
same using another thread.
Drake Wilson-3 wrote:
>
> Quoth cricketfan , on 2010-11-30 12:11:52 -0800:
>> Drake, I am using SQLITE in threads
On 30 Nov 2010, at 8:11pm, cricketfan wrote:
> Drake, I am using SQLITE in threadsafe mode. Transaction inside another
> transaction isnt that equivalent of nested transactions? Should that be
> allowed? I have no problem opening another handle but just trying to
> understand the intricacies, tha
OK then I have a newbee question that is actually out of the scope of SQLite.
If the only difference between C and C++ is the file extension, then what is
the difference between C and C++? I'm thinking of adding a language other than
the Visual Basic that I kind of know and would like to know th
On 1 Dec 2010, at 1:01am, Bob Keeland wrote:
> OK then I have a newbee question that is actually out of the scope of SQLite.
> If the only difference between C and C++ is the file extension,
No.
> then what is the difference between C and C++? I'm thinking of adding a
> language other than th
n/mailman/listinfo/sqlite-users
__ Information from ESET NOD32 Antivirus, version of virus signature
database 5662 (20101130) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Wed, Dec 01, 2010 at 01:10:51AM +, Simon Slavin scratched on the wall:
> So every C program is a C++ program,
Not true.
Try to compile sqlite3.c with a C++ compiler and see how far you get.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear:
Oh, from the various replies I see that C++ is a more capable extension of C.
Igor was only using a figure of speech, kind of. Sorry about the newbee
question, but thanks for the replies.
Bob Keeland
--- On Tue, 11/30/10, Simon Slavin wrote:
From: Simon Slavin
Subject: Re: [sqlite] Just co
On 11/30/2010 10:18 PM, Doug wrote:
> Objects exist in
> C++, and they don't in C
actually objects can and do exist in C, it's just a matter of writing
them. C++ added the extensions to make writing/managing them easier.
http://www.google.com/search?q=object+oriented+programming+in+C&ie=ut
On 1 Dec 2010, at 1:33am, Jay A. Kreibich wrote:
> On Wed, Dec 01, 2010 at 01:10:51AM +, Simon Slavin scratched on the wall:
>
>> So every C program is a C++ program,
>
> Not true.
>
> Try to compile sqlite3.c with a C++ compiler and see how far you get.
Can you explain the problem to
On 11/30/2010 8:42 PM, Simon Slavin wrote:
> On 1 Dec 2010, at 1:33am, Jay A. Kreibich wrote:
>
>> On Wed, Dec 01, 2010 at 01:10:51AM +, Simon Slavin scratched on the wall:
>>
>>> So every C program is a C++ program,
>> Not true.
>>
>> Try to compile sqlite3.c with a C++ compiler and see ho
Bob Keeland wrote:
> OK then I have a newbee question that is actually out of the scope of SQLite.
> If the only difference between C and C++ is the
> file extension, then what is the difference between C and C++?
Since the premise of the question is false, any conclusion whatsoever may
logical
Simon Slavin wrote:
> So every C program is a C++ program
Not quite true. Here are a few examples that are valid C but invalid C++:
/* implicit 'int' return type */
f();
/* implicit conversion from void* to any pointer type */
char* p = malloc(100);
// calling a function without first declar
On 1 Dec 2010, at 1:46am, Reid Thompson wrote:
> On 11/30/2010 8:42 PM, Simon Slavin wrote:
>> On 1 Dec 2010, at 1:33am, Jay A. Kreibich wrote:
>>
>>> On Wed, Dec 01, 2010 at 01:10:51AM +, Simon Slavin scratched on the
>>> wall:
>>>
So every C program is a C++ program,
>>> Not true.
Bob Keeland wrote:
> Oh, from the various replies I see that C++ is a more capable extension of C.
> Igor was only using a figure of speech, kind of.
Everything I said in this thread so far, I meant quite literally. Which
expression of mine do you take as a figure of speech?
--
Igor Tandetnik
On 11/30/2010 9:04 PM, Simon Slavin wrote:
> Oh. No matter. It's the one Apple's Xcode calls and it's being very clever
> about what language it's compiling. It defeated my test.
>
> Simon.
a quick google query seems to imply that Xcode uses the Gnu Compiler
Collection (gcc, g++, gcj, gfortan
On Nov 30, 2010, at 18:04, Igor Tandetnik wrote:
> It is true, however, that it's fairly easy to transform any C program into a
> program that's both valid C and C++, by applying straightforward
> modifications - tightening type safety and such.
Except there are a lot of areas where C
Dustin Sallings wrote:
> On Nov 30, 2010, at 18:04, Igor Tandetnik wrote:
>
>> It is true, however, that it's fairly easy to transform any C program into a
>> program that's both valid C and C++, by applying
>> straightforward modifications - tightening type safety and such.
>
> Except there a
Is there anyone publishing stable version of precompiled binaries of sqlite
for Windows 64-bit ?
I understand from the below sqlite.org doesn't, but there maybe another
site?
Thanks
-- Forwarded message --
From: Dan Kennedy
Date: Tue, Nov 30, 2010 at 6:58 PM
Subject: Re: [sqlite-
45 matches
Mail list logo