SQL Injection Everywhere

  • Comments posted to this topic are about the item SQL Injection Everywhere

  • I think people have really gotten silly with computers. I mean, c'mon! Why would anyone connect a bloody washing machine to the internet?

    More silly stuff... I heard that there was a recall by one of the car makers the other day. Seems like the (I can't believe this) computer controlled windshield wipers were having a problem. REALLY??!! We're paying for that kind of stupid stuff?

    How about spending more time and dollars on really cool stuff like designing a 350HP engine that gets 50MPG without batteries? You see that kind of stuff on the news all the time. How come no one has put that type of technology in common vehicles instead of screwing around with {gasp!} computer controlled windshield wipers.

    Like the quote goes, "No one is sure of the age of the human race but everyone agrees it should know better by now."

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • I think there are many good reasons for connecting things to the internet, and to let them be computer controlled.

    Not to ruin your wind shield story - but I really like the wipers in our car. They are connected to a sensor, and start wiping if the windows get wet. This allows me to keep my limited focus on the road. And the wipers are just a small part. I believe that all these small things in cars can help us focus more on the road and drive safer.

    But I totally agree, that when they mess up and need to recall cars because of what must be a critical error in the wiper software - then something might not be as decoupled as it should have been. And sooner or later we will all be driving autonomous cars - and then we can start worrying about software bugs... 🙂

    For the other "connected" items, I would agree that maybe the washing machine isn't the most obvious. But still there could be some features which could come in handy. You could start the machine when you start driving home from work (even when you don't know when work is done), it could call on service if some small problem has occurred, instead of today where they just keeps going and then breaks completely (good for the environment I guess), receive updates to the built-in programs to be more efficient (in strong opposition to the "If it ain't broken, don't fix it" rule), etc.

    But we need to remember that no matter how much we test our software, when we move from mechanical controlled to software controlled we will introduce some new risk, and some new bugs. And those can be hard to fix in e.g. a non-connected washing machine.

    /Anders

  • Jeff Moden (4/10/2011)


    More silly stuff... I heard that there was a recall by one of the car makers the other day. Seems like the (I can't believe this) computer controlled windshield wipers were having a problem. REALLY??!! We're paying for that kind of stupid stuff?

    You mean you don't mind turning your windshield wipers on and off? 😉

    My cars has automatic headlights, and after having driven it for a while, it was a real shock when I drove a rental car into a parking garage, and it was like, why is it so dark in here and I can't see? Duh, I have to actually turn the head lights on.

    In terms of cars everything that can reasonably be automated, without significant risk, that takes a distraction away from the driver is a good thing in my opinion. (How many people do you see driving at twilight without their lights on?)

  • Anders Hansen (4/10/2011)


    I think there are many good reasons for connecting things to the internet, and to let them be computer controlled.

    Not to ruin your wind shield story - but I really like the wipers in our car. They are connected to a sensor, and start wiping if the windows get wet. This allows me to keep my limited focus on the road. And the wipers are just a small part. I believe that all these small things in cars can help us focus more on the road and drive safer.

    But I totally agree, that when they mess up and need to recall cars because of what must be a critical error in the wiper software - then something might not be as decoupled as it should have been. And sooner or later we will all be driving autonomous cars - and then we can start worrying about software bugs... 🙂

    For the other "connected" items, I would agree that maybe the washing machine isn't the most obvious. But still there could be some features which could come in handy. You could start the machine when you start driving home from work (even when you don't know when work is done), it could call on service if some small problem has occurred, instead of today where they just keeps going and then breaks completely (good for the environment I guess), receive updates to the built-in programs to be more efficient (in strong opposition to the "If it ain't broken, don't fix it" rule), etc.

    But we need to remember that no matter how much we test our software, when we move from mechanical controlled to software controlled we will introduce some new risk, and some new bugs. And those can be hard to fix in e.g. a non-connected washing machine.

    /Anders

    Maybe I'm over-simplifying but you don't need a computer to interface the sensor to your windshield wipers to have it work. You also don't need a computer to turn the lights of your car on when you drive into a dark spot. A simple sensor will do that without the need for a computer.

    I subscribe to a satellite TV company. One of the requirements to "get the discount" is to always have the receiver connected to the phone line. I had to run that phone line because one didn't exist where the TV was.

    And what would they do to the software running a washing machine? Change the timers? That justifies a full time internet connection? And it won't fix the most common aliment of having the little cross of rubber between the motor and the clutch wearing out even on computer controlled washers.

    I love technology. It's been used to do some pretty good things. I just think people are getting carried away with its implementation in a lot of areas.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden (4/10/2011)

    How about spending more time and dollars on really cool stuff like designing a 350HP engine that gets 50MPG without batteries?

    Because it's impossible? Petrol and diesel engines are not far off as efficient as they possibly can be right now--350HP while still getting 50mpg is a pipe-dream, I'm afraid. It's still possible to get 50mpg, though, just buy a smaller car!

  • Talk of SQL Injection always reminds me of this xkcd comic, which should never be forgotten by database professionals - Little Bobby Tables[/url]

  • paul.knibbs (4/11/2011)


    Jeff Moden (4/10/2011)

    How about spending more time and dollars on really cool stuff like designing a 350HP engine that gets 50MPG without batteries?

    Because it's impossible? Petrol and diesel engines are not far off as efficient as they possibly can be right now--350HP while still getting 50mpg is a pipe-dream, I'm afraid. It's still possible to get 50mpg, though, just buy a smaller car!

    Heh... Impossible? Not with all the waste heat collected by the cooling system or blown out the tail pipe. What's the effeciency of today's engines? IIRC, If they even come close to 20%, it would be a miracle.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • There was a news story this weekend reporting that distracted driving is becoming an epidemic in the country. There was an increase of 13,000 additional car accidents all attributed to distracted driving. Ford Motor company is now facing multiple law suits (as are other car companies) based on them building in Tom-Tom's and other various digital distractions into their new model cars.

    Yes, it is scary that at some point, controlling our worlds digitally seems so much like the old "Jetsons" cartoons, but the reality is that the more we come up with these (usually) bad ideas, we only increase the 'playground' for hackers. Add that to the distracted and disconnected society we are building and all the images of the "bright future" technology would bring us, suddenly dims.

    What we have lost in the last three decades is simple; we used to build technologies to address problems - now we build them for nothing more than 'because we can', and all the better if we get people hooked on it - who cares about the rising death and injury toll, let alone the danger of too much bleach in your wash - there's money to be made.

    So, a few will get rich, some will get hacked and have too much bleach in their colors, and thousands will die and be maimed all in the interest of almighty dollar.

    Welcome to the future; a hackers paradise of ill-thought out technological wonders.

    There's no such thing as dumb questions, only poorly thought-out answers...
  • First, you mention that turning up your refrigerator is not that bad, but what if it was more malicious -- say they turn it up while you're gone during the day, then turn it back down in the evening. You may not be aware that your food is potentially unsafe. Botulism and other types of food poisoning can be life threatening.

    I think it speaks volumes about human nature when one of the biggest selling items is an aluminum wallet.

  • There is LOTS of silly fluff in cars, and lots of unnecessary automation. If you can't determine when you need your wipers on, you do not belong behind the wheel. And an unexpected activation of the wipers might be more of a distraction than reaching for the knob.

    We don't need to talk to our cars. We don't need the many additional points of failure that occur when basic functionality becomes dependent on a central computer.

    One side point is that the manufacturers now have a guaranteed source of income: many things are impossible to change on a care without a visit to the dealer to have the computer updated (such as adding trailer lighting, or adding speakers to the radio).

    Some things benefit by addional control but much of this is simply ridiculous.

    ...

    -- FORTRAN manual for Xerox Computers --

  • Anders Hansen (4/10/2011)


    Not to ruin your wind shield story - but I really like the wipers in our car. They are connected to a sensor, and start wiping if the windows get wet. This allows me to keep my limited focus on the road. And the wipers are just a small part. I believe that all these small things in cars can help us focus more on the road and drive safer.

    /Anders

    CRINGE! Limited focus? No offense intended, but anyone who is that limited should not be driving. I have this image of some 90-year old, ready to die any second, barely able to see the windshield, much less the road, person driving a huge Escalade or some other monstrosity because "I have a right to drive and you can't stop me!"

    Seriously - there comes a point where automation is wrong. Anyone who has to think about where to turn on the wipers is a very poor driver. Before anyone starts the car, they need to familiarize themselves with the controls. Too many people have no regard for the safety of others, and feel they can do whatever they want. Those people need to pay attention to driving, not their cell phones, passengers, radio or makeup! Full focus, not limited!

    Dave

  • UMG Developer (4/10/2011)


    In terms of cars everything that can reasonably be automated, without significant risk, that takes a distraction away from the driver is a good thing in my opinion. (How many people do you see driving at twilight without their lights on?)

    Here's an alternative thought, instead of taking away distrations like whether they can see where they are going, maybe we should take away their driver's licenses instead. Sheesh! We really have lost it in this country - we complain about soccer moms on the phone, but find some idiot who can't see or be seen, we want to automate it for him.

    My vehicle has automatic lights - I never use them. I, imagine this, actually know where the switch is and use it when appropriate.

    I remember the Star Trek NG episode about the people who stole children from the Enterprise. The main theme was that they depended upon their technology to do everything, and nobody understood how it worked, or how to fix it. You can automate things to the point that you hurt yourself. I think we are past that point already.

    Dave

  • Once a smart team of engineers create a really practical piece of technology, it's inevitable that the consumer marketing industry will come along behind them, FUBAR the technology, and then dump it upon the public with the intent of turning a profit. Back in the late 90's I knew a guy who worked for TD WaterHouse, and he would tell me stories of online trading customers who would do crazy stuff like place an order for 100 shares instead of 10 or enter an order for the wrong stock symbol and then go completely nuts.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • Maybe Electric Dreams[/url] will become a reality. Hey, it was made in 1984.

Viewing 15 posts - 1 through 15 (of 46 total)

You must be logged in to reply to this topic. Login to reply