|
Long before there was a digital headache from debugging while staring at the computer screen there was the migraine contracted from watching the television. If I recall correctly, and this is even occuring before any sports commentator has left his dental imprint in the backside of a cohabitating companion, the stupididity of advertising could be sampled wafting up and from within the tiny twists and turns of the delicate little kibble-colored earphone attached to the spring terminals of one's Heathkit crystal radio ... in the form of the "Only You can Prevent Forest Fires".
Why exactly? Because reading books like "The Lion, The Witch, and The Wardrobe" is educational? Or that once read, riding the bus to school, in the case of a mis-flown paper airplane where the wingtip slices Paula's eye and it starts to bleed, the kid waking up in back of her will be able to render first aid because of ... the ... uhm ... thing.
|
|
|
|
|
|
Trial of my old mate’s half-chicken recipe is crazy! (12)
|
|
|
|
|
Experimental ? I gave it two hours 
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Yep! Yaum!
Trial of - Experimental
my old mate's = EX
half chicken recipe = PERI(-PERI)
is crazy = MENTAL
|
|
|
|
|
That's what I thought it was ! but to be honest once I got the Ex and mental part I guessed
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Hi Derek, I don't get:- half chicken recipe = PERI(-PERI)
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
Neither did I until I did a search on "peri chicken".
|
|
|
|
|
Interesting - maybe it's just an English thing then... you can't walk down any High Street without every other shop being a peri-peri chicken outlet; about 50% of the (physical) junk mail that comes through the door is for these places too. Never tried it myself! 
Google peri peri chicken results for me[^]
|
|
|
|
|
I'm in Surrey UK.
"I didn't mention the bats - he'd see them soon enough" - Hunter S Thompson - RIP
|
|
|
|
|
peri-peri chicken. But the word only needs half of that.
|
|
|
|
|
So far, so good. But we are only at the blue "Updates are underway" screen, so there is plenty of scope for OhMyGawd to occur.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
So you're downloading on a line an update for your surface which will be written on it's system volume. We're a small step before jumping into hyperspace.
GCS d--(d-) s-/++ a C++++ U+++ P- L+@ E-- W++ N+ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t+ 5? X R+++ tv-- b+(+++) DI+++ D++ G e++ h--- r+++ y+++* Weapons extension: ma- k++ F+2 X
|
|
|
|
|
Software Zen: delete this;
|
|
|
|
|
It worked good on my Surface, you may be lucky as well 
|
|
|
|
|
A looong time ago, as part of a middleware builder I wrote, it would generate SQL-DDL scripts to create tables and the stored procedures necessary to access them.
One of the things it did was use text cursors to run regular expressions over fields to validate them. Basically, it generated the SQL code to use a table based state machine to walk the fields and validate a regular expression so that if you passed a phone number or an email address in as a string it would reject invalid candidates.
The same thing happened at the middle tier, and at the front end web page, so no matter how you hit it, it would *not* let you put invalid data in the database.
I've almost never seen this done in practice elsewhere, but it has been a long time since I've done this kind of development professionally, and I was wondering how common a practice it is (maybe using some of the newfangled SQL Server features for example) to do granular field validation like that?
One reason I ask is because I have a tool that can potentially generate the SQL-DDL scripts to do this, but I don't know how useful it would be to people in practice.
Real programmers use butterflies
|
|
|
|
|
Not really, but the applications I work on don't take user input. My responsibility is pretty much just ETLing data from other places into a staging database (mostly with SSIS).
There are some places where we check for IP addresses (in particular), but that's about it.
And to do IP addresses, I wrote a CLR Function which uses .net's System.Net.IPAddress class to convert to VARBINARY(16) or return null.
|
|
|
|
|
Spinning up the CLR/CLI inside an RDBMS makes me feel dirty.
Real programmers use butterflies
|
|
|
|
|
Yeah, baby! 
It's there anyway. And much faster than so many SQL-implemented chores -- text handling in particular.
|
|
|
|
|
A rather similar question came up hear maybe half a year ago. That poster got "corrected" for insisting that browser input validation was enuff.
I would say: that DB-level validation is absolutely mandatory to protect the DB from data corruption. E.g. somebody my try to enter data with their own client (out of malice or just curiosity).
Having data validation-as-you-type is matter of user friendliness. Eg I hate sites that tell you that the password I just entered twice needs more stuff, after having chewed on the entire form for bit.
"If we don't change direction, we'll end up where we're going"
|
|
|
|
|
megaadam wrote: I would say: that DB-level validation is absolutely mandatory to protect the DB from data corruption. E.g. somebody my try to enter data with their own client (out of malice or just curiosity).
Unless you're in a situation where arbitrary applications can write to your database, serverside validation is sufficient. If you have a big-One company database that dozens of different applications use, well Codethulu help you (because no lesser gods can); and yeah then you probably do need to do validation in the DB.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
One problem is that SQL-implemented routines often perform poorly, so "doing it in code" is preferred. So what about when using a Web Service as the front door to the database -- and not allowing direct access to the database? All clients have to go through the front door.
|
|
|
|
|
That works depending on the situation, and depending on how much confidence you have in your DMZ being adequately hardened.
When the database is on a LAN, things become a bit different, but even if it's hooked to web facing internet servers behind a DMZ there is always the chance your webserver gets hacked, and when that happens, they at least have the same access to the database the webserver does. If the database is hardened with routines like this it can at least limit some of the damage.
Real programmers use butterflies
|
|
|
|
|
Yeah, see? I don't do that Web stuff.  I stay in the back end and keep my head down.
|
|
|
|
|
I *am* talking about the backend. This is a statement about infrastructure, not front end coding. If your DB is on a LAN, there's a good chance there's no DMZ which means a disgruntled employee could poison the database, probably pretty easily, unless there's security on the tables and validation.
Real programmers use butterflies
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
