Projects

DBI

The DBI module enables your Perl applications to access multiple database types transparently. You can connect to a large number of databases, including MySQL, MSSQL, Oracle, Informix, Sybase, ODBC etc. without having to know the different underlying interfaces of each. The API defined by DBI will work on all these database types and many more.

Adminer

Adminer (formerly phpMinAdmin) is a full-featured MySQL management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server.

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.

CrunchyFrog

CrunchyFrog is a SQL client and schema browser mainly (but not solely) for the GNOME desktop. It's written in Python (PyGTK) and licensed under the GNU General Public License v3. Features * Supports various databases (PostreSQL, MySQL, SQLite, Oracle, SQLServer, LDAP). * Lightweight user ... [More] interface for daily tasks. * SQL editor with syntax highlighting. * Export results to CSV and OpenOffice. * Inspect database objects. * Supports multiple database connections at once (e.g. for switching between development and production environments). [Less]

TOra

TOra is a Toolkit for Oracle which aims to help the DBA or developer of database application. It features an SQL worksheet with PL/SQL block parsing, a PL/SQL debugger and editor with syntax highlighting, a Schema browser, UNICODE support, printing, and a full suite of DBA management tools.

jOOQ

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

Cross Database Engine for PHP

CDE is a php class which implements the general database functions in PHP and provides a common sql platform for php development where developers change their databases but not their code. Supports Firebird, Mysql, Oracle, SQLite, Dbase, MSSQL

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]