Hey Sohail,
Let's find out what we are talking about - how to evolve the existing
database
of the production system (which probably can't be stopped and must work in
24x7 mode) or how to evolve the database during the development?
Regards,
Dmitriy
2010/7/24 Sohail Somani <[email protected]>
> 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
>
------------------------------------------------------------------------------
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
