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]>
> 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
>
------------------------------------------------------------------------------
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
