On Tue, Oct 6, 2015 at 4:39 PM, Simon Slavin <slavins at bigfraud.org> wrote:
> On 6 Oct 2015, at 2:51pm, Dominique Devienne <ddevienne at gmail.com> wrote: > > Is this use case supported by SQLite? > > Whether this works correctly depends on how your Virtual Module is > written. It should be possible to implement this correctly, but I can > imagine a virtual system written quickly which does not take the care to > get this right. > It was not written "quickly" but it was definitely not written with that use-case in mind. And writing a virtual module correctly is not easy. > There are also things Virtual Tables can't do. For instance you cannot > index a Virtual Table using SQL commands. > That's a bit beside the point. Our vtable already provide indexing support. Just not dynamically added indexing via SQL commands. >From Gunter's answer, it seems at least that this use case is possible, even though his is multi-process and DB-file based, I think I see the parallel he's trying to make to our multi-threaded (1 connection / thread) and in-memory DB use case. I just wish I could get a bit more hand-holding on how to proceed, if possible :). As it is not quite crystal clear to me yet. Especially since that vmodule code was written a few years back, so I don't recall the details. Thanks, --DD
