Your ideas are intriguing to me and I would like to subscribe to your newsletter.
Actually, you make a fantastic point about liberal use of views but your solution does nothing for migrating the data :) On 10-07-24 4:49 AM, Dmitriy Igrishin wrote: > Hey all, > > IMHO. > > Well designed database - not only structure, but a collection of many > types of the objects, > such as triggers, rules, functions, operators, domains and so on. So, > migrating from one > (good :) database version to another is an art. > One of the key aspect of good database design - liberal use of views > (and rules). Views > allows to encapsulate the details of the structure of the tables, which > may change as > the application evolves, behind consistent interfaces. > > For bad designed databases the best migration schema is: > DROP DATABASE bad_designed; > CREATE DATABASE well_designed; > -- ... > > Regards, > Dmitriy > > 2010/7/23 Sohail Somani <[email protected] > <mailto:[email protected]>> > > On 10-07-23 7:28 AM, Koen Deforche wrote: > > Hey, > > > > 2010/7/23 Sohail > Somani<[email protected] > <mailto:[email protected]>>: > >> > On 10-07-22 10:29 AM, Sohail Somani wrote: > >>> >> Simple migrations are easy. Tricky are hard. That's > probably why most > >>> >> tools stick to SQL. > >> > > >> > 'Boost' RDB may make that a bit easier: > >> > > >> > http://code.google.com/p/boost-rdb/ > >> > > >> > I haven't been able to get it to compile yet though. > > That project started around the same time as we started Wt::Dbo. > > > > It would be nice to see it succeed as indeed it focusses on a single > > aspect that is missing from Wt::Dbo, and would be nice for a > migration > > definition or even query language for Wt::Dbo, but it seems it is no > > longer actively developed (last commit from January?). > > > > Regards, > > koen > > > > Docs look almost complete. Maybe there are no bugs :) > > http://yorel.be/boost/libs/rdb/doc/html/index.html > > > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first <http://sprint.com/first> -- > http://p.sf.net/sfu/sprint-com-first > _______________________________________________ > witty-interest mailing list > [email protected] > <mailto:[email protected]> > https://lists.sourceforge.net/lists/listinfo/witty-interest > > > > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > > > > _______________________________________________ > witty-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/witty-interest ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
