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]>
> On 10-07-23 7:28 AM, Koen Deforche wrote:
> > Hey,
> >
> > 2010/7/23 Sohail Somani<[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://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
