sqlite-users-
> boun...@sqlite.org] On Behalf Of Simon L
> Sent: 26 October 2011 14:08
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Multiple databases in one DB connection. How to let
BEGIN
> TRANSACTION..COMMIT apply to only one of them?
>
> While one of the databases is unde
While one of the databases is under a lengthy writing process, I
don't want other databases to be locked by the BEGIN
TRANSACTION...COMMIT lock.
Is this possible? Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Rich Shepard
Sent: Tuesday, October 26, 2010 10:59 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Multiple databases vs. Multiple tables.
On Tue, 26 Oct 2010, Dariusz Matkowski wrote:
> Queries will be done acr
On Tue, 26 Oct 2010, Dariusz Matkowski wrote:
> Queries will be done across the servers to aggregate the content. I am
> concern about the locking mechanism, if I write to the single database and
> I represent the servers as tables I will have no access to read the other
> servers/tables, but if
write into one and
the other ones are open to read.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Rich Shepard
Sent: Tuesday, October 26, 2010 9:57 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Multiple
On Tue, 26 Oct 2010, Dariusz Matkowski wrote:
> Only one user (the browser). The DB is on a device the same place where
> the user (Browser) is. A process will collect the information about the
> servers and their contents and story it to the DB at the same time the
> user may ask for the
-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Rich Shepard
Sent: Tuesday, October 26, 2010 9:24 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Multiple databases vs. Multiple tables.
On Tue, 26 Oct 2010, Dariusz Matkowski wrote
On Tue, 26 Oct 2010, Dariusz Matkowski wrote:
> in your opinion is it better (performance, maintainability etc...) to
> have multiple databases or multiple tables. The problem I am facing is as
> follows. I have many media servers containing a large amount of images
> music and videos, let's
Question,
in your opinion is it better (performance, maintainability etc...) to have
multiple databases or multiple tables. The problem I am facing is as follows. I
have many media servers containing a large amount of images music and videos,
let's assume 5. I would like to gather the
On Mar 3, 2008, at 12:55 AM, Kee Wee wrote:
>
> I would be very interested to follow-up this subject closely,
> as we are actually performing the same kind of work as you are
> looking for.
>
> One of the answer you got was that it is not possible to reuse a
> prepared
> statement from one
I would be very interested to follow-up this subject closely,
as we are actually performing the same kind of work as you are looking for.
One of the answer you got was that it is not possible to reuse a prepared
statement from one database to another.
This answer was too quick, and did not
"Mina R Waheeb" <[EMAIL PROTECTED]> wrote:
> Hi,
>I have few questions regarding the limitation of multiple databases with
> SQLite.
>
> I have a large number of SQLite DB files with the same structure i
> need to query them all (looking for speed), I have tried ATTACH method
> and its
Thanky Mr. Kees!
This help a lot. This is the way i was thinking too.
I have lot things to do though, i am still learning the sqlite!
Thank you once again!
--
View this message in context:
http://www.nabble.com/multiple-databases-tf4480719.html#a12794210
Sent from the SQLite mailing list
On Thu, 20 Sep 2007 02:03:59 -0700 (PDT), you wrote:
>
>Hello again!
>I was really surprised and relieved to see that so many people replied to my
>question! I really thank you all!
>I would love to come to the conference but i am from Greece.
>I am going to explain in details what i am trying to
Hello again!
I was really surprised and relieved to see that so many people replied to my
question! I really thank you all!
I would love to come to the conference but i am from Greece.
I am going to explain in details what i am trying to do.
I am indeed using the network simulator 2 in order to
[EMAIL PROTECTED] wrote:
There are no SQLite-specific talks or tutorials this year
Well, my talk Thursday afternoon is on using an SQLite database for
storing Tcl/Tk scripts which are used for displaying and modifying
SQLite databases. So although your statement is strictly correct, I
I think that his project is to use simulation software to build a model
of a network in software using a simulation package like NS2. It models
the network by implementing algorithms, not by setting up hardware.
Vitali Lovich wrote:
I think you need to clarify your needs a bit, cause it seems
nadiap wrote:
Hello,
i am a newbie and i would like to ask if it is possible to use sqlite in
order to simulate a wireless network where each node will have each own
database. I mean, can i attach each node to a database? What shall i do? I
am sorry if my question seems naive, but i am just
building
products. Position is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
-Original Message-
From: nadiap [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 19, 2007 8:33 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] multiple databases
Hello,
i am
Hello,
i am a newbie and i would like to ask if it is possible to use sqlite in
order to simulate a wireless network where each node will have each own
database. I mean, can i attach each node to a database? What shall i do? I
am sorry if my question seems naive, but i am just learning
20 matches
Mail list logo