[vox-tech] hsqldb

[Harold Lee]

I've used HSQLDB for unit testing in the past. I wrote JUnit test
cases that access an in-memory HSQLDB database (which is created with
sample data each time the unit tests are run): very fast, and you
don't need to run a separate database server for your tests. Works
great!

Harold

On Tue, Mar 22, 2011 at 10:42 AM, Brian Lavender <brian at brie.com> wrote:
> Many of you have probably used HSQLDB without realizing it.
> OpenOffice uses it!
>
> Here is some info on HSQLDB. A lot of tutorials for Java use HSQLDB, but
> you can use HSQLDB with PERL too. You can start an HSQLDB server with a
> single command. The following will start a database with called EMPLOYEE.
>
> java -cp <path to>/hsqldb.jar org.hsqldb.Server -database.0 file:db/employee -dbname.0 EMPLOYEE
>
> The data for EMPLOYEE will be stored in the sub-directory db.
>
> HSQLDB comes with a nice GUI tool too!
>
> java -cp <path to>/hsqldb.jar org.hsqldb.util.DatabaseManager -driver org.hsqldb.jdbcDriver -url jdbc:hsqldb:hsql://localhost/empoloyee -user sa
>
> You can download hsqldb from the below site. Thus far, I have used 1.8.0 version. There is a new version,
> but I believe it works a bit different. But,... it probably comes with more features.
> http://www.hsqldb.org
>
> Here is some documentation using HSQLDB with PERL.
> http://hsqldb-ber.sourceforge.net/
>
> brian
> --
> Brian Lavender
> http://www.brie.com/brian/
>
> "There are two ways of constructing a software design. One way is to
> make it so simple that there are obviously no deficiencies. And the other
> way is to make it so complicated that there are no obvious deficiencies."
>
> Professor C. A. R. Hoare
> The 1980 Turing award lecture
> _______________________________________________
> vox-tech mailing list
> vox-tech at lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox-tech
>