[DUG] Why InterBase

[Kyley Harris]

What is the warehouse using? Oracle? MSSQL? Have they stayed with only
one? 

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
On Behalf Of Edward Huang
Sent: Tuesday, 6 June 2006 9:45 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: RE: [DUG] Why InterBase

Well, we are another group of programmers that put as much of business
logic
into database layer (views, user defined functions, SPs, triggers and
referential integrities) as we can sensibly do.

It's not exactly depends on personal style either, as I was mainly doing
business logic in application layer only before this.  It just works
best in
the environment I'm currently in.  With some logic in database layer,
many
times you don't need to change the application layer when you need to
change
business logic.  When you need to change your database structure, you
can
make it transparent to application layer as well.  It's just make sense
when
your data has many values outside of your application.  In this type of
case, I would think IB/FB just wouldn't quite cut, although I was a fun
of
IB before.

It's kind of case by case, in my opinion.

Cheers,

Edward


> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz
> [mailto:delphi-bounces at ns3.123.co.nz]On Behalf Of kurt
> Sent: Thursday, 1 June 2006 10:47 p.m.
> To: NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] Why InterBase
>
>
> Kyley Harris wrote:
> > I agree. I actually don't put ANY business logic into the database.
>
> Urk, disagree.
> Database is almost pure business logic already
> (there shall be 3 addresses per client, and one shall be called
> the contact address).
> Only reasons for pulling stuff out are SQL's limited expression,
> micro-managing performance (manipulating all the X's for
> this Y only), and fitting a different logical structure on top
> of the data.
>
> OTOH, I've not met another programmer that agrees with me yet :)
>
> Cheers, Kurt.
>
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.8.0/353 - Release Date:
31/05/2006
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.2/356 - Release Date: 5/06/2006

_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi