HyperSQL Database Engine HyperSQL Database (HSQLDB) Engine is the leading SQL relational database engine written in Java. It has a JDBC driver and supports a rich subset of ANSI-92 SQL (BNF tree format) plus many SQL:2008 enhancements. It offers a small, fast database engine which offers both in-memory and disk-based tables and supports embedded and server modes. Additionally, it includes tools such as a minimal web server, in-memory query and management tools (can be run as applets) and a number of demonstration examples.

HSQLDB is currently being used as a database and persistence engine in many Open Source Software projects and even in commercial projects and products. In its current version it is extremely stable and reliable. It is best known for its small size, ability to execute completely in memory, its flexibility and speed.

What's new in HyperSQL DataBase

* New core - Fully multithreaded core supports 2PL (two-phased locking) and MVCC (multiversion concurrency control).
* Scalability - Massive LOB store for BLOBs and CLOBs up to multi-gigabyte size, with total storage capacity of 16 terabytes.
* Query optimisation - All query conditions, whether in a JOIN or WHERE clause, are now allocated to an index if possible.
* SQL stored procedures and functions.
* New data types - Support for BIT, BIT VARYING, CLOB, BLOB, INTERVAL according to the SQL Standards.
* New expression types - Complete rewrite of scanner and parser classes. Supports all SQL standard identifier and character string literals (Unicode strings and escapes, etc.).
* New data manipulation language features.
* New data query language features.
* Data definition language enhancements - Supports full syntax of SQL TRIGGER definition for row level triggers using SQL procedure statements (as opposed to Java classes)
* SQL functions - A wide set of SQL Standard functions, including correct type handling and application to all supported types.

HyperSQL Database Engine is designed for:
Win98,WinXP,Win2000

TAGS OF HYPERSQL DATABASE ENGINE

cheat engine , cheats engine5.5 , search engine , cheat engine 5 5 , speech engine , student database , movie database , brush engine , excel database