Projects

Apache Derby

claimed by Apache Software Foundation

Apache Derby, an Apache DB subproject, is a relational database implemented entirely in Java. Some key advantages include a small footprint ( about 2 megabytes for the base engine and embedded JDBC driver) and being based on the Java, JDBC, and SQL standards. Derby provides an embedded JDBC ... [More] driver that lets you embed Derby in any Java-based solution. It also supports the more familiar client/server mode with the Derby Network Client JDBC driver and Derby Network Server. Derby is easy to install, deploy, and use. Derby is also distributed as IBM Cloudscape and Sun Java DB. [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.

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]

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.

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]

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]

dbclient

Simple yet Powerful Jdbc Tool for browsing Relational databases. DBClient provides both a convenient SQL Editor (highlighting, auto-complete, ...) and automated Browsing and Refactoring Actions (Select, Drop, etc...). Since release 0.3, it is massively based on Plugins architecture which makes it very extensible.

Paxle

Paxle is a full-fledged, modular search framework based on OSGi. All functional modules are strictly separated and can therefore be exchanged independently. It provides meta search capabilities via definition of several search-providers. In addition to these external resources, Paxle crawls the ... [More] web and efficiently stores the content in a local database, which is part of Paxle but can be exchanged just as well. A search-provider for this DB is also included. Paxle's licence is little restrictive and it is Open Source Software as defined by OSI and FSF. [Less]

SchemaCrawler

SchemaCrawler is an open-source Java API that makes working with database metadata as easy as working with plain old Java objects. SchemaCrawler is also a database schema discovery and comprehension, and schema documentation tool. You can search for database schema objects using regular ... [More] expressions, and output the schema and data in a readable text format, and find potential design issues with lint . The output is designed to be diff-ed against other database schemas. SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java. [Less]