|
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
|
|
|
|
|
David Crow wrote: And what happens when the next app comes along that needs to interact with such a database/table?
Exactly this!
|
|
|
|
|
Organization provides meaning to the data. A model. A "dynamic bag" is just that: a bag.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
In Sql Server, a varchar column only takes two bytes when it's empty, and then only consumes the space required by its value when it's populated. How is that "fixed length"?
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
#realJSOP wrote: How is that "fixed length"? Agreed, it is variable length - up to a point. But if you try to insert an eleven-character string into a VARCHAR(10) column, SQL is going to bork!
But my main point was the restrictions being implemented by the database - rather than in the code.
modified 28-Aug-21 10:02am.
|
|
|
|
|
You'll get jurasskicked.
I'll show myself out...
|
|
|
|
|
Don't forget your coat!
Anything that is unrelated to elephants is irrelephant Anonymous
- The problem with quotes on the internet is that you can never tell if they're genuine Winston Churchill, 1944
- Never argue with a fool. Onlookers may not be able to tell the difference. Mark Twain
|
|
|
|
|
No dinosaurs, not since Chuck Norris.
|
|
|
|
|
Emeli Sandé - Read All About It, Pt. III[^]
Last week's SOTW reminded me of this one, mainly because of the beautiful piano play.
I actually learned about this song back in 2013 from a Britain's Got Talent act: Attraction - Shadow act - Read all about it. Britain's Got Talent 2013 - YouTube[^]
The song was originally a rap song, with lyrics by Emeli Sandé, but Emeli released her own (far better) version of the song, which would be pt. III (there's also a pt. II, but I don't know it).
The song has a message, I guess everyone matters and deserves to be heard.
Not sure I agree, just turn on the news and you'll see plenty of people who deserve to be silenced, but maybe those aren't the people she sings about.
One thing is for sure, Emeli's voice may be heard
|
|
|
|
|
|
Ha ... this infected mushroom is kind of engaging pity that I have still so much work to do today, I put them on my playlist, good stuff [ and now back to work ... ],
Cheers
|
|
|
|
|
David O'Neil wrote: Here's a link that works: Read All About It, Pt. III - YouTube. Nice song. That link gives me a "Video not available"...
They're both the same video (or at least same title) from the same official channel...
I never understood the video blocking in certain countries (other than copyrights).
David O'Neil wrote: Here's a bunch of fun claymation used for background visuals: Infected Mushroom vs Astrix - DJ Set 2021 Mix. Going to listen to this one later, always loved Astrix though and a preliminary listen tells me I won't be disappointed
David O'Neil wrote: (Evidently, the claymation is taken from a video game that came out years ago.) Seems to be from a movie rather than a game: Neverhood - The Movie [ROUGH CUT] - YouTube[^]
|
|
|
|
|
Sander Rossel wrote: Seems to be from a movie rather than a game... This is what came up when I searched: LGR - The Neverhood - PC Game Review. Many of the scenes in the video seemed to mirror the shots in the vid, so maybe the game and movie are connected?
|
|
|
|
|
|
Would've loved that one some 15 years ago, now it's mostly nostalgia
I still like to listen to Arch Enemy's Wages of Sin and Anthems of Rebellion from time to time (but haven't heard a single album after that).
|
|
|
|
|
Delta is clearly perceptible after double six (5)
|
|
|
|
|
Covid ?
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
|
Vivid ?
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
|
Apart from the vivi for double six and vivid being clearly perceptible I don't get the delta part ( or is that just the d )
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
That's just the D.
(No rudeness allowed)
|
|
|
|
|
Nice clue (only just catching up with last week's CCCs). However according to many on here, the "definition" should be at one end, so "Clearly perceptible delta after double six" would be even better.
|
|
|
|
|
Thanks for the tip. I'll bear it in mind should I ever get to set another.
Which is possibly more likely, since the same tip (according to many) narrows the search space for other clues.
|
|
|
|
|
I was thinking 66 was ASCII for B!
|
|
|
|