H2 Database Engine 0.9

H2 Database Engine 0.9 Screenshot H2 is an SQL database engine written in Java (but also available as a native binary).

Developer:   H2
      software by H2 →
Price:  0.00
License:   Freeware
File size:   0K
Language:   
OS:   Windows Vista (?)
Rating:   0 /5 (0 votes)

H2 is an SQL database engine written in Java (but also available as a native binary). JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported.H2 Database Engine is a web based java database engine.

H2 Database Engine features
  • Fast database engine
  • Free, source code is included
  • Supports standard SQL
  • Written in Java
  • Disk based or in-memory databases
  • Browser base Console application
  • JDBC API
  • Limited ODBC support
  • Embedded and client/server (network) mode
  • High availablility support (clustering / failover)
  • Wide range of data types including large objects (BLOB/CLOB)
  • Strong security features (SSL, users, roles, encrypted files)
  • Multiple connections, table level locking
  • Cost based optimizer, using a genetic algorithm for complex queries
  • Transaction support (serializable transaction isolation)
  • Zero-administration, automatic recovery
  • Large resultset, external sorting
  • Scrollable and updatable resultset support
  • Read only views and inline views
  • Inner and outer joins, subqueries
  • Many functions already built-in
  • Triggers and Java functions / stored procedures
  • Referential integrity / foreign key constraints with cascade, check constraints
  • Multiple schema support
  • Compatibility modes for HSQLDB, MySQL and PostgreSQL
  • Sequence and autoincrement columns
  • Well tested (high code coverage, randomized stress tests)
  • Small footprint (smaller than 1 MB)
  • Uses a small number of database files
  • Can be compiled to native code using GCJ
  • Primary keys, multiple index types (b-tree, linear hash, tree, hash)
  • ORDER BY, GROUP BY, HAVING, UNION, LIMIT
  • Information Schema
  • Multiple connections
  • Collation support
  • EXPLAIN PLAN support
  • The database can generate SQL script files
  • Support for linked tables, and a built-in virtual 'range' table
  • Automatic re-compilation of prepared statements
  • Sophisticated trace options
  • Low memory requirements
  • Easy to understand exception messages
  • Standard handling of NULL values
  • Multilanguage console application (at this time, English and German)

    tags database engine  console application  multiple connections  embedded and  

    H2 Database Engine 0.9 screenshot


    Download H2 Database Engine 0.9

     Download H2 Database Engine 0.9


    Authors software
    Similar software

    H2 Database Engine 0.9 H2 Database Engine 0.9
    H2

    H2 is an SQL database engine written in Java (but also available as a native binary).

    Universal JDBC Tree Navigator 1.1 beta Universal JDBC Tree Navigator 1.1 beta
    CyLog Software

    JDBC Tree Navigator is a Java-Swing application designed to help navigating tree structures in database tables.

    PKLite SQL Client 2.0 Beta 3 PKLite SQL Client 2.0 Beta 3
    Pklite.sourceforge.net

    PKLite SQL Client is an Open Source Java SQL Client that can connect to any JDBC compliant database.

    DatAdmin 0.7.8 DatAdmin 0.7.8
    DatAdmin

    DatAdmin is grafical database interface for Windows.

    Sheelapps DB Explorer 1.0.1 Sheelapps DB Explorer 1.0.1
    Sheelapps

    DB Explorer is a useful and easy-to-use application which lets you to manage any JDBC (Java Database Connectivity) compliant database.

    Google Web APIs 1.0 Google Web APIs 1.0
    Google Code

    Google Web APIs contains everything you need to write programs using Google Web APIs, including: A WSDL file you can use with any development platform that supports web services.

    SmallSQL Database 0.15 SmallSQL Database 0.15
    Volker Berlin

    SmallSQL is a free and pure Java DBMS, a relational database for Java desktop applications.

    Universal Password Manager 1.0 Universal Password Manager 1.0
    Adrian Smith

    UPM is a very easy to use cross platform password manager written in Java.

    SQuirrel SQL Client 2.4.1 SQuirrel SQL Client 2.4.1
    Colin Bell

    SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, issue SQL commands and browse the data in tables.

    Sequel 2.0 Sequel 2.0
    Ing. Tomas Koutny

    Sequel is an object-oriented wrapper for ODBC implementation for Win32 platforms.

    Other software in this category

    AMRandom 4.3 AMRandom 4.3
    ESB Consultancy

    This aims to supply a Borland Delphi translation of Alan Miller`s Random Module for FORTRAN-90.

    FreeSMTP.Net 1.0 FreeSMTP.Net 1.0
    Quiksoft Corporation

    FreeSMTP.

    Redcoal Mobile Internet Developer API (MIDA) 5.0 Redcoal Mobile Internet Developer API (MIDA) 5.0
    Redcoal

    Enable your web sites, intranets or applications to send and receive SMS messages to and from 130 countries.

    ReportLab PDF Library 1.17 ReportLab PDF Library 1.17
    Dinu Gherman

    ReportLab PDF Library - Package for high-quality dynamic personalized PDF documents in real-time & high volumes from any data sources.

    VB6 Setup Program with Skin 1.2 VB6 Setup Program with Skin 1.2
    visual-basic.com.ar

    You can change your default VB6 setup program with this improved setup program: VB6 Setup Program with Skin.