Hmmm, I have not thought about dumping and restoring. How does that work when table structures change? For example, new fields or new check constraints?
Are you implying instead that you would have 100% of the requirements up front? On 10-07-24 11:48 AM, Dmitriy Igrishin wrote: > Hey Sohail, > > I am sorry but I dont clearly understand what does "migrating the data" > means? > You may "migrate the data" by dumping and restoring you database :). > > I just wanted to say that well designed database does not need to be > restructured and there is no big problem to evolve well designed database. > > Regards, > Dmitriy > > 2010/7/24 Sohail Somani <[email protected] > <mailto:[email protected]>> > > 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]> > > <mailto:[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]> > > <mailto:[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://sprint.com/first> -- > > http://p.sf.net/sfu/sprint-com-first > > _______________________________________________ > > witty-interest mailing list > > [email protected] > <mailto:[email protected]> > > > <mailto:[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://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://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
