H2 database
| H2 database
|
|
|---|---|
|
|
| Basic data
|
|
| developer | Thomas Müller |
| Publishing year | December 2005 |
| Current version |
1.4.200 ( October 14, 2019 ) |
| operating system | Platform independence |
| programming language | Java |
| category | Database management system |
| License | Eclipse Public License , Mozilla Public License |
| German speaking | No |
| www.h2database.com | |
The H2 Database Engine , H2 for short , is a relational database management system written in the Java programming language . The system can either be embedded directly into Java applications as a JAR or operated as a server . As interfaces for addressing operated with the system databases are SQL and JDBC are available.
H2 is available as open source software for the Java platform .
history
H2 has been developed since 2004 by Thomas Müller, a Swiss software developer who previously also created Hypersonic SQL , the development of which was later continued as HSQLDB . H2 was first released in December 2005. The name stands for "Hypersonic 2"; however, it is a completely new development.
Functions
H2 supports a subset of the SQL standard and, among other things, masters referential integrity , transactions , clustering , data compression , encryption and SSL . A full text search is implemented. Special compatibility modes for DB2 , Apache Derby , HSQLDB , Microsoft SQL Server , MySQL , Oracle or PostgreSQL can optionally be activated. Via the PostgreSQL compatibility, the system can also be addressed via ODBC .
Due to its broad compatibility, H2 is often used as an alternative to the database systems listed, for example if problems arise with the previously selected system or a leaner system such as H2 is sufficient.
Web links
Individual evidence
- ↑ H2 Database Engine . (accessed on November 29, 2019).
- ↑ Release 1.4.200 . October 14, 2019 (accessed April 9, 2020).
- ↑ License . (English, accessed July 28, 2018).
- ↑ License . (English, accessed July 28, 2018).
- ↑ h2database.com: History of this Database Engine .
- ↑ The Codist: Write Your Own Database, Again: An Interview With The Author Of H2, Thomas Mueller .
- ↑ h2database.com: ODBC Driver .