MiddleKit Schema Upgrade

Seth Remington <[email protected]>
Newsgroups gmane.comp.python.webware
Message-ID <[email protected]>
Hello All,

I am using MiddleKit in an open source application and as most projects
go it is expanding and evolving, and the database structure is evolving
with it.

So now I have a requirement to provide a convenient upgrade path for
users that includes database schema changes. MiddleKit is wonderful for
doing a fresh install... but not so much for upgrading an existing
install.

I've researched the archives and wiki and found the references to
mysqldiff. Unfortunately I can't guarantee that other users are going to
be using MySQL so the resulting SQL might not be portable.

I'm thinking I might have to write something to use the MiddleKit.Design
internals to generate the appropriate SQL for the appropriate database.
But before I delved into that I thought I would ask the community if
anyone has dealt with this situation before, or perhaps a better
suggestion about how to go about it.

-Seth
-- 
Seth Remington <[email protected]>


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.