hsqldb is a relational database engine written in Java with a JDBC driver that supports a subset of ANSI SQL:1999. It offers a small, fast database engine. Embedded and server modes are available. It includes tools such as a minimal Web server, in-memory query and management tools (which can be run
... [More] as applets or servlets, too), a test framework, PHP compatibility, Eclipse and NetBeans IDE compatibility, and a number of demonstration examples. [Less]
H2 is an SQL database engine written in Java. It is very fast and small (about 1 MB), and supports embedded, server, and clustering modes. A browser based console application is included. Disk based and in-memory tables and databases are supported.
Some of its features are transactions
... [More] isolation, multi-version concurrency (MVCC), table level locking, encrypted databases, fulltext search, and strong security.
The main API is JDBC, however ODBC and others are also supported via PostgreSQL network protocol compatibility. [Less]
benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup.
Metadata constraints are imported from systems and/or configuration files. Data can be imported from and exported to files and systems, anonymized or
... [More] generated from scratch. Domain packages provide reusable generators for creating domain-specific data as names and addresses internationalizable in language and region. It is strongly customizable with plugins and configuration options. [Less]
A tool which transforms a CSV file into another CSV file using a SQL statement.
Also converts CSV to JSON.
Many tools spit out CSV, or are able to as one of output options. Also, in hudson, you can very simply log any values you get into bash like echo " $val2, $val2" >> data.csv, for each
... [More] build or part of a build. So it can be kind of integration tool.
Then you can do quite complex queries – from a flat table, you can actually do subselects and then left joins, which gives you very powerful tool to process the data into something what is ready for plotting as-is – that means, data filtered, cleaned, aggregated, converted, aligned, sorted, etc.
crunch input.csv output.csv "SELECT AVG(duration) AS durAvg FROM (SELECT * FROM indata ORDER BY duration LIMIT 2 OFFSET 6)"` [Less]
MyJSQLView provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in the HSQL MySQL Oracle SQLite and PostgreSQL databases. The application has sorting, searching, and import/export of table data.