Projects

HyperSQL Database Engine

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]

SQuirreL SQL Client

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

H2 Database Engine

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]

Gnuaccounting

A java financial accounting application to write invoices (and more) and do double-entry bookkeeping. It's written in SWT and embeds OpenOffice.org and HSQLDB or MySQL. It deploys HBCI Online Banking integration and, Winston-Export and KTimeTracker and Taskcoach imports.

LiquiBase

LiquiBase is a DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control. LiquiBase aims to provide a solution that: * ... [More] Supports merging of changes from multiple developers * Works well with code branches * Allows you to manage production data as well as various test datasets * Works in an environment where multiple machines will be attempting to migrate the database concurrently * Supports automated change-applying or generation of SQL scripts that can be approved and applied by a DBA * Supports rolling back changes * Database "diff" tool [Less]

Cayenne

claimed by Apache Software Foundation

Apache Cayenne is an open source persistence framework licensed under the Apache License, providing object-relational mapping (ORM) and remoting services. With a wealth of unique and powerful features, Cayenne can address a wide range of persistence needs. Cayenne seamlessly binds one or more ... [More] database schemas directly to Java objects, managing atomic commit and rollbacks, SQL generation, joins, sequences, and more. With Cayenne's Remote Object Persistence, those Java objects can even be persisted out to clients via Web Services. Or, with native XML serialization, objects can be even further persisted to non-Java clients - such as an Ajax-capable browser. [Less]

SchemaSpy

SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc.) and can identify Ruby on Rails as well as other implied relationships.

jOOQ

jOOQ effectively combines complex SQL, typesafety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL.

SymmetricDS

SymmetricDS is web-enabled, database independent, data synchronization/replication software. It supports bi-directional and partial synchronization across heterogeneous databases in near real time. The software was designed to scale for a large number of databases, work across low-bandwidth ... [More] connections, and withstand periods of network outage. It was first built to replicate changes between "Retail Store" (POS) databases and a "Corporate" central database. [Less]

benerator

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]