Re: [sqlite] Read-only access which does not block writers

2016-11-28 Thread Nico Williams
On Mon, Nov 28, 2016 at 07:45:16PM +, Howard Chu wrote: > Nico Williams wrote: > >One of the problems with LMDB's locks is that readers need write > >permission to the lock file, IIRC :( but at least it's a separate file. > > We developed an alternate locking protocol for Postfix. It just

Re: [sqlite] Read-only access which does not block writers

2016-11-28 Thread Nico Williams
On Fri, Nov 25, 2016 at 09:08:37AM +0100, Florian Weimer wrote: > I think you misunderstood what I was asking (see the start of the thread). > I need to support Byzantine readers which do not follow the locking > protocol. Based on the documentation, LMDB uses locks to implement MVCC and >

Re: [sqlite] Read-only access which does not block writers

2016-11-28 Thread Howard Chu
Nico Williams wrote: On Fri, Nov 25, 2016 at 09:08:37AM +0100, Florian Weimer wrote: I think you misunderstood what I was asking (see the start of the thread). I need to support Byzantine readers which do not follow the locking protocol. Based on the documentation, LMDB uses locks to implement

Re: [sqlite] newbee questions

2016-11-28 Thread Simon Slavin
On 29 Nov 2016, at 12:22am, Scott Cason wrote: > Please forgive me if I seem a bit ignorant as I am trying to get my feet on > the ground. > Does anyone know where I can get the information necessary to set up Eclipse > CDT for sqlite on a Mac?

[sqlite] newbee questions

2016-11-28 Thread Scott Cason
Please forgive me if I seem a bit ignorant as I am trying to get my feet on the ground. Does anyone know where I can get the information necessary to set up Eclipse CDT for sqlite on a Mac?  I know that Mac users, almost all, use Xcode but I am really wanting to use Eclipse since I can run it

[sqlite] Export database into mySQL

2016-11-28 Thread Igor Korot
Hi, Is it possible to load the SQLite schema from the .dump command into mySQL? Or I will have to do that on per-table? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org