DataBase - Difference between In-Memory Database, Normal DataBase & Caching | In Memory Database #2

Cache - By definition means it is stored in memory. Any data stored in memory (RAM) for faster access is called cache. ...
In Memory Database - It has all the features of a Cache plus come processing/querying capabilities.

how would you recover your data after a machine with an in-memory database reboots or crashes?
Well, with just an in-memory database, there’s no way out. A machine is down the data is lost. Forget about it.

In-memory databases don’t use disk for non-change operations.
In-memory databases do use disk for data change operations, but they use it in the fastest possible way.
The main reason to keep a database in-memory is performance.

Small footprint − Around 1.5MB jar file size -- HSQL DATABASE

Additional Link : https://medium.com/@denisanikin/what-an-in-memory-database-is-and-how-it-persists-data-efficiently-f43868cff4c1

Maven Repo for H2 Database : https://mvnrepository.com/artifact/com.h2database/h2

Maven Repo for HSQL Database : https://mvnrepository.com/artifact/hsqldb/hsqldb

You can use traditional SQL query for in-Memory database.

GitHub Project Link : https://github.com/admindebu/In-Memory-DataBase-Rest-API.git

In Memory DataBase Wiki Pedia:

https://en.wikipedia.org/wiki/List_of_in-memory_databases

https://en.wikipedia.org/wiki/In-memory_database

if you like my video, please subscribe to my channel and share the video

Follow me on FaceBook: https://www.facebook.com/TechTalkDebu
Instagram: techtalk_debu
and LinkedIn: https://www.linkedin.com/in/debu-paul

Thanks & Regards,
Debu Paul