H2 Database
A small relational database in Java, embedded or in memory, the usual choice for tests and prototypes on the JVM. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- H2 Group
- Created by
- Thomas Mueller
- First release
- 2005
- License
- MPL-2.0 or EPL-1.0
- Open source
- Yes
- Pricing
- Free
- Website
- https://h2database.com
- Written in
- Java
- Data model
- Relational
- Storage layout
- Row-oriented
- Workload
- Transactions (OLTP)
- Analytics architecture
- Not an analytics platform
- Query language
- SQL
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Embedded, Server
- Scaling
- Single node
- Create, read, update, delete
- Create: fast (Fast in-memory and embedded inserts); Read: fast (Index lookups inside the same JVM); Update: moderate (MVStore writes new versions); Delete: moderate (Space reclaimed by compaction)