[Info-Ingres] String Manipulations

[Emiliano]

On 2007-03-18, Paul Andrews <ac297 at dial.pipex.commmmm> wrote:
> I will agree with you, however it seems to me that ingres procedural
> offerings are not really that brilliant for coding business logic with and

I'll grant you that one. Still, that would mean that maybe *Ingres*
isn't the best place to store your business logic. Other databases
have quite capable PLs, to the point of hosting runtimes for common
programming environments (java, python, .Net).

> worse still coding business logic inside a database is the kiss of death
> when some of your customers don't want ingres.

While that statement is true in and of itself, it isn't exclusive to
Ingres. Migration is always costly, so what happens if you have your
BL in a VB6 app? Now you still have to port, and on top of that you
have to replicate your BL in any connecting app. Unless you're talking
SOA; a whole tangle of problems on its own, but at least you have BL
and access centralized.

> Despite all the misgivings, I would still use database rules and procedures
> for many things, always mindful that it's not portable, nor ideal.

Which goes for Solaris, Windows, Mac, VB, Python, Java (yeah, I
know -- don't believe the hype), C#...

By which I'm not saying you *must* do BL in the DB, just that it's not
intrinsically worse than the alternative (even with Ingres PL).

-- 
Emiliano