[Interest] sqlite

Jason H jhihn at gmx.com
Mon Apr 20 16:50:45 CEST 2015


> Sent: Friday, April 17, 2015 at 7:24 PM
> From: "Thiago Macieira" <thiago.macieira at intel.com>
> To: interest at qt-project.org
> Subject: Re: [Interest] sqlite
>
> On Friday 17 April 2015 21:57:44 Jason H wrote:
> > I've used SQLite as a table store pretty extensively and I can say:
> > 
> > 1. It works as advertised. It allows multiple processes to access the same
> > database safely. Threads no. Processes yes. 
> > 2. Multiple process performance
> > is low. It may me adequate if there is not a lot of concurrency, just a lot
> > of different processes that occasionally write. 
> > 3. Multiple process
> > performance is not just low, it is terrible. As far as I can tell there is
> > no elegant concurrency, just locking. 
> > 4. The OP could use a table as a
> > notification queue.
> 
> IIRC, Chrome/Chromium/Blink uses a shared SQLite as the backend for 
> transmitting certain information between the multi-process architecture it 
> has.

It wouldn't surprise me at all. Maybe they use the special :memory: database? I'm not sure if that uses mmaped files, but if so, it could be a very cool IPC.



More information about the Interest mailing list