Re: The wisdom of the object mentors (Was: Searching OO Associations with RDBMS Persistence Models)

From: Robert Martin <>
Date: Tue, 13 Jun 2006 12:12:05 +0200
Message-ID: <2006061312120511272-unclebob_at_objectmentorcom>

On 2006-06-03 01:50:04 +0200, "topmind" <> said:

> I've worked with code where the SQL was "encapsulated" in a seperate
> area. It was PAIN in the Arse.

I've worked with code where the SQL was embedded throughout. That's a pain in the ass too. The code constantly oscilates between three different languages. (SQL, Tables-rows, code).

One system I worked on completely melted down when the DB vendor went out of business. There was no way to find and replace all that SQL (though we tried for 6 months).

There are no easy aswers. Software is hard. Encapsulating SQL has it's costs and it's benefits. For large systems I think the benefits exceed the costs because of the flexibility, and testability that it affords. But I agree that layers of abstraction bring their own difficulties.

Robert C. Martin (Uncle Bob)  | email:
Object Mentor Inc.            | blog:
The Agile Transition Experts  | web:
800-338-6716                  |
Received on Tue Jun 13 2006 - 12:12:05 CEST

Original text of this message