Click here to Skip to main content
14,356,735 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: Need some direction from programmers / developers please! Pin
Eddy Vluggen12-May-19 4:02
mveEddy Vluggen12-May-19 4:02 
GeneralRe: Need some direction from programmers / developers please! Pin
#realJSOP12-May-19 4:27
mve#realJSOP12-May-19 4:27 
GeneralRe: Need some direction from programmers / developers please! Pin
Eddy Vluggen12-May-19 10:08
mveEddy Vluggen12-May-19 10:08 
GeneralRe: Need some direction from programmers / developers please! Pin
Mycroft Holmes12-May-19 15:06
memberMycroft Holmes12-May-19 15:06 
GeneralRe: Need some direction from programmers / developers please! Pin
Eddy Vluggen13-May-19 2:30
mveEddy Vluggen13-May-19 2:30 
GeneralRe: Need some direction from programmers / developers please! Pin
DerekT-P14-May-19 2:47
professionalDerekT-P14-May-19 2:47 
GeneralRe: Need some direction from programmers / developers please! Pin
Eddy Vluggen14-May-19 5:03
mveEddy Vluggen14-May-19 5:03 
GeneralRe: Need some direction from programmers / developers please! Pin
DerekT-P14-May-19 8:58
professionalDerekT-P14-May-19 8:58 
Some interesting responses there, and I think we agree on much. However I'd still contest that letting end-users - even with reasonable SQL skills - loose on writing Stored Procs is a bad idea. For one thing, in very many scenarios, the end-user does not (or should not) have permissions to see the full structure of the tables they're dealing with, and certainly not a deeper understanding of the database structures - nor of other applications that also need to access the data.

For low volume (size and transaction rate) databases it might not hurt too much, but a single badly-written (by which I don't mean poor syntax, I mean inappropriate for the situation) SP can wreak havoc on a high-volume or high-activity d/b.
Eddy Vluggen wrote:
Being proficient with SQL is not enough
which I think is the point I was trying to make; probably failed to express it well.
Eddy Vluggen wrote:
The app does not determine how the database is structured; the app is merely a layer, and will have to use the structure as determined by the DBA
Generally, I'd agree with you there; however I think it's often a chicken-and-egg situation, and I've experienced places where "[the application developer] will have to use the structure as determined by the DBA" has caused not only poorly-performing apps, but also project over-runs and severe internal ructions. Too much delineation between roles, lack of communication, inflexibility and "empire-building" is never good. Development involves ongoing negotiation and collaboration and a new app with a unique access pattern may require more than just whacking in an extra index or two!
GeneralRe: Need some direction from programmers / developers please! Pin
Eddy Vluggen15-May-19 1:14
mveEddy Vluggen15-May-19 1:14 
GeneralRe: Need some direction from programmers / developers please! Pin
DerekT-P15-May-19 12:17
professionalDerekT-P15-May-19 12:17 
GeneralRe: Need some direction from programmers / developers please! Pin
Eddy Vluggen15-May-19 23:54
mveEddy Vluggen15-May-19 23:54 
GeneralRe: Need some direction from programmers / developers please! Pin
DerekT-P16-May-19 1:47
professionalDerekT-P16-May-19 1:47 
GeneralRe: Need some direction from programmers / developers please! Pin
Eddy Vluggen16-May-19 10:45
mveEddy Vluggen16-May-19 10:45 
GeneralRe: Need some direction from programmers / developers please! Pin
Kornfeld Eliyahu Peter12-May-19 2:05
mveKornfeld Eliyahu Peter12-May-19 2:05 
GeneralRe: Need some direction from programmers / developers please! Pin
GuyThiebaut12-May-19 2:46
professionalGuyThiebaut12-May-19 2:46 
GeneralRe: Need some direction from programmers / developers please! Pin
OriginalGriff12-May-19 3:18
protectorOriginalGriff12-May-19 3:18 
GeneralRe: Need some direction from programmers / developers please! Pin
Sander Rossel12-May-19 3:21
professionalSander Rossel12-May-19 3:21 
GeneralRe: Need some direction from programmers / developers please! Pin
Eddy Vluggen12-May-19 10:12
mveEddy Vluggen12-May-19 10:12 
GeneralRe: Need some direction from programmers / developers please! Pin
charlieg12-May-19 10:53
membercharlieg12-May-19 10:53 
AnswerRe: Need some direction from programmers / developers please! Pin
Ravi Bhavnani12-May-19 15:42
professionalRavi Bhavnani12-May-19 15:42 
GeneralDo people still use XML? Pin
honey the codewitch11-May-19 21:08
memberhoney the codewitch11-May-19 21:08 
GeneralRe: Do people still use XML? Pin
Kornfeld Eliyahu Peter11-May-19 21:36
mveKornfeld Eliyahu Peter11-May-19 21:36 
GeneralRe: Do people still use XML? Pin
honey the codewitch11-May-19 22:35
memberhoney the codewitch11-May-19 22:35 
GeneralRe: Do people still use XML? Pin
Kornfeld Eliyahu Peter11-May-19 22:43
mveKornfeld Eliyahu Peter11-May-19 22:43 
GeneralRe: Do people still use XML? Pin
honey the codewitch11-May-19 23:30
memberhoney the codewitch11-May-19 23:30 

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.