H2 is an SQL database engine written in Java that implements the JDBC API. Embedded, server, and clustering modes are available. A browser based console application is included. The database has strong security features. Disk based and in-memory databases and tables are supported.
Tags | Database Database Engines/Servers Java |
---|---|
Licenses | MPL |
Operating Systems | OS Independent |
Implementation | Java SQL |
Release Notes: This beta version fixes important bugs that were found in the first 1.4 beta release.
Release Notes: This beta version uses a the new storage engine (MVStore) by default, which should be more robust and SSD-friendly.
Release Notes: The H2 console tool has been improved. The new storage engine MVStore and the spatial index have been improved. An important bug that resulted in a NullPointerException was fixed.
Release Notes: The spatial features and compatibility with other databases have been improved. The new MVStore mechanism has been enhanced, and is now beta quality.
Release Notes: The spatial index and data type have been improved. The new storage subsystem (MVStore) is now beta quality.
I have been grappling with MySQL for a project and came across this. If it works like it says it does then a pure Java solution will mean no MySQL install is required which is great. Also, I have a need for an in-memory function for data collection so, if I can have two databases one fast (in Memory) and the other backing store (on disk) running at the same time then I will be a hero!