Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread Igor Tandetnik
In case it helps, QSQLiteDriver has a constructor taking sqlite3* handle. You could open the database with sqlite3_open_v2, then wrap a QSQLiteDriver instance around it. Igor Tandetnik On 5/28/2013 9:49 AM, rol...@logikalsolutions.com wrote: Correct. We must not drop below the Qt interface

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread Igor Tandetnik
Well, in this case, I'm afraid you are sadly out of luck. I suppose you could lobby Qt to expose those features, or you could lobby Linux Mint 13 KDE to distribute SQLite library built with SQLITE_USE_URI option. However, I can't help but wonder: how come it's OK to use a SQLite-specific featu

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread rol...@logikalsolutions.com
There is/was additional documentation which stated multiple threads within the same process could open that same connection and share the cache. I'm not talking about program A sharing a memory database with Program B, but rather threads 32, 55, 126, and 84 of Program A being able to open and clos

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread rol...@logikalsolutions.com
Correct. We must not drop below the Qt interface level. > On May 28, 2013 at 7:29 AM Igor Tandetnik wrote: > > > On 5/28/2013 8:05 AM, Roland Hughes wrote: > > Your response doesn't say anything useful. > > > > When *WE* tell you the kit required for the project, it is just that, the > > kit req

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread Keith Medcalf
i ribbon campaign against html e-mail /\ www.asciiribbon.org > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Kevin Benson > Sent: Tuesday, 28 May, 2013 06:31 > To: General Discussion of SQLite Databas

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread Kevin Benson
On Tue, May 28, 2013 at 8:31 AM, Kevin Benson wrote: > On Tue, May 28, 2013 at 7:57 AM, Roland Hughes < > rhug...@cincinnati-test.com> wrote: > >> ":memory:" is a one-shot wonder. The example from the documentation >> allowed multiple threads to use the _same_ in memory database. >> > > > Am I no

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread Kevin Benson
On Tue, May 28, 2013 at 7:57 AM, Roland Hughes wrote: > ":memory:" is a one-shot wonder. The example from the documentation > allowed multiple threads to use the _same_ in memory database. > Am I not understanding the explanation on that page correctly? My understanding would be that "file:mem

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread Igor Tandetnik
On 5/28/2013 8:05 AM, Roland Hughes wrote: Your response doesn't say anything useful. When *WE* tell you the kit required for the project, it is just that, the kit required for the project. Given the rules and regulations for this project the kit must be as is without hacks. The target will

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread Simon Slavin
On 28 May 2013, at 1:05pm, Roland Hughes wrote: > Your response doesn't say anything useful. > > When *WE* tell you the kit required for the project, it is just that, the kit > required for the project. Given the rules and regulations for this project > the kit must be as is without hacks.

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread Roland Hughes
ehalf of Richard Hipp Sent: Friday, May 24, 2013 1:27 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Correct way to open multiple in memory databases On Fri, May 24, 2013 at 1:14 PM, Roland Hughes wrote: > I have whatever came with Qt 4.8.x and Linux Mint 13 KDE > That d

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-28 Thread Roland Hughes
___ From: sqlite-users-boun...@sqlite.org on behalf of Simon Slavin Sent: Friday, May 24, 2013 4:11 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Correct way to open multiple in memory databases On 24 May 2013, at 7:06pm, Stephan Beal wrote: > On Fri, May 24,

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-24 Thread Simon Slavin
On 24 May 2013, at 7:06pm, Stephan Beal wrote: > On Fri, May 24, 2013 at 5:03 PM, Roland Hughes > wrote: > >> "file:memdb1?mode=memory&cache=shared", >> >> It ends up creating files in the executable directory. > > Have you tried using ":memory:"? Each instance of an in-memory db opened > tha

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-24 Thread Stephan Beal
On Fri, May 24, 2013 at 5:03 PM, Roland Hughes wrote: > "file:memdb1?mode=memory&cache=shared", > > It ends up creating files in the executable directory. > Have you tried using ":memory:"? Each instance of an in-memory db opened that way is unique, despite the non-unique name: sqlite> attach ':

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-24 Thread Richard Hipp
On Fri, May 24, 2013 at 1:14 PM, Roland Hughes wrote: > I have whatever came with Qt 4.8.x and Linux Mint 13 KDE > That doesn't tell us anything useful. What actions have *YOU* taken to enable URI filenames. If you haven't taken any actions, then (as described in the documentation) URI filename

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-24 Thread Roland Hughes
I have whatever came with Qt 4.8.x and Linux Mint 13 KDE From: sqlite-users-boun...@sqlite.org on behalf of Richard Hipp Sent: Friday, May 24, 2013 11:14 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Correct way to open multiple in

Re: [sqlite] Correct way to open multiple in memory databases

2013-05-24 Thread Richard Hipp
On Fri, May 24, 2013 at 11:03 AM, Roland Hughes wrote: > All, > > I'm looking for the correct way to build a string (within Qt) to open > multiple in memory databases. The example here: > > http://www.sqlite.org/inmemorydb.html > > Does not appear to work. > > "file:memdb1?mode=memory&cache=shar

[sqlite] Correct way to open multiple in memory databases

2013-05-24 Thread Roland Hughes
All, I'm looking for the correct way to build a string (within Qt) to open multiple in memory databases. The example here: http://www.sqlite.org/inmemorydb.html Does not appear to work. "file:memdb1?mode=memory&cache=shared", It ends up creating files in the executable directory. Thanks, Ro