-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/12/2011 01:26 PM, John Deal wrote:
> Good question. Very possible my understanding is not complete.
This document has the full details:
http://www.sqlite.org/lockingv3.html
>I have basically read and write transactions, each potentially wit
Thanks. I'll give that a test in the morning and let you know the results.
Don Ireland
-Original Message-
From: "Afriza N. Arief"
To: General Discussion of SQLite Database
Sent: Thu, 12 May 2011 11:25 PM
Subject: Re: [sqlite] Visual Studio EE 2010
On Fri, May 13, 2011 at 10:10 AM, Don
On Fri, May 13, 2011 at 10:10 AM, Don Ireland wrote:
> I'm using C++/CLI & downloaded/installed the dotnet file at the link you
> provided.
>
> After doing so, I found several DLL files in two folders: bin & GAD (I
> believe that's the name).
>
> Don Ireland
>
>
Hi,
Try creating a new C++/CLI C
On Thu, May 12, 2011 at 7:56 PM, Jim O'Brien wrote:
> I have installed sqlite-dotnet-x86-1007200 (using Full Install)
>
> I have a simple program to test System.Data.SQLite.
>
> It is compiled using 2008 C# Express (no ability to change target CPU) with
> all the proper references and usings.
>
On 5/12/2011 10:20 PM, John wrote:
> These are the names of actual views in this example. Let me rename them:
>
>> insert into rules_table values (1, view10);
>> insert into rules_table values (2, view20);
>> insert into rules_table values (3, view30);
>> insert into rules_table values (4, view40);
These are the names of actual views in this example. Let me rename them:
> insert into rules_table values (1, view10);
> insert into rules_table values (2, view20);
> insert into rules_table values (3, view30);
> insert into rules_table values (4, view40);
On Thu, May 12, 2011 at 7:45 AM, Igor Ta
> Pavel, could you please specify what do you mean by "statements in this
> transaction"? Statements
> that were prepared (sqlite3_prepare) or initiated (sqlite3_step) during the
> transaction?
Statements that were initiated during the transaction.
> Also, is this something that one should imme
I'm using C++/CLI & downloaded/installed the dotnet file at the link you
provided.
After doing so, I found several DLL files in two folders: bin & GAD (I believe
that's the name).
Don Ireland
-Original Message-
From: "Afriza N. Arief"
To: General Discussion of SQLite Database
Sent
If you don't mind, John, for bullying in the discussion...
On Thu, 12 May 2011 17:58:40 -0400
Pavel Ivanov wrote:
> There's no dependency between different prepared statements, but there
> is dependency between transactions as they use the same database. And
> transaction cannot be finished (imp
> Humm. Resetting each prepared statement right after use seemed to work. So
> in review, a select prepared statement will lock the DB from other threads
> (or is it DB connections?) but not the current thread (or is it DB
> connection).
Yes, you are right. Transactions and database locks are
On 13 May 2011, at 1:33am, John Deal wrote:
> Humm. Resetting each prepared statement right after use seemed to work. So
> in review, a select prepared statement will lock the DB from other threads
> (or is it DB connections?) but not the current thread (or is it DB
> connection).
I don't t
Hello Roger,
OK I see your point now. I could most likely remove the OS mutexes.
Thanks,
John
--- On Thu, 5/12/11, Roger Binns wrote:
> From: Roger Binns
> Subject: Re: [sqlite] Multi-threading Common Problem
> To: sqlite-users@sqlite.org
> Date: Thursday, May 12, 2011, 4:01 PM
> -BEGIN
Hello Pavel,
Humm. Resetting each prepared statement right after use seemed to work. So in
review, a select prepared statement will lock the DB from other threads (or is
it DB connections?) but not the current thread (or is it DB connection).
Thanks for the help!
John
--- On Thu, 5/12/11, P
I have installed sqlite-dotnet-x86-1007200 (using Full Install)
I have a simple program to test System.Data.SQLite.
It is compiled using 2008 C# Express (no ability to change target CPU) with
all the proper references and usings.
When I attempt to run it, I get the error "Unhandled Exception:
Hello again Pavel,
OK but I am a bit confused. What I have works as a single instance with one DB
connection running under different threads as long as only one is using the DB
connection at a time. This is with prepared statements "hanging" (not reset)
with different threads using different
Hello Pavel,
This makes sense but I have shared cache on.
Thanks.
--- On Thu, 5/12/11, Pavel Ivanov wrote:
> From: Pavel Ivanov
> Subject: Re: [sqlite] Multi-threading Common Problem
> To: "General Discussion of SQLite Database"
> Date: Thursday, May 12, 2011, 5:55 PM
> > "After a BEGIN EXCL
> Interesting is the impression I had with prepared statements was the reset
> was only necessary if you wanted to reuse that statement. Since each each DB
> connection is in its own instance of a class (with it own set of prepared
> statements) I would not think there would be any dependency o
> "After a BEGIN EXCLUSIVE, no other database connection except for
> read_uncommitted connections will be able to read the database and no other
> connection without exception will be able to write the database until the
> transaction is complete."
>
> This tells me that reads outside of a tran
Good question. Very possible my understanding is not complete.
I have basically read and write transactions, each potentially with several
accesses to the DB. I want to ensure that if a write transaction is happening,
no read transactions are in progress since it would be possible to have obta
On Thu, May 12, 2011 at 4:07 PM, Paul Shaffer wrote:
> I didn't get an answer to my earlier question on fts. I guess it's
> difficult area.
>
> Should an fts virtual table always be re-created from scratch when the
> database is opened by the application before you start using fts commands?
>
No.
I didn't get an answer to my earlier question on fts. I guess it's
difficult area.
Should an fts virtual table always be re-created from scratch when the
database is opened by the application before you start using fts commands?
I see that the fts tables are not deleted when the database is closed
Hello Igor,
That very well maybe it. I am not at home so can't test for sure but I reset
the prepared statements right before I use them so they are left hanging if
another thread came in.
Interesting is the impression I had with prepared statements was the reset was
only necessary if you wan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/12/2011 09:38 AM, John Deal wrote:
> I have been working for weeks on this and I feel there must be something
> simple I am overlooking.
Why are you discarding SQLite's builtin and tested mutexes and then
effectively reimplementing your own t
For those that don't know:
VSEE2010 = Visual Studio Express Edition 2010
Don Ireland
-Original Message-
From: Don Ireland
To: General Discussion of SQLite Database
Sent: Thu, 12 May 2011 12:17 PM
Subject: Re: [sqlite] Visual Studio EE 2010
I'm using C++/CLI.
Thanks.
Don Ireland
---
I use Thunderbird on my laptop and also have an Imap client on my Android.
I signed up for this list by sending a msg from Android. Both email clients
send from the same address.
But when I send a message from my pc, it seems to end up in a vacuum because it
never appears on the list.
Any id
I'm using C++/CLI.
Thanks.
Don Ireland
-Original Message-
From: "Afriza N. Arief"
To: General Discussion of SQLite Database
Sent: Thu, 12 May 2011 11:23 AM
Subject: Re: [sqlite] Visual Studio EE 2010
On Thu, May 12, 2011 at 11:18 PM, Don Ireland wrote:
> I downloaded and installed s
I believe I've got solutions to the various little problems I've run
into. My experiments have helped me shed some light on what the
semantics of DB triggers should be, to the point where I think I've
reached stable conclusions about those semantics. I'm also ready to
characterize performance and
Hello All,
I have been using SQLite for a couple of years but have never posted to this
list before. I am sure my problem is common and am looking for ideas to solve
it.
I have used SQLite extensively single-threaded with no problems (other than my
own!). I am currently working on another pr
On 5/12/2011 12:31 PM, John Deal wrote:
> When I allow multiple readers with each thread using a different DB
> connection (open with the same flags) and each thread having
> exclusive use of its DB connection (no sharing of connections) and if
> more than one thread is reading the DB at the same t
Hello All,
I have been using SQLite for a couple of years but have never posted to this
list before. I am sure my problem is common and am looking for ideas to solve
it.
I have used SQLite extensively single-threaded with no problems (other than my
own!). I am currently working on another pr
Hello All,
I have been using SQLite for a couple of years but have never posted to this
list before. I am sure my problem is common and am looking for ideas to solve
it.
I have basically the same situation as this thread:
---
On Wed, Jan 26, 2011 at 10:
On Thu, May 12, 2011 at 11:18 PM, Don Ireland wrote:
> I downloaded and installed sqlite-dotnet-x86-3070600.zip.
>
> But when I attempt to add it as preference in VSEE2010, I find several dll
> files. But none of them results in me being able to include a SQLite.h
> file.
>
>
What kind of enviro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/10/2011 01:24 PM, Mays, Steve wrote:
> Question 1.) Can "exentension_functions.c" be compiled along with
> "sqlite3.c" into one executable?
>
> Question 2.) If so, how?
>
> Question 3.) If "exentension_functions.c" be compiled into one
> exe
I downloaded and installed sqlite-dotnet-x86-3070600.zip.
But when I attempt to add it as preference in VSEE2010, I find several dll
files. But none of them results in me being able to include a SQLite.h file.
What am I doing wrong?
Don Ireland
___
s
Black, Michael (IS) wrote:
>
> Do I understand you're still seeing a segfault? I assume you're not
> seeing your "Year retrieved..." statement?
>
> You haven't showed us your table definition.
>
> Change your strcmp to strcasecmp and see if that fixes it for you.
>
> Michael D. Black
>
> S
StyveA wrote:
> I tried with your tips, and I've seen that I was missing the call of my
> callback function, and now the segfault is in it..
Personally, I vastly prefer sqlite3_step / sqlite3_column* interface to
sqlite3_exec. I never use the latter except for one-liner statements like BEGIN
or
Do I understand you're still seeing a segfault? I assume you're not seeing
your "Year retrieved..." statement?
You haven't showed us your table definition.
Change your strcmp to strcasecmp and see if that fixes it for you.
Michael D. Black
Senior Scientist
NG Information Systems
Adv
Igor Tandetnik wrote:
>
> Prepare doesn't touch the database in any way. It just parses the text of
> the statement, and prepares execution plan. Step is where the real work is
> done.
>
> You need to issue BEGIN statement if you want to start an explicit
> transaction (and then COMMIT or END
StyveA wrote:
> For the COMMIT/END point, I though that sqlite_prepare(..) was sufficient
> to do it, so Begin is mandatory?
Prepare doesn't touch the database in any way. It just parses the text of the
statement, and prepares execution plan. Step is where the real work is done.
You need to is
Igor Tandetnik wrote:
>
> StyveA wrote:
>> I'm a newbie using sqlite3, and i'm trying to save in a database some
>> blob
>> datas (just string and integer),
>> but I can't get my data back.. I just obtain a segfault..
>> I have searched in forums, but did'nt find anything that could help me..
StyveA wrote:
> I'm a newbie using sqlite3, and i'm trying to save in a database some blob
> datas (just string and integer),
> but I can't get my data back.. I just obtain a segfault..
> I have searched in forums, but did'nt find anything that could help me..
>
> int *blob;
> blob = 1990;
> sqlit
Hello,
I'm a newbie using sqlite3, and i'm trying to save in a database some blob
datas (just string and integer),
but I can't get my data back.. I just obtain a segfault..
I have searched in forums, but did'nt find anything that could help me..
Here is my code :
http://old.nabble.com/file/p31602
John wrote:
> I don't see how that helps. Let's say I have table with rules which
> determine from which view to select:
>
> create rules_table
> (condition integer, myview integer);
>
> insert into rules_table values (1,10);
> insert into rules_table values (2,20);
> insert into rules_table val
On 5/11/2011 3:52 PM, cricketfan wrote:
>
> I dont know if it is just me but I find the return codes for SQL operation
> quite confusing. I am new to SQLITE, have learnt a few things and wanted to
> know if going in the correct direction,
You are thinking in the wrong direction.
SQLITE_DONE means t
44 matches
Mail list logo