Re: [sqlite] Inmemory database in sqlite

On 17 Oct 2014 at 10:39, Prakash Premkumar wrote: > So the approach where we open the db with ":memory:" keyword does not > provide durability. Why is that any sort of surprise? What you're opening is a database called ":memory:". The string ":memory:" is the name of

Re: [sqlite] Inmemory database in sqlite

On 17 Oct 2014, at 10:39am, Prakash Premkumar wrote: > So the approach where we open the db with ":memory:" keyword does not > provide durability . > Only by increasing the cache size can we make db act as an inmemory db with > durablity. That's the conclusion right ?

Re: [sqlite] Inmemory database in sqlite

Thanks Alessandro. So the approach where we open the db with ":memory:" keyword does not provide durability . Only by increasing the cache size can we make db act as an inmemory db with durablity. That's the conclusion right ? Thanks Prakash On Fri, Oct 17, 2014 at 2:53 PM, Alessandro Marzocchi

Re: [sqlite] Inmemory database in sqlite

>From memsql site: These features can be tuned all the way from synchronous durability (every write transaction is recorded on disk before the query completes) to purely in-memory durability (maximum sustained throughput on writes). >From sqlite website: The MEMORY journaling mode stores the

Re: [sqlite] Inmemory database in sqlite

if it uses disk, it can be persistant. If it's in memory, it's only as reliable as the power to the computer. If it's in memory and cached to disk, it's really a disk database. Just because someone says 'we have a memory database, that's the primary and disk is secondary' it's still a disk

Re: [sqlite] Inmemory database in sqlite

Hi, Let's take the case of MemSQL for example. It is an in memory database and it supports durability: Link : http://developers.memsql.com/docs/3.1/faq.html#c3-q1 And Oracle's In memory db TimesTen also provide durability: Link :

Re: [sqlite] Inmemory database in sqlite

Is features like WAL (https://www.sqlite.org/wal.html) not available for in memory databases ? Thanks Prakash On Fri, Oct 17, 2014 at 11:23 AM, Alessandro Marzocchi < alessandro.marzoc...@gmail.com> wrote: > Today, random-access memory takes the form of integrated circuits >

Re: [sqlite] Inmemory database in sqlite

Today, random-access memory takes the form of integrated circuits . RAM is normally associated with volatile types of memory (such as DRAM memory modules

Re: [sqlite] Inmemory database in sqlite

On 10/17/2014 1:00 AM, Prakash Premkumar wrote: I mean , I have written INSERT statements in to the inmemory database and a system failure occurs before I dump the data to a file using the SQLite Backup API, will there be a data loss ? Of course. There is no assurance of durablity for in

Re: [sqlite] Inmemory database in sqlite

Thanks for your reply Igor, I mean , I have written INSERT statements in to the inmemory database and a system failure occurs before I dump the data to a file using the SQLite Backup API, will there be a data loss ? There is no assurance of durablity for in memory databases right ? Thanks

Re: [sqlite] Inmemory database in sqlite

On 10/17/2014 12:48 AM, Prakash Premkumar wrote: Does in memory database in sqlite have journal files associated with it ? No. The journal is in memory, too. If there's a system failure before an in memory database is backed up ? What do you mean, backed up? Backed up where and by whom? --