db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon Scott Stevens <...@latchkey.com>
Subject Re: How does Torque framework adjust to evolving DB schema?
Date Tue, 25 Mar 2003 20:54:26 GMT
on 2003/3/25 12:48 PM, "Tim Clotworthy" <tclotworthy@bka-inc.com> wrote:

> Perhaps I am missing something in the documentation, but I only see how
> to install and setup Torque, not how to keep the various objects in
> synch with an evolving DB schema. For instance, as tables are added and
> removed, fields are added to existing tables, etc. How does Torque
> adapt?

Torque generates code as described in the XML file.

> A DB schema can't realistically be maintained in XML (*-schema.xml, or
> whatever the Torque schema file is). A DB is maintained by DBAs through
> sql scripts or through tools like Erwin, not with XML.

That is a nice concrete statement which is completely false.

A slightly more correct statement is:

A DB schema is realistically maintained in whatever format it was first
created in. You can then make changes to the schema which are in the form of
upgrade scripts which are maintained as SQL scripts.

> Is there some cache of documentation I am overlooking here, or is Torque
> not intended for real databases that must scale? I would greatly
> appreciate it if anyone can direct me to how Torque addresses an
> evolving database.  Thanks very much.

I dunno...we have been developing Scarab for the last 3 years using Torque
and our ability to 'scale' has been managed quite well...even with some
pretty significant database changes.

Sure, there are some things that don't translate well when you make some
core changes, but most of that surrounds business logic which expects a
certain schema design and is therefore difficult to modify easily. That is a
problem I don't think anyone has solved completely.

-jon

-- 
StudioZ.tv /\ Bar/Nightclub/Entertainment
314 11th Street @ Folsom /\ San Francisco
        http://studioz.tv/


Mime
View raw message