Hacker ...
A person who enjoys exploring the details of programmable systems and how to stretch their capabilities, as opposed to most users, who prefer to learn only the minimum necessary. - Jargon File
“The supreme accomplishment is to blur the line between work and play.” - Arnold Toynbee
I have been designing and developing computer software solutions for over 20 years. I am a Chartered IT Professional awarded by the British Computer Society and a Fellow of the Institution of Analysts and Programmers.
Currently I run my own Software Development and Computer Consultancy company. In addition I also run Arten Books which provides new and used discount books through the Amazon Marketplace.
I am a Motorcycle fan, an avid reader of sci-fi, fantasy, history, thrillers and technical books, a guitar player, a traveller and a father.
In addition I have a special interest in ancient cultures, their technologies and beliefs, such as the Egyptians, the Aztecs, the Greeks and the Romans.
In September 2009 one of my products R10Cipher: Email, Text and File Security, was shortlisted as a Finalist for the 2009 Information Security Product of the Year award.
Contact Details:
stevecholerton@mac.com
2010
About
Acceptance
Adventure
Advertising
Air Ambulance
Arten Science
Award
BCS
BMW
BNI
Bob Walsh
Book Review
Books
Buggy
Charity Ride
Computing
ContaX
Crash
CrM
Cross Platform
Customer
Dan Walsh
Database
Derby Royal
Digital Filing
Download Sites
eBook
Encryption
Enduro
Experience Engineering
Feedback Needed
Finalist
First Lesson
Fitness
Flying V
For Sale
Foundation Trilogy
Freeware
Function
Galactic Empire
General
Good Eating
Grumble
Guest Post
Guitar
Horizons Unlimited
Humbucker
Humour
Internet Scam
Issac Asimov
Jessica Cholerton
Joke
JustWrite
K1300r
KLX-250
Left Tibia
Lou Carbone
MacVCR
Madeleine
Motorbikes
Motorcross
Movie
New Bike
New Car
Off-Road
OoSooM
Operation
Orac
Oracle
Phishing
Phoenix Chapter
Poem
Police State GB
Presentation
Productivity
Progress
Promotion
Pub
R10BatchMail
R10Cipher
R10Office
Range Rover
REALbasic
Recommendations
REplace
REview
Roadster
Robots
Rocket III
Rudyard Kipling
Secure Vault
Security
SeO
Small Crash
Software Economics
Software News
Software Release
Startup Success Guide
Steve Cholerton
Tailored Marine Supplies
Tax Refund
Technical
Testimonials
The Stig
Trail Riders Fellowship
Triumph
Yacht Bedding
Yamaha
Jun 2010
May 2010
Apr 2010
Mar 2010
Feb 2010
Jan 2010
Dec 2009
Nov 2009
Oct 2009
Sep 2009
Aug 2009
Jul 2009
Jun 2009
May 2009
Apr 2009
May 2010
Apr 2010
Mar 2010
Feb 2010
Jan 2010
Dec 2009
Nov 2009
Oct 2009
Sep 2009
Aug 2009
Jul 2009
Jun 2009
May 2009
Apr 2009
- 2010
- About
- Acceptance
- Access Control
- Accident
- Adventure
- Advertising
- Air Ambulance
- Amplification
- Andrew Deacon
- Andy Farrell
- AppleTV
- Arten Science
- Article
- Audi TT
- Avatar
- Award
- BCS
- Birthday
- Black Sabbath
- Blackstar
- Blu-Ray
- BMW
- BNI
- Bob Walsh
- Book Review
- Books
- Buggy
- Can-Am
- Car Porn
- Caravan
- Charity Ride
- Children
- Chinese Quotation
- Cold Steel
- Come on England
- Common Sense Party
- Computer Consultancy
- Computing
- Concept
- Connor McCloud
- Consumer Rights
- ContaX
- ContaXCRM
- Cornerstone
- Coupon
- Crash
- CrM
- Cross Platform
- CSP
- Custom Shop
- Customer
- Customer Service
- CuteCipher
- Dan Walsh
- Database
- Decluttering
- Derby
- Derby Royal
- Digital Filing
- Disabled Parking
- Disaster
- Discount
- Dolphins
- Download Sites
- Downsizing
- Dreams
- eBook
- Embrace Danger
- EMG
- Encryption
- Enduro
- Experience Engineering
- Feedback Needed
- Finalist
- Financial Instiutions
- First Lesson
- First Post
- Fitness
- Flying V
- For Sale
- Ford Ranger
- Foundation Trilogy
- Freeware
- Function
- Galactic Empire
- General
- Good Eating
- Great Rock Bands
- Grumble
- GT-8
- Guest Post
- Guitar
- Guitar Tech
- Hagstrom
- Harley Fatbob
- Harley Night Rod Special
- Highlander
- Holiday
- Holly
- Home Entertainment
- Honda
- Horizons Unlimited
- HT-5
- HuBB
- Humbucker
- Humour
- Idol
- If
- Internet Scam
- Introduction
- IPad
- IPhone
- IPhone App
- Issac Asimov
- IT Consultancy
- Jaguar
- James Cameron
- Jessica Cholerton
- Joke
- JustWrite
- K1300r
- KLX-250
- KLX250
- Larry Ellison
- Left Tibia
- Les Paul
- Linux
- Lou Carbone
- Mac
- MacVCR
- Madeleine
- Marketing
- Marshall
- Martin Lewis
- Mayor
- Money Saving Expert
- MonitorMyMac
- Motorbikes
- Motorcross
- Movie
- Music
- Mystical
- Native
- New Bike
- New Car
- Nottingham
- Off-Road
- Online
- OoSooM
- Operation
- Orac
- Oracle
- Outlander ATV
- Passwords
- Phishing
- Phoenix Chapter
- Photographs
- Poem
- Police
- Police State GB
- Politics
- Poster
- Presentation
- Press Release
- Productivity
- Progress
- Promotion
- Protect
- PS3
- Pub
- Quarry
- R10
- R10 iPhone Application
- R10BatchMail
- R10Cipher
- R10Office
- Range Rover
- REALbasic
- Recommendations
- REplace
- REstoration Project
- REview
- Roadster
- Robots
- Rocket III
- Rudyard Kipling
- Russia
- Scrambler
- Screen Recording
- Secure Vault
- Security
- SeO
- Small Crash
- Snow
- Social Business
- Social CRM
- Social Media
- Software Development
- Software Economics
- Software News
- Software Release
- SQLite
- Startup Success Guide
- Steve Cholerton
- Tailored Marine Supplies
- Tax Refund
- Technical
- Testimonials
- The Stig
- TMS
- Trail Riders Fellowship
- Triumph
- Triumph Scrambler
- Tutorial
- UK Election 2010
- Unforgiveable Stupidity
- V-Pick
- VCS
- Version Control
- VTX
- Walkabout
- Walking Stick
- Washburn
- Windows
- World Cup 2010
- Yacht Bedding
- Yacht Supplies
- Yamaha
- Youlgreave
- ZT Club
Oracle REPLACE Function
30/11/09 18:34
I had to do some work for a customer this afternoon which involved replacing a web address located within a SQL string in an Oracle database, with a different web address.
Maybe it’s the drugs (prescription !) but my first thought was to knock together a piece of code to loop through the tables and appropriate columns and perform the substitution.
Of course, that’s ridiculous, SQL already has a REPLACE function which works perfectly in this scenario.
REPLACE(fullstring,old text, new text)
Sorted
The picture below shows the statement in action running in Orac my SQL Tool for Macintosh OSX.
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
Maybe it’s the drugs (prescription !) but my first thought was to knock together a piece of code to loop through the tables and appropriate columns and perform the substitution.
Of course, that’s ridiculous, SQL already has a REPLACE function which works perfectly in this scenario.
REPLACE(fullstring,old text, new text)
Sorted
The picture below shows the statement in action running in Orac my SQL Tool for Macintosh OSX.
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
0 Comments
Good News and Bad News
26/11/09 22:14
Today I attended the Royal Derby Hospital for the triple thrill of X-Ray, Consultant and OT Splint. I was waiting in anticipation for the appointment with the Consultant as today I was to find out if I could start putting any weight on my leg.
The appointment went well, the injury is healing ok and I can now start to put partial weight on my leg, I can even do a small amount of driving once I can bend my leg a bit further.
The bad news is that my brace has to stay on until at least my next appointment in January, and I may well need another operation in the new year to straighten the leg as it has healed slightly crooked.
I’ve abandoned my wheelchair and crutches and am now limping around the house with only my new (rather stylish ) silver finish carbon fibre walking stick which my wife bought me for Christmas. My progress is extremely slow at the moment but it can only improve
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
The appointment went well, the injury is healing ok and I can now start to put partial weight on my leg, I can even do a small amount of driving once I can bend my leg a bit further.
The bad news is that my brace has to stay on until at least my next appointment in January, and I may well need another operation in the new year to straighten the leg as it has healed slightly crooked.
I’ve abandoned my wheelchair and crutches and am now limping around the house with only my new (rather stylish
) silver finish carbon fibre walking stick which my wife bought me for Christmas. My progress is extremely slow at the moment but it can only improve RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
Computer Books For Sale
20/11/09 17:55
I sorted these out just before I had my accident at the end of September and they have been stuck on a table ever since.
You can see the book list here: http://www.artenscience.com/assorted/techbooks4sale.htm
They all have to go so make me an offer.
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
You can see the book list here: http://www.artenscience.com/assorted/techbooks4sale.htm
They all have to go so make me an offer.
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
Another Motorcycling Accident
20/11/09 09:56
My daughters boyfriend came round last night, bandaged up like The Mummy.
After a days Motocross riding at Mallory Park he had fallen off and broken his collar bone.
This has reinforced my wife’s belief that motorcycles are the devils own invention. If it was up to her she’d take a hammer to them
Hopefully I’ve had my fair share of bike related accidents and operations. Surely lightning can’t strike in the same place again ? If my knee heals well enough to ride a bike again then I will do, life is too short to spent time avoiding excitement because of potential danger. That’s not living, that’s existence.
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
After a days Motocross riding at Mallory Park he had fallen off and broken his collar bone.
This has reinforced my wife’s belief that motorcycles are the devils own invention. If it was up to her she’d take a hammer to them
Hopefully I’ve had my fair share of bike related accidents and operations. Surely lightning can’t strike in the same place again ? If my knee heals well enough to ride a bike again then I will do, life is too short to spent time avoiding excitement because of potential danger. That’s not living, that’s existence.
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
Advertising Everywhere, Why Not ?
20/11/09 09:33
If it stops still for long enough it’s going to get an Arten Science logo stuck on it
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
Stunning Yamaha R1
17/11/09 17:41
This is a beautiful, stunning Yamaha R1 Superbike.
Why ? Why Not ?
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
Why ? Why Not ?
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
New Freeware from Arten Science
12/11/09 21:01
New freeware from Arten Science: JustWrite.
Read the screenshot. That’s all it does. Really
Both the Mac OSX and Windows versions can be downloaded from here.
I needed this utility and I needed a break from coding R10Office and the associated decisions regarding installation, trial versions etc. etc. JustWrite was the result of this couple of hours rest from R10Office. I hope other people find it useful.
ContaX CRM with Added Security
11/11/09 17:36
R10Office November Promotion
09/11/09 20:01
ContaX CRM Released
05/11/09 10:21
Finally, Contax CRM has been released. Approximately a month later than originally envisaged, but better late than never.
ContaX CRM is a Contact Relationship Management solution for the Individual, Small Business or Club. ContaX will let you Store, View, Interact and Communicate with your Contacts, Customers, Prospects and Suppliers more Easily and Efficiently than ever before. ContaX is Cross Platform meaning that it runs on Windows (including Windows 7) as well as Macintosh OSX (including Snow Leopard). Your database can be stored wherever you like including hosted / syncronised services such as iDisk and DropBox.
ContaX is part of R10Office which means seamless integration with ...
R10Cipher for Encrypted Text and Email
R10BatchMail for Batch Email Sending
ooSooM for Task Management and Digital Vault Items
The screenshots below are from the Apple Mac and Windows 7 versions respectively:
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
ContaX CRM is a Contact Relationship Management solution for the Individual, Small Business or Club. ContaX will let you Store, View, Interact and Communicate with your Contacts, Customers, Prospects and Suppliers more Easily and Efficiently than ever before. ContaX is Cross Platform meaning that it runs on Windows (including Windows 7) as well as Macintosh OSX (including Snow Leopard). Your database can be stored wherever you like including hosted / syncronised services such as iDisk and DropBox.
ContaX is part of R10Office which means seamless integration with ...
R10Cipher for Encrypted Text and Email
R10BatchMail for Batch Email Sending
ooSooM for Task Management and Digital Vault Items
The screenshots below are from the Apple Mac and Windows 7 versions respectively:
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
Lets Find Madeleine
03/11/09 16:28
An Update ...
03/11/09 13:57
The last week or so has been very busy. On a personal front I was at the Physio last Wednesday and then on the following day I was at the Royal Derby Hospital all morning. I visited three different departments which meant my leg brace had to be taken off and put back on three times ... I was left feeling rather ... sore ...
I did however speak to my consultant who told me exactly what is likely to happen in the future as regards my injury. He was impressed with my progress going as far as to say that he had not seen anyone with this type of injury start recovering so quickly - but he didn’t pull any punches regarding my future use of this leg. The best I can expect is to suffer from Arthritis in the knee, followed by a knee replacement operation in five years.
The problem is that the break to my Tibia Plateau consisted of approximately six large pieces of bone and over one hundred smaller pieces ... This has obviously been repaired as well as possible but there is a good possibility the repair will not take my weight and allow me to walk. I should know in four weeks time when I will try and apply some weight to the joint.
I’ve looked at all the options and possibilities and have contingency plans in place, it’s going to take more than a smashed Tibia to put me in a wheelchair If there is one thing that I learned from my time as a soldier in the British Army it’s that our capabilities are far beyond our expectations and so much can be achieved through sheer belief and determination. Following a Mountain Bike accident a few years ago I have had and recovered from four operations on my spine. I’ll get through this latest inconvenience in the same way.
Every cloud has a silver lining and in this case the silver lining is the fact that I have stopped smoking. My last cigarette was October 2nd, around 2pm as I lay in pain, barely able to move and watching a yellow Air Ambulance helicopter landing a hundred yards away. It’s surprising how easy it is to quit smoking when you are confined to bed in hospital for a fortnight
On the business front things have also been busy. Due to my being confined to a chair at the moment I have had to turn down two lucrative contracts, a Software Development contract and a Security Audit. I have however accepted one software development contract as it came via an old friend who understands the current situation and is willing to act as liaison between myself and the customer. I’ll be starting that contract next week. The last week or so has been spent releasing ooSooM and completing ContaX, which will be released later this week.
ooSooM has been incredibly successful, receiving several five star reviews and having over 1000 registered users already. Of course it helps that ooSooM is released as Freeware !
I’ve had great support from family, friends and customers. Deserving of particular praise is my wife, Judith. While I spend the day sat in a chair like Henry VIII being waited on hand and foot, Judy is responsible for making sure I have food, drink, tablets, toothbrush, cleaning stuff etc. etc. When this is over and I am back on my feet I am going to treat her somehow, show her how much her support and love means to me.
Incidentally, when I mention Henry VIII, I mean I’m more like this one:
than this one: 
Incidentally, please have a look at this page. I have set this up to gather donations for the Derbyshire Leicestershire Rutland Air Ambulance. Please consider donating.
http://www.artenscience.co.uk/artenscience/Pages/donate.html
Anyway, that’s enough for now. Time for me to go and get some work done. ContaX won’t release itself
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker
I did however speak to my consultant who told me exactly what is likely to happen in the future as regards my injury. He was impressed with my progress going as far as to say that he had not seen anyone with this type of injury start recovering so quickly - but he didn’t pull any punches regarding my future use of this leg. The best I can expect is to suffer from Arthritis in the knee, followed by a knee replacement operation in five years.
The problem is that the break to my Tibia Plateau consisted of approximately six large pieces of bone and over one hundred smaller pieces ... This has obviously been repaired as well as possible but there is a good possibility the repair will not take my weight and allow me to walk. I should know in four weeks time when I will try and apply some weight to the joint.
I’ve looked at all the options and possibilities and have contingency plans in place, it’s going to take more than a smashed Tibia to put me in a wheelchair
If there is one thing that I learned from my time as a soldier in the British Army it’s that our capabilities are far beyond our expectations and so much can be achieved through sheer belief and determination. Following a Mountain Bike accident a few years ago I have had and recovered from four operations on my spine. I’ll get through this latest inconvenience in the same way.Every cloud has a silver lining and in this case the silver lining is the fact that I have stopped smoking. My last cigarette was October 2nd, around 2pm as I lay in pain, barely able to move and watching a yellow Air Ambulance helicopter landing a hundred yards away. It’s surprising how easy it is to quit smoking when you are confined to bed in hospital for a fortnight
On the business front things have also been busy. Due to my being confined to a chair at the moment I have had to turn down two lucrative contracts, a Software Development contract and a Security Audit. I have however accepted one software development contract as it came via an old friend who understands the current situation and is willing to act as liaison between myself and the customer. I’ll be starting that contract next week. The last week or so has been spent releasing ooSooM and completing ContaX, which will be released later this week.
ooSooM has been incredibly successful, receiving several five star reviews and having over 1000 registered users already. Of course it helps that ooSooM is released as Freeware !
I’ve had great support from family, friends and customers. Deserving of particular praise is my wife, Judith. While I spend the day sat in a chair like Henry VIII being waited on hand and foot, Judy is responsible for making sure I have food, drink, tablets, toothbrush, cleaning stuff etc. etc. When this is over and I am back on my feet I am going to treat her somehow, show her how much her support and love means to me.
Incidentally, when I mention Henry VIII, I mean I’m more like this one:
than this one: Incidentally, please have a look at this page. I have set this up to gather donations for the Derbyshire Leicestershire Rutland Air Ambulance. Please consider donating.
http://www.artenscience.co.uk/artenscience/Pages/donate.html
Anyway, that’s enough for now. Time for me to go and get some work done. ContaX won’t release itself
RSS Feed: http://feeds2.feedburner.com/Lonelyhacker