Click here to Skip to main content
15,300,707 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: Imposing data type and length restrictions at the database level is stupid! Pin
Jörgen Andersson27-Aug-21 9:40
professionalJörgen Andersson27-Aug-21 9:40 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
den2k8827-Aug-21 3:22
professionalden2k8827-Aug-21 3:22 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
Jörgen Andersson27-Aug-21 9:13
professionalJörgen Andersson27-Aug-21 9:13 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
dandy7227-Aug-21 3:29
Memberdandy7227-Aug-21 3:29 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
obermd27-Aug-21 3:38
Memberobermd27-Aug-21 3:38 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
englebart27-Aug-21 3:45
professionalenglebart27-Aug-21 3:45 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
Sander Rossel27-Aug-21 4:11
professionalSander Rossel27-Aug-21 4:11 
QuestionRe: Imposing data type and length restrictions at the database level is stupid! Pin
David Crow27-Aug-21 4:49
MemberDavid Crow27-Aug-21 4:49 
5teveH wrote:
It puts the sole responsibility for data validation exactly where it should be: with the developer. The best place to catch bad data, is at the point of entry - before it gets anywhere near a database. That applies to user input and data feeds. If you are going to validate early, (and properly), there's no need to have a rigid database schema.
And what happens when the next app comes along that needs to interact with such a database/table? What about a mobile app? That just looks like a rewrite of code each and every time.

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles


PraiseRe: Imposing data type and length restrictions at the database level is stupid! Pin
Slacker00727-Aug-21 6:00
professionalSlacker00727-Aug-21 6:00 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
Gerry Schmitz27-Aug-21 5:15
mveGerry Schmitz27-Aug-21 5:15 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
#realJSOP28-Aug-21 1:08
mva#realJSOP28-Aug-21 1:08 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
5teveH28-Aug-21 3:29
Member5teveH28-Aug-21 3:29 
JokeNever fight a dinosaur... Pin
Sander Rossel27-Aug-21 0:54
professionalSander Rossel27-Aug-21 0:54 
GeneralRe: Never fight a dinosaur... Pin
Johnny J.27-Aug-21 1:15
professionalJohnny J.27-Aug-21 1:15 
GeneralRe: Never fight a dinosaur... Pin
PIEBALDconsult27-Aug-21 12:00
professionalPIEBALDconsult27-Aug-21 12:00 
GeneralSound of the Week Pin
Sander Rossel26-Aug-21 23:29
professionalSander Rossel26-Aug-21 23:29 
GeneralRe: Sound of the Week Pin
David O'Neil27-Aug-21 3:15
professionalDavid O'Neil27-Aug-21 3:15 
GeneralRe: Sound of the Week Pin
PeterKM27-Aug-21 9:24
MemberPeterKM27-Aug-21 9:24 
GeneralRe: Sound of the Week Pin
Sander Rossel28-Aug-21 0:12
professionalSander Rossel28-Aug-21 0:12 
GeneralRe: Sound of the Week Pin
David O'Neil28-Aug-21 4:23
professionalDavid O'Neil28-Aug-21 4:23 
GeneralRe: Sound of the Week Pin
PeterKM27-Aug-21 9:20
MemberPeterKM27-Aug-21 9:20 
GeneralRe: Sound of the Week Pin
Sander Rossel28-Aug-21 0:07
professionalSander Rossel28-Aug-21 0:07 
GeneralCCC 2021-08-27 Pin
NeverJustHere26-Aug-21 22:21
MemberNeverJustHere26-Aug-21 22:21 
GeneralRe: CCC 2021-08-27 Pin
pkfox26-Aug-21 22:51
professionalpkfox26-Aug-21 22:51 
GeneralRe: CCC 2021-08-27 Pin
NeverJustHere26-Aug-21 22:54
MemberNeverJustHere26-Aug-21 22:54 

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.


Straw Poll

On which operating systems are you writing code?
Let's see if things have changed since we last ran this. "writing code" meaning editing, building, and running the code on that OS.
  Results   495 votes