H2database

CREDITS TO - http://www.h2database.com/html/main.html

h2 is a java-based in-memory database.

installation:

1>download from here

2>unzip it

3>cd to bin folder under extracted folder

4>sh h2.sh ##OR use [sh h2.sh -webAllowOthers] to enable access to others via web browser.

above command will automatically start web console on your browser.

Working within console is quite simple. sample basic commands are as follows:

HELP; ##Lists all commands and their possible parameters/usage

DROP TABLE IF EXISTS rv_test;

CREATE TABLE rv_test(id INT PRIMARY KEY, f_name VARCHAR(20), l_name VARCHAR(20));

SELECT * FROM rv_test;

INSERT INTO rv_test VALUES(1, 'Rohit', 'verma');

INSERT INTO rv_test VALUES(2, 'Rahul', 'verma'),(3, 'Ajit', 'verma');

INSERT INTO rv_test(f_name, l_name) VALUES('Amit', 'singh');##This fails as value into id column was not supplied. Let's make id as auto_increment.

ALTER TABLE rv_test ALTER COLUMN id INT AUTO_INCREMENT;

UPDATE rv_test SET l_name='sharma' WHERE f_name='Ajit';

SELECT f_name FROM rv_test WHERE l_name = 'singh';

Using H2 to store/read data from your app example: spring-jdbc