Click here to Skip to main content
15,867,771 members

The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Tomz_KV20-Oct-10 2:06
Tomz_KV20-Oct-10 2:06 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 2:43
Richard A. Dalton20-Oct-10 2:43 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Electron Shepherd20-Oct-10 2:46
Electron Shepherd20-Oct-10 2:46 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Tomz_KV20-Oct-10 3:12
Tomz_KV20-Oct-10 3:12 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Electron Shepherd20-Oct-10 3:17
Electron Shepherd20-Oct-10 3:17 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 3:26
Richard A. Dalton20-Oct-10 3:26 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
richard_k26-Oct-10 22:09
richard_k26-Oct-10 22:09 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
JasonPSage20-Oct-10 3:31
JasonPSage20-Oct-10 3:31 
First off: Thank you for your rant. It's a one based on experience. If if folks don't agree or are quick to have a comment: I appreciate your frustration.

Now my turn for a comment or thought: I'll keep it general as possible.

I went into a database seminar related to a now defunc product that was one of the best analytic tools I've ever used in my entire career.. and this was in 2001! I've yet to see it's match today. It was called "BroadBase" and it was awesome. Anyway; before they were bought and the software purposely taken off the market even though it didn't compete with the new owner's products... I went to a seminar they hosted.

In that seminar we covered and discussed things like data-marts, data ware-housing, reporting, applications, various database vendors and design in general.

Some of the major points I remember quite clearly was where do you put your business logic: In the database or in the application? Now there are folks who say one, the other or both. Here were the things that interested me: they aren't answers.. but they are good things to consider when deciding:

1: Placing Business Rules and logic into the database (foreign keys, PL SQL etC) to help deliver information and protect data integrity put more reliance on the particular Database vendor. (Puts responsibility for data integrity on the database's shoulders)

2: Putting business rules and logic into your application makes your application less dependent on the specific DBMS your using

3: If multiple applications use the same database: Option 1 seems like a good option but putting business rules into a shared code base all systems can leverage gives benefits of option 2 but might be impossible or too difficult to implement enterprise wide.

So for me: I don't have an argument for one way or another. I'm also in agreement with other comments in this thread to the tune that it's not necessarily tools but skill that makes the difference in quality for finished systems.

I also am slow to bash folks for ugly systems I'm asked to fix because without knowing what environment the folks were working under: budget; time; boss; requirements; chief architect passed away mid project... god forbid...

My Opinion is: There isn't a one size fits all solution: consider ALL details; short term and long term goals of the project; consider your team, your budget, and make it happen as best you and your team can!
Know way too many languages... master of none!

GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 4:24
Richard A. Dalton20-Oct-10 4:24 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
richard_k26-Oct-10 22:11
richard_k26-Oct-10 22:11 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
YSLGuru20-Oct-10 10:20
YSLGuru20-Oct-10 10:20 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 23:32
Richard A. Dalton20-Oct-10 23:32 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
wout de zeeuw20-Oct-10 11:42
wout de zeeuw20-Oct-10 11:42 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton20-Oct-10 23:42
Richard A. Dalton20-Oct-10 23:42 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
wout de zeeuw21-Oct-10 0:45
wout de zeeuw21-Oct-10 0:45 
GeneralRe: Stored Procs, Packages, Views...Pah! Pin
Richard A. Dalton21-Oct-10 1:21
Richard A. Dalton21-Oct-10 1:21 
GeneralEmbrace the dark side - use an ORM Pin
Dale Margel20-Oct-10 15:31
professionalDale Margel20-Oct-10 15:31 
GeneralRe: Embrace the dark side - use an ORM Pin
AspDotNetDev20-Oct-10 15:45
protectorAspDotNetDev20-Oct-10 15:45 
GeneralRe: Embrace the dark side - use an ORM Pin
Dale Margel20-Oct-10 16:00
professionalDale Margel20-Oct-10 16:00 
GeneralRe: Embrace the dark side - use an ORM Pin
AspDotNetDev20-Oct-10 16:55
protectorAspDotNetDev20-Oct-10 16:55 
GeneralRe: Embrace the dark side - use an ORM Pin
fjdiewornncalwe21-Oct-10 3:34
professionalfjdiewornncalwe21-Oct-10 3:34 
GeneralRe: Embrace the dark side - use an ORM Pin
Richard A. Dalton20-Oct-10 23:28
Richard A. Dalton20-Oct-10 23:28 
GeneralRe: Embrace the dark side - use an ORM Pin
AspDotNetDev21-Oct-10 7:14
protectorAspDotNetDev21-Oct-10 7:14 
GeneralRe: Embrace the dark side - use an ORM Pin
Stryder_121-Oct-10 3:26
Stryder_121-Oct-10 3:26 
GeneralRe: Embrace the dark side - use an ORM Pin
AspDotNetDev21-Oct-10 7:16
protectorAspDotNetDev21-Oct-10 7:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.