H2 Database Engine Portable 1.3.176 / 1.4.182 Beta
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 Mircea Dragomir on September 19th, 2014
Also available: H2 Database Engine
In a hurry? Add it to your Download Basket!
- 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.
Application descriptionH2 Database Engine Portable is an advanced application designed for SQL users. JDBC and ODBC APIs are supported. Embed...