H2 Database Engine Portable 1.4.196 Beta

H2 in Servers / Other Server Applications

H2 Database Engine Portable screenshot

User Rating: 2.8 (33 votes)

JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported. This is a client/server application, so both a server and a client (a browser) are required to run it.

If you start the server, you may get a security warning from the firewall (if you have installed one). If you don't want other computers in the network to access the application on your machine, you can let the firewall block those connections. The connection from the local machine will still work. Only if you want other computers to access the database on this computer, you need allow remote connections in the firewall.

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)

File Size: 3.900390625 MB License: Freeware Price: FREE
Platform: Windows XP, Windows Vista, Windows Vista x64, Windows 7, Windows 7 x64, Windows 8, Windows 8 x64
Downloads: Total: 295 | This Month: 32 Released: 2018-03-19
H2 Database Engine Portable Similar Software

H2 Database Engine 1.4.199 H2     update

... if you want other computers to access the database on this computer, you need allow remote connections in the firewall. FEATURES: · Fast database engine · Free, source code is included · Supports ... Written in Java · Disk based or in-memory databases · Browser base Console application · JDBC API .... Free download of H2 Database Engine 1.4.199

Database Pooler 0.1.6 Google    

A Java-based database connection pooling utility, which supports time-based expiry, connection ... and he is ready for the show. DatabasePooler can very well be used generically with any servlet classes. The implementation remains much same with no major changes. .... Free download of Database Pooler 0.1.6

software pick   

Portable ORM Designer 3.0.1.1129 Inventic s.r.o.    

ORM Designer is a visual database designing tool with full support of ORM frameworks. ... markup language can be fully supported. Enjoy creating database models fast, comfortable and error free. Give ... a project tree. It's a tree representation of database model with regions, columns, indexes and foreign keys. Project tree is not only another visualization of database model. it can be used to run all .... Free download of Portable ORM Designer 3.0.1.1129

software pick   

Portable RazorSQL 8.2.4 Richardson Software, LLC     update

The Portable RazorSQL application can help you query, update, navigate, and manage all major databases. With Portable RazorSQL, an SQL query tool, SQL editor, and database navigator, you can run SQL scripts, visually edit, ... queries with a query builder tool, and navigate databases with the database navigator. It even comes with .... Free download of Portable RazorSQL 8.2.4

software pick   

Database Workbench Lite for MySQL 4.4.3.0 Upscene Productions    

Database Workbench offers features not found in vendor tools ... · Code & Object Templates Document your databases: · Create diagrams and export or print them · Print schema reports with tables, procedures and more .... Free download of Database Workbench Lite for MySQL 4.4.3.0

Popular Software in Servers / Other Server Applications

PHPRunner 10.1 B32668 Xlinesoft.com     update

Database driven PHP web site with no programming. Free download of PHPRunner 10.1 B32668

software pick   

Portable RazorSQL 8.2.4 Richardson Software, LLC     update

Can help you query, update, navigate, and manage all major databases. Free download of Portable RazorSQL 8.2.4

software pick   

SQLyog Pro x64 13.1.2 Webyog, Inc.     update

Created to provide users with a means of administering MySQL databases. Free download of SQLyog Pro x64 13.1.2

Navicat Lite for Oracle 12.1.17 PremiumSoft CyberTech Ltd.     update

A GUI for Oracle server administration and development. Free download of Navicat Lite for Oracle 12.1.17

software pick   

SQL Examiner Suite 7.1.6.213 TulaSoft, LLC     update

Compares and synchronizes database schemas and contents. Free download of SQL Examiner Suite 7.1.6.213