H2 Database Engine Portable 1.3.176 / 1.4.182 Beta

Create a proper environment suitable for storing important data using standard SQL with the help of this handy software application
A database is responsible for storing large quantities of data in an organized manner so that terminals used by the end user provide fast and accurate result. A certain level of programming knowledge is required, with various applications like H2 Database Engine Portable transforming all your code into a suitable environment for data storage.

A simple workspace provided

The application does not come equipped with its own interface, but rather runs all its features through a web browser. Anything you use can get the job done, so picking a browser is not something to worry about.

What's more, you need to connect to a local server you further use in your project, so take caution when providing the necessary details. The following step throws you directly into action. Most space is taken up by the text field which is where most code writing is done. A few helpful details are displayed to give you a quick start.

Quick access to common commands

In terms of writing, if you're familiar with standard SQL or JDBC API languages then you have no accommodation problems. Unfortunately, there's no implemented syntax highlighter to further aid. On the other hand, a side panel provides quick access to a handful of commands such as columns, indexes, rights, tables, views and more, you can insert with a single mouse click.

Fast connection with the server

The maximum numbers of rows can be set using a function located in the upper toolbar where you also manage to find options to execute either the whole script or a selected portion. An auto complete mode is available to ease your work a little. When connected, you can easily commit all data to the server, or choose to disconnect for testing purposes.

To end with

All things considered, H2 Database Engine Portable might not seem like an advanced database utility, but it can come in handy, especially if you're on the move. It can easily be kept on a removable storage device, giving you the possibility to work from anywhere you are as long as you have Internet access and a web browser at hand.

Reviewed by on September 19th, 2014

Also available: H2 Database Engine


last updated on:
October 17th, 2014, 14:09 GMT
file size:
7.3 MB
price:
FREE!
developed by:
H2
license type:
Freeware
operating system(s):
Windows All
category:
C: \ Portable Software \ Internet \ Servers

FREE!

In a hurry? Add it to your Download Basket!

softpedia rating

3.5/5

user rating 1

5.0/5
 

0/5

8 Screenshots
H2 Database Engine Portable - H2 Database Engine Portable is a powerful SQL database written in Java.H2 Database Engine Portable - H2 Database Engine Portable will enable you to run SQL queries.H2 Database Engine Portable - This is the way H2 Database Engine Portable will execute your SQL statements.H2 Database Engine PortableH2 Database Engine PortableH2 Database Engine PortableH2 Database Engine PortableH2 Database Engine Portable
What's New in version 1.4.182 Beta
  • MVStore: improved error messages and logging; improved behavior if there is an error when serializing objects.
  • OSGi: the MVStore packages are now exported.
  • With the MVStore option, when using multiple threads that concurrently create indexes or tables, it was relatively easy to get a lock timeout on the "SYS" table.
  • When using the multi-threaded option, the exception "Unexpected code path" could be thrown, specially if the option "analyze_auto" was set to a low value.
read full changelog
 

Application description

H2 Database Engine Portable is an advanced application designed for SQL users. JDBC and ODBC APIs are supported. Embed...

Add your review!

SUBMIT