Seeking an Agile Database Definition Language
Thursday, June 14th, 2007The database schemas for my current project are getting hashed out, mostly in Visio. This is pretty but not very automatable. I’d like to see if we can follow a more agile, iterative approach to database development. In particular, I’d like to be able to check the database definition into source code control and build the whole thing, including database tables and sample databases for testing out of Ant. Requirements include:
- Supports (at a minimum) MySQL and Derby
- Can be read by Java and Python
- Allows for inserting of data for unit testing; i.e. not just table definitions
It also wouldn’t hurt if it could reverse engineer existing SQL databases.
I’m tempted to write my own, probably using XML, but surely someone has already done this? I haven’t found a lot though. What I’ve got so far are these, none of which really meet the requirements:
(more…)