Projects

South

South is a database migration framework for Django applications.

deseb

Django External Schema Evolution Branch Django, via the command ./manage syncdb, can automatically build a database schema based on your applications models.py file. However, after you've done this once, it leaves you with two unpleasant follow-up options if you ever make any changes to your ... [More] model structure: 1. destroy your existing schema (along with all your data) and let ./manage syncdb rebuild it for you 2. manage your own schema upgrades by writing your own SQL Project deseb aims to fill this void by providing s third option: 3. generate schema upgrades via the command: ./manage evolvedb [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.

sql-dump-schema-diff

This is a command line tool written in Python. It displays all the differences between two database schemas. The schema are provided as SQL dump. 1. ExampleInputdb1.sql: sql dump of a database with a single table: 'person' CREATE TABLE `person` ( `last name` varchar(50) NOT NULL, ... [More] `date_of_birth` varchar(45) NOT NULL, PRIMARY KEY (`last name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;db2.sql: sql dump of the same database after adding a new table 'car' and modified fields in the 'person' table. CREATE TABLE `car` ( `color` varchar(50) NOT NULL, `number_plate` varchar(50) NOT NULL, `brand` varchar(50) NOT NULL, PRIMARY KEY (`number_plate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `person` ( `last name` varchar(50) NOT NULL, `date_of_birth` datetime NOT NULL, `first_name` varchar(45) NOT NULL, PRIMARY KEY (`last name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;Commandpython compdb.py db1.sql db2.sqlOutput% FIELD: person.date_of_birth `date_of_birth` varchar(45) NOT NULL => `date_of_birth` datetime NOT NULL + FIELD: person.`first_name` varchar(45) NOT NULL + TABLE: car 3 difference(s).2. Notation%: difference +: new field or table -: missing field or table 3. LimitationsCurrently works only with MySQL dumps Obviously this tool cannot detect when the name of a field or a table has changed! 4. MotivationThis script was originally written to help me keep track of the evolution of Django models (hence the Python implementation). Before upgrading a staging server, I would compare the SQL dump from my development database (generated with mysqldump -d or with python manage.py sql) with the dump from my staging server. Note that more sophisticated tools have been developed for this purpose, search for 'django schema evolution' on any search engine to find them. This tool was developed as part of a UML to Django conversion project. 5. FeedbackYour comments and contributions are welcome. [Less]

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]

Mogwai ERDesignerNG

Mogwai ERDesignerNG is a Java based 2D & 3D Entity Relationship design & modeling (ERD) tool for Oracle, MSSQL, Postgres and MySQL. It includes database change and dictionary management, SQL generation, reverse and forward engineering plus reports and data browsing.