Thread: database business rules

  1. #1
    (?<!re)tired Mario F.'s Avatar
    Join Date
    May 2006
    Location
    Angola
    Posts
    8,445

    database business rules

    I had a lively debate today with a db admin when I told him to remove all his check and exclusions constraints from a production postgres database, along with any domains, because the client application was already handling the business logic.

    I can understand why to him my request (in the tone of a demand) seemed insane. I could have just asked him to close his eyes when crossing the street because I was holding his hand. But in all truth, I'm tired of db admins introducing bugs into the system and not being held accountable. And I'm red-eyed concerning this particular db admin. In the end it's always on us with calls from the dept with "your application stopped working again!"... for the nth time this year.

    Word of advice:
    If you are not moving your entire business logic to the database side, do not add ANY business logic to the database side, beyond that which is required to maintain data hierarchy rules.

    Do not add even seemingly innocuous stuff like a check constraint to test if an integer value is positive. Because the client application is handling the business logic, it will have to do all those things already. And no one benefits from a system the implements business rules in two different places. Especially when those rules are always changing.
    Last edited by Mario F.; 11-08-2016 at 03:28 PM.
    Originally Posted by brewbuck:
    Reimplementing a large system in another language to get a 25% performance boost is nonsense. It would be cheaper to just get a computer which is 25% faster.

  2. #2
    Make Fortran great again
    Join Date
    Sep 2009
    Posts
    1,413
    Haven't been in this situation myself, but the reasoning makes sense. Hard enough to debug sometimes without external crap happening.

  3. #3
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    37,415
    Complain to the person who holds both sets of purse strings, and tell them that they're spending the same money twice.
    If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
    If at first you don't succeed, try writing your phone number on the exam paper.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. New Online business, seeking gaming/database progammers
    By cpd1224 in forum Projects and Job Recruitment
    Replies: 2
    Last Post: 12-30-2010, 11:44 AM
  2. Modularizing business rules in code
    By Mario F. in forum General Discussions
    Replies: 4
    Last Post: 12-17-2010, 12:46 PM
  3. SAP business one
    By maes in forum A Brief History of Cprogramming.com
    Replies: 0
    Last Post: 11-19-2004, 12:23 PM
  4. business database program.
    By StinkyRyan in forum C++ Programming
    Replies: 1
    Last Post: 07-07-2004, 01:46 AM
  5. business project
    By david in forum C Programming
    Replies: 1
    Last Post: 11-29-2001, 04:05 AM

Tags for this Thread