Boston Linux & UNIX was originally founded in 1994 as part of The Boston Computer Society. We meet on the third Wednesday of each month, online, via Jitsi Meet.

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] SQL discussion



Doug <sweetser at alum.mit.edu> writes:

> postgres rocks in my opinion.  But I still have a fear: triggers.  It is
> triggers that blur what I view as a database - place for my data, with
> programming, which is to transform the data.  There is no universal trigger
> language.  In postgres, there are a bunch.  The trigger code is not so

This is a problem. The result where I've been working is that things
that would make sense to run in the DB are not.  Instead they're written
in C++ and run on a different machine.  Reams of data gets unnecessarily
copied across the network, just because we needed to support multiple
RDBMes and didn't feel we could afford to have multiple sets of stored
procedures, one for each vendor's language.

-- 
Mike Small
smallm at panix.com



BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org