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


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

    daffodil db 2.2 daffodil db 2.2
    daffodil software Ltd.

    Daffodil DB is a SQL-99 specification compliant, capable, reliable, scalable, high-performance, embeddable, lightweight java-based relational database engine (RDBMS).

    Copy Schema for SQL Server 1.08.00 Copy Schema for SQL Server 1.08.00
    OmBelt Solutions

    Copy Schema for SQL Server is an application for Microsoft SQL server that creates a copy for database objects definition: tables, views, triggers, indexes, primary and foreign keys, procedures, etc at the different database on the same or another server.

    Softinabox Script Engine 0.3.0 Build 52 (Beta 3) Softinabox Script Engine 0.3.0 Build 52 (Beta 3)
    Softinabox

    Softinabox Script Engine for Microsoft SQL Server 2000 is a powerful tool that enables you to document any existing database structure and/or data by generating one SQL script.

    VistaDB 5.0.3.1237 VistaDB 5.0.3.1237
    Vista Software

    VistaDB is the #1 embedded database for building robust small to midsize .

    Accuracer Database System 4.03 Accuracer Database System 4.03
    AidAim Software LLC

    Accuracer is a compact, embedded, single-file, multi-user (file-server and client/server) cross-platform BDE replacement database with SQL support based on a new original BDE alternative database engine that supports the almost all TTable, TQuery, TDatabase, TSession, TBatchMove functions and provides some special ones to give you wide functionality and ease of use.

    Copy Schema for SQL Server Professional 1.02.00 Copy Schema for SQL Server Professional 1.02.00
    OmBelt Solutions

    Copy Schema for SQL Server is an application for Microsoft SQL server that creates a copy for database objects definition: tables, views, triggers, indexes, primary and foreign keys, procedures, etc at the different database on the same or another server.

    Absolute Database 7.30 Absolute Database 7.30
    ComponentAce LLC

    Absolute Database - Delphi database system.

    ODBC Database Engine ODBC Database Engine
    ITOS LTD.

    If you plan to use a database developed under Delphi or C++ Builder application and do not like to use BDE (Borland Database Engine) for it, you have gotten into the right place.

    SwisSQL - Data Migration Tool 4.8 SwisSQL - Data Migration Tool 4.8
    AdventNet

    AdventNet SwisSQL offers a complete Data Migration utility that will help the migration of database structures and data across leading databases such as Oracle, IBM DB2, MS-SQL Server, Sybase, SAP DB, and MySQL.