> > This is allways something I've had a problem understdaning.
> > If you go to a
> > pure object model how do you get your objects to be persistent into a
> > relational db, like Interbase?
>
> There are many ways to achieve this.
>
> 1.  Stream your properties into blob fields.
> 2.  Variant of (1), in addition to streaming, save your key fields into
> "real" relational database fields.  This will solve the foreign key
> problems.
>
> The problem with (1) and (2) is when it comes to generating reports.

...and searching for data by anything other than the primary key gets kinda
tough too!

> 3.  Write a translator to map your properties to fields in the DB.  This
is
> a lot more work, but solves the problems in (1) & (2).  However, you will
> need to update your translator / DB if you make changes to fields in your
> business objects.

You might want to take a look at http://www.cam.org/~mibra/spider/odb.html
If you do, *please* report back here with an opinion. I've not looked at
it -- I just know that it exists.

> > Should I just dump Delphi and use Jade?

So you can take advantage of the huge developer community?  :-)

> If you must go the JADE way, I would rather use one of those Java OO-DBs.

Or Java with an O/R mapping tool, like TopLink.

Cheers,
Kerry Sainsbury
Inprise/Borland New Zealand

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz

Reply via email to