× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. August 2007

Re: MVC Architecture and transactions

Ron Power wrote:
So, what Joe says is correct, if you can't control the data going in and
coming out of the database, and have security around the database setup so
that end users can't DFU data, then the database is doomed. If you let
users DFU the data, or delete or insert records that cannot be verified
thru the application, then you are doomed to have application issues when
the data is extracted and used.

It's not just end users. Some of us IT folk have been known to make a
mistake once in a while. Any DB changes via ad hoc interfaces (DFU,
interactive SQL, etc.) carries risks. It may not be SOX compliant either.

Commitment control has it's place. We use it some places and probably
should use it in more. A side benefit of setting up DB journaling is
that you gain another tool for DB problem analysis. I found some
elusive bugs by dumping the journals.


Keith

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.