Softpedia
 


LINUX CATEGORIES:



GLOBAL PAGES >>
NEWS ARCHIVE >>
SOFTPEDIA REVIEWS >>
MEET THE EDITORS >>
WEEK'S BEST
  • BackTrack 5 R2
  • Wine 1.4 / 1.5.5
  • Mozilla Firefox 12...
  • Ubuntu 11.04
  • Angry Birds 1.1.2.1
  • Ubuntu 10.04.4 LTS
  • Linux Kernel 3.4
  • Ubuntu Manual 10.10
  • Adobe Flash Player...
  • Pidgin 2.10.4
  • Home > Linux > Database > Database Engines

    H2 Database Engine 1.2.147 / 1.3.167

    Download button

    Downloads: 4,071  View global page NEW!  Tell us about an update
    User Rating:
    Rated by:
    Good (3.5/5)
    26 user(s)
    Developer:

    License / Price:

    Last Updated:

    Category:
    H2 | More programs
    Eclipse Public License / FREE
    May 24th, 2012, 09:25 GMT [view history]
    ROOT / Database / Database Engines

     Read user reviews (0)  Refer to a friend  Subscribe

    H2 Database Engine description

    A free SQL database engine writen in Java

    H2 Database Engine is a free SQL database engine writen in Java.

    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.


    Product's homepage

    Here are some key features of "H2 Database Engine":

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

    Requirements:

    · Java 2 Standard Edition Runtime Environment

    What's New in This Release: [ read full changelog ]

    · Updating a result set in a trigger is now supported.

      


    TAGS:

    database engine | SQL database | database API | H2 | database | engine



    HTML code for linking to this page:


    Go to top

    WindowsGamesDriversMacLinuxScriptsMobileHandheldNews

    SUBMIT PROGRAM   |   ADVERTISE   |   GET HELP   |   SEND US FEEDBACK   |   RSS FEEDS   |   UPDATE YOUR SOFTWARE   |   ROMANIAN FORUM