Projects

South

South is a database migration framework for Django applications.

ADOdb

ADOdb is a database abstraction library for PHP. The PHP version currently supports an amazing number of databases, thanks to the wonderful ADOdb community: MySQL, PostgreSQL, Interbase, Firebird, Informix, Oracle, MS SQL, Foxpro, Access, ADO, Sybase, FrontBase, DB2, SAP DB, SQLite, Netezza ... [More] , LDAP, and generic ODBC, ODBTP. The Sybase, Informix, FrontBase and PostgreSQL, Netezza, LDAP, ODBTP drivers are community contributions. [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.

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]

Predicate

claimed by KDE

Predicate is a database connectivity and creation library, a new iteration of KexiDB library developed within Kexi, part of the Calligra Suite (http://www.calligra-suite.org), formerly KOffice. It is consisted of a C++ Qt-only library and set of plugins. Because there is no dependency on Kexi ... [More] , Calligra or even on KDE libraries, Predicate is available for very wide audience. At some point Kexi will use it too, thus deprecating KexiDB. Source code is available at https://projects.kde.org/projects/playground/libs/predicate [Less]

pgmigrate

The pgmigrate tool is developed for managing changes in database structure between a project members. It does so by managing so called 'patches'. Small pieces of SQL or Python code which modifies database schema. So far it supports only PostgreSQL. Starting from 1.2.0 can be easily integrated with Django to solve schema migration issue.

Pyrseas

Pyrseas provides a framework and utilities to upgrade and maintain a relational database. Its purpose is to enhance and follow through on the concepts of the Andromeda Project. Pyrseas currently includes the dbtoyaml utility to create a YAML description of a PostgreSQL database's tables, and ... [More] the yamltodb utility to generate SQL statements to modify a database to match an input YAML specification. [Less]