Re: [sqlite] SQLite as a meta database

2014-11-06 Thread Andrea Peri
SQLite allow to attach more database at session level. Perhaps here you could find a solution Il 06/nov/2014 09:31 "Hugo Mercier" ha scritto: > Le 05/11/2014 23:08, Simon Slavin a écrit : > > > > On 5 Nov 2014, at 9:28pm, Edward Lau wrote: > > > >>

Re: [sqlite] SQLite as a meta database

2014-11-06 Thread Hick Gunter
: General Discussion of SQLite Database Betreff: Re: [sqlite] SQLite as a meta database Hi, I am intruding into this thread, because I face a similar issue. At our company we have a "proprietary" database storing customer grocery transactions which basically only a C programmer can get to.

Re: [sqlite] SQLite as a meta database

2014-11-06 Thread Hugo Mercier
Le 05/11/2014 23:08, Simon Slavin a écrit : > > On 5 Nov 2014, at 9:28pm, Edward Lau wrote: > >> Maybe some time in the future a version 4 be started that incorporates many >> new advancement in the industry. Version 3 can still be continued for >> backwards compatibility

Re: [sqlite] SQLite as a meta database

2014-11-05 Thread Edward Lau
: Wed, Nov 5, 2014 2:09 pm Subject: Re: [sqlite] SQLite as a meta database On 5 Nov 2014, at 9:28pm, Edward Lau <elau1...@aim.com> wrote: > Maybe some time in the future a version 4 be started that incorporates many new advancement in the industry. Version 3 can still be con

Re: [sqlite] SQLite as a meta database

2014-11-05 Thread Mike Beddo
6 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] SQLite as a meta database Hi, we have extensive experience with respect to the use of virtual tables in SQLite. In fact, the only native SQLite tables we use are in a configuration checking tool. We have "providers" fro

Re: [sqlite] SQLite as a meta database

2014-11-05 Thread Simon Slavin
On 5 Nov 2014, at 9:28pm, Edward Lau wrote: > Maybe some time in the future a version 4 be started that incorporates many > new advancement in the industry. Version 3 can still be continued for > backwards compatibility and version 4 will break some but set the stage for >

Re: [sqlite] SQLite as a meta database

2014-11-05 Thread Edward Lau
ptonector.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wed, Nov 5, 2014 12:14 pm Subject: Re: [sqlite] SQLite as a meta database IIRC there's a GNOME interface to databases, libgda, that works this way. The fundamental problem with using SQLite3 virtual tables

Re: [sqlite] SQLite as a meta database

2014-11-05 Thread Nico Williams
IIRC there's a GNOME interface to databases, libgda, that works this way. The fundamental problem with using SQLite3 virtual tables to access remote/high-latency resources is that the SQLite3 VM and the generated bytecode are very serial, therefore the VM can't make progress on other parts of a

Re: [sqlite] SQLite as a meta database

2014-11-05 Thread Don V Nielsen
Wow! Please keep this discussion up-to-date because it is absolutely fascinating what all of you are doing. Thanks, dvn On Wed, Nov 5, 2014 at 8:36 AM, Hugo Mercier wrote: > Hi, > > Le 05/11/2014 14:16, Hick Gunter a écrit : > > Hi, > > > > we have extensive

Re: [sqlite] SQLite as a meta database

2014-11-05 Thread Hugo Mercier
Hi, Le 05/11/2014 14:16, Hick Gunter a écrit : > Hi, > > we have extensive experience with respect to the use of virtual tables in > SQLite. In fact, the only native SQLite tables we use are in a configuration > checking tool. > > We have "providers" from in-memory indexed tables, CTree (r)

Re: [sqlite] SQLite as a meta database

2014-11-05 Thread Hick Gunter
Mercier [mailto:hugo.merc...@oslandia.com] Gesendet: Mittwoch, 05. November 2014 10:09 An: General Discussion of SQLite Database Betreff: [sqlite] SQLite as a meta database Hi all, Following a first discussion on sqlite-dev that was probably not the right place to post, I've been invited to rep

[sqlite] SQLite as a meta database

2014-11-05 Thread Hugo Mercier
Hi all, Following a first discussion on sqlite-dev that was probably not the right place to post, I've been invited to repost here for a broader audience :) I am a developer on QGIS and I am investigating the possible use of SQLite / Spatialite to extend QGIS relational-oriented features. For