I would still focus on getting it right in the app first. That is very likely my over-compensating for developers who put it in the DB and don't even think to teach the App what to do when it blows up! :-)
Wade.
Yes, this is where my preference is going now.
I would still focus on getting it right in the app first. That is very likely my over-compensating for developers who put it in the DB and don't even think to teach the App what to do when it blows up! :-)
Wade. Static Scribblings http://staticsan.blogspot.com/
|
|
|
There comes the moment when the constraints get dropped
Either on purpose (bulk loads drag on too long or some such) or by accident (DBA doing a reorg moves everything to a different system/tablespace and a few lines of the constraint build script fail and the error gets missed since it is a simple many lines script).
Be ready. |
|
|
That's exactly why I want the App to know what to do! :-)
Static Scribblings http://staticsan.blogspot.com/
|
Question on DB "best practices"
- (drook)
- (31)
- June 22, 2011, 03:39:27 PM EDT
We don't even...
- (folkert)
- June 22, 2011, 03:48:23 PM EDT
Design coin flip
- (jay)
- June 22, 2011, 04:13:43 PM EDT
dumb datastore is easier to debug imho
-NT
- (boxley)
- June 22, 2011, 05:12:52 PM EDT
Step away from the gun...
- (malraux)
- (17)
- June 22, 2011, 06:36:50 PM EDT
Wow, not the response I was expecting
- (drook)
- (16)
- June 22, 2011, 10:23:05 PM EDT
Why that should not be in the DB:
- (malraux)
- (1)
- June 22, 2011, 11:30:59 PM EDT
Very interesting. Thanks for the detalied explanation.
-NT
- (Another Scott)
- June 23, 2011, 06:47:10 AM EDT
I wasn't expecting that trend, either.
- (static)
- (13)
- June 22, 2011, 11:34:05 PM EDT
Re: I wasn't expecting that trend, either.
- (malraux)
- (6)
- June 22, 2011, 11:41:29 PM EDT
I think I know what the problem is
- (drook)
- (4)
- June 23, 2011, 05:17:43 AM EDT
Paging is tricky.
- (static)
- June 23, 2011, 05:51:15 AM EDT
Re: I think I know what the problem is
- (malraux)
- (2)
- June 23, 2011, 11:54:11 AM EDT
Grid views, basically
- (drook)
- (1)
- June 23, 2011, 12:40:59 PM EDT
Re: Grid views -- thoughts
- (S1mon_Jester)
- June 23, 2011, 12:52:32 PM EDT
And ORMs have gotten better, too.
- (static)
- June 23, 2011, 05:44:21 AM EDT
DB does have one key advantage here
- (jay)
- (5)
- June 23, 2011, 10:04:17 AM EDT
This
-NT
- (drook)
- June 23, 2011, 12:41:34 PM EDT
As scott said
- (crazy)
- (3)
- June 23, 2011, 02:57:46 PM EDT
Yes, this is where my preference is going now.
- (static)
- (2)
- June 24, 2011, 12:11:36 AM EDT
There comes the moment when the constraints get dropped
- (crazy)
- (1)
- June 24, 2011, 01:04:48 PM EDT
That's exactly why I want the App to know what to do! :-)
-NT
- (static)
- June 25, 2011, 02:15:16 AM EDT
Well, it depends
- (lincoln)
- (9)
- June 23, 2011, 08:10:58 PM EDT
5,000 to 10,000 lines long?
- (malraux)
- (7)
- June 23, 2011, 10:06:20 PM EDT
I still win
- (crazy)
- (5)
- June 24, 2011, 01:07:06 PM EDT
Let me guess - No comments, too? ;-)
-NT
- (Another Scott)
- (2)
- June 24, 2011, 01:17:55 PM EDT
Don't recall
- (crazy)
- (1)
- June 24, 2011, 08:08:50 PM EDT
I remember looking at it...
- (folkert)
- June 25, 2011, 08:12:24 PM EDT
Hmmm.
- (malraux)
- (1)
- June 25, 2011, 06:42:35 PM EDT
:-)
-NT
- (Another Scott)
- June 25, 2011, 07:37:19 PM EDT
they were written over a dozen years ago
- (lincoln)
- June 25, 2011, 04:04:44 PM EDT
Amateur
- (drook)
- June 24, 2011, 01:46:34 PM EDT