>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 rollback journal in volatile RAM. This saves disk I/O but at the expense of database safety and integrity. If the application using SQLite crashes in the middle of a transaction when the MEMORY journaling mode is set, then the database file will very likely go corrupt. So you can go all the ways from no acid (data and journal in ram), to aci database (syncronous=normal) to fully acid. If you increase cache size enough you'll have the same as a "in memory" database Il 17/ott/2014 14:15 "Prakash Premkumar" <prakash.p...@gmail.com> ha scritto: > 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 : > > http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21631/overview.htm#TTCIN129 > > Does sqlite's in memory db have this feature ? > > Thanks > Prakash > > On Fri, Oct 17, 2014 at 11:54 AM, Prakash Premkumar < > prakash.p...@gmail.com> > wrote: > > > 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 > >> <http://en.m.wikipedia.org/wiki/Integrated_circuit>. RAM is normally > >> associated with volatile < > http://en.m.wikipedia.org/wiki/Volatile_memory> > >> types > >> of memory (such as DRAM <http://en.m.wikipedia.org/wiki/DRAM> memory > >> modules > >> <http://en.m.wikipedia.org/wiki/DIMM>), where stored information is > lost > >> if > >> the power is removed, although many efforts have been made to develop > >> non-volatile RAM chips. > >> > >> Source: Wikipedia > >> Il 17/ott/2014 11:48 "Prakash Premkumar" <prakash.p...@gmail.com> ha > >> scritto: > >> > >> > Hi, > >> > Does in memory database in sqlite have journal files associated with > it > >> ? > >> > If there's a system failure before an in memory database is backed up > ? > >> > Will there be data loss ? Or Can you kindly tell me how sqlite handles > >> this > >> > ? > >> > > >> > > >> > Thanks > >> > Prakash > >> > _______________________________________________ > >> > sqlite-users mailing list > >> > sqlite-users@sqlite.org > >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
