[sqlite] Any database unique ID across multiple connections ?

2015-09-25 Thread Wade, William
f mapping 128 GUID bits to 128 file bytes, map 16 GUID bytes to 16x256 file bytes). Regards, Bill -Original Message- From: ALBERT Aur?lien [mailto:aurelien.alb...@alyotech.fr] Sent: Thursday, September 24, 2015 4:42 AM To: 'sqlite-users at mailinglists.sqlite.org' Subject: [sqlite] An

[sqlite] Any database unique ID across multiple connections ?

2015-09-24 Thread Scott Hess
On Thu, Sep 24, 2015 at 4:56 AM, ALBERT Aur?lien < aurelien.albert at alyotech.fr> wrote: > @ Stephan Beal > > "Every instance of a :memory: db is a unique instance, so you cannot have > multiple connections to a single :memory: db." > > >> I know, this is one of the various reasons that made my

[sqlite] Any database unique ID across multiple connections ?

2015-09-24 Thread Kees Nuyt
On Thu, 24 Sep 2015 11:42:27 +0200, ALBERT Aur?lien wrote: >Hi, > >I'm using SQLite C API and my application use multiple databases, each >database having multiple connections. >I need to identify which connection use the same database as another >connection. >For the moment, I use the

[sqlite] Any database unique ID across multiple connections ?

2015-09-24 Thread ALBERT Aurélien
@ Stephan Beal "Every instance of a :memory: db is a unique instance, so you cannot have multiple connections to a single :memory: db." >> I know, this is one of the various reasons that made my solution not really >> ideal @ Simon Slavin "There's a PRAGMA for storing and retrieving a

[sqlite] Any database unique ID across multiple connections ?

2015-09-24 Thread Stephan Beal
On Thu, Sep 24, 2015 at 11:42 AM, ALBERT Aur?lien < aurelien.albert at alyotech.fr> wrote: > (for example, if one day I need the same about ":memory:" databases, bad > things are gonna to happen) > Every instance of a :memory: db is a unique instance, so you cannot have multiple connections to

[sqlite] Any database unique ID across multiple connections ?

2015-09-24 Thread ALBERT Aurélien
Hi, I'm using SQLite C API and my application use multiple databases, each database having multiple connections. I need to identify which connection use the same database as another connection. For the moment, I use the absolute database filename as an "unique database identifier", and I

[sqlite] Any database unique ID across multiple connections ?

2015-09-24 Thread Simon Slavin
On 24 Sep 2015, at 10:42am, ALBERT Aur?lien wrote: > I need to identify which connection use the same database as another > connection. > > For the moment, I use the absolute database filename as an "unique database > identifier", and I store this information with my "sqlite3*" connection