Re: [sqlite] Protecting databases

2016-10-07 Thread Darren Duncan
On 2016-10-07 10:46 PM, Damien Sykes-Lindley wrote: Hi there, My name is Damien Lindley, and I am, among other things, an independent, hobbiest programmer. I have been blind since birth and thus all my computer work relies on screenreader software and keyboard. I have only just come through

[sqlite] Protecting databases

2016-10-07 Thread Damien Sykes-Lindley
Hi there, My name is Damien Lindley, and I am, among other things, an independent, hobbiest programmer. I have been blind since birth and thus all my computer work relies on screenreader software and keyboard. I have only just come through the brink of scripting into compiled programming and so

Re: [sqlite] Parallel access to read only in memory database

2016-10-07 Thread Keith Medcalf
Machines with >100GB of RAM have been commonplace for a several years. These days, 384 GB is quite common. Even 1 TB is not a "special build" anymore -- you can buy them "off the shelf" from Dell ... (Dell no longer makes custom machines but only sells fixed configurations off the boat

Re: [sqlite] Parallel access to read only in memory database

2016-10-07 Thread Stephen Chrzanowski
(My two cents) I just setup two brand new machines in our Colo for ESX. Both machines had 256gig of memory. Not unheard of in server situations. ;) On Fri, Oct 7, 2016 at 4:48 PM, Simon Slavin wrote: > > On 7 Oct 2016, at 9:37pm, Daniel Meyer wrote: >

Re: [sqlite] Parallel access to read only in memory database

2016-10-07 Thread Simon Slavin
On 7 Oct 2016, at 9:37pm, Daniel Meyer wrote: > We have database files that are on the order of 100GB [...] in memory You have 100GB memory ? Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Parallel access to read only in memory database

2016-10-07 Thread Joe Mistachkin
Daniel Meyer wrote: > > How can we allow many reader threads on an in memory, write once read many > times database and achieve multi-core performance? Is this possible with > sqlite? > Have you tried using the URI "file::memory:?cache=shared" with one of the sqlite3_open*() C APIs? Further

[sqlite] Parallel access to read only in memory database

2016-10-07 Thread Daniel Meyer
We are interested in using sqlite as a read only, in memory, parallel access database. We have database files that are on the order of 100GB that we are loading into memory. We have found great performance when reading from a single thread. We need to scale up to have many parallel reader