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).

    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.

    Interbase DataPump 3.4 Interbase DataPump 3.4
    Clever Components

    Interbase DataPump will allow you to pump data and migrate from any ADO/BDE/ODBC sources (such as dBase, Paradox, Access, MSSQL, Sybase, Oracle, DB2 etc) and native Interbase/Firebird databases into Interbase/Firebird databases easy, fast and painless with total control over the whole process.

    db4o for .NET 8.0 db4o for .NET 8.0
    db4objects Inc

    db4o (database for objects) is the open source object database, native to .

    SQLyog 5.17 RC4 SQLyog 5.17 RC4
    Webyog Softworks

    SQLyog is an easy to use, compact and very fast graphical tool to manage your MySQL database anywhere in the world.

    PostgreSQL 14.0 PostgreSQL 14.0
    PostgreSQL Global Development

    PostgreSQL is a powerful, open source relational database system.

    SQLyog for Windows 5.2 RC2 SQLyog for Windows 5.2 RC2
    Webyog Softworks Pvt. Ltd.

    SQLyog is a compact Win32 Front End for the MySQL database server.

    AppGini Freeware Version 3.3 AppGini Freeware Version 3.3
    BigProf Software

    AppGini is a tool that accelerates web database applications development.

    StarInix Database Compare 2.0.15 StarInix Database Compare 2.0.15
    StarInix Software

    The StarInix Database Compare application will allow you to compare the structure of two databases and display all the differences between them.

    Free Database Compare 2.0 Free Database Compare 2.0
    StarInix Software

    The Free Database Compare software will allow you to compare the structure of two databases and display all the differences between them.

    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.