Re: [sqlite] Multiple databases in one DB connection. How to let BEGIN TRANSACTION..COMMIT apply to only one of them?

2011-10-26 Thread Frank Missel
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

[sqlite] Multiple databases in one DB connection. How to let BEGIN TRANSACTION..COMMIT apply to only one of them?

2011-10-26 Thread Simon L
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

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Dariusz Matkowski
[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

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Rich Shepard
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

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Dariusz Matkowski
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

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Rich Shepard
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

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Dariusz Matkowski
- 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

Re: [sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Rich Shepard
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

[sqlite] Multiple databases vs. Multiple tables.

2010-10-26 Thread Dariusz Matkowski
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

Re: [sqlite] Multiple databases

2008-03-02 Thread Dan
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

Re: [sqlite] Multiple databases

2008-03-02 Thread Kee Wee
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

Re: [sqlite] Multiple databases

2008-01-23 Thread drh
"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

Re: [sqlite] multiple databases

2007-09-20 Thread nadiap
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

Re: [sqlite] multiple databases

2007-09-20 Thread Kees Nuyt
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

Re: [sqlite] multiple databases

2007-09-20 Thread nadiap
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

Re: [sqlite] multiple databases

2007-09-19 Thread Gerry Snyder
[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

Re: [sqlite] multiple databases

2007-09-19 Thread John Stanton
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

Re: [sqlite] multiple databases

2007-09-19 Thread John Stanton
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

RE: [sqlite] multiple databases

2007-09-19 Thread Samuel R. Neff
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

[sqlite] multiple databases

2007-09-19 Thread nadiap
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