Feeds

Examples of good practice, or not...

Buyer beware?

  • alert
  • submit to reddit

Boost IT visibility and business value

It's always an issue, when publishing tutorials, as to how much care you take about "good practice" peripheral to the main tutorial subject. What's appropriate when knocking up a quick demo to illustrate the capabilities of a new technology isn't appropriate when the new technology might end up in a business production environment - but you do need to concentrate on the main subject.

David Harper has highlighted this issue (and he might put it a bit more strongly than that) in an email; but the AJAX tutorial he's commenting on is just that, not a MySQL tutorial.

Nevertheless, his comment is well worth reading, I think:

I read part 1 of your AJAX tutorial with interest, and I'm looking forward to part 2, but as a MySQL database administrator, I winced when I saw your instructions on how to add a new user.

You should *never* insert records directly into the mysql.user table. In any case, the grant statement in your article achieves the same result as the "INSERT INTO user" statement immediately above it, and you don't need to follow a grant statement with "FLUSH PRIVILEGES".

Also, you should never routinely give users the grant privilege, since this is a gaping security hole, especially in a web application. In most situations, only the MySQL root user needs to have grant privileges.

Best regards, David Harper

Even so, although we do try hard to get things right, we also try to keep our articles reasonably short, so readers have time to read them. Which means that we can't always cover everything in detail.

I do rather hope that our professional readership isn't relying entirely on Register Developer for its professional "good practice". But, surely, professionals will already be working within a quality Development Process, supported by proper training courses?

I'll get me coat...

The Essential Guide to IT Transformation

More from The Register

next story
Secure microkernel that uses maths to be 'bug free' goes open source
Hacker-repelling, drone-protecting code will soon be yours to tweak as you see fit
NO MORE ALL CAPS and other pleasures of Visual Studio 14
Unpicking a packed preview that breaks down ASP.NET
KDE releases ice-cream coloured Plasma 5 just in time for summer
Melty but refreshing - popular rival to Mint's Cinnamon's still a work in progress
Leaked Windows Phone 8.1 Update specs tease details of Nokia's next mobes
New screen sizes, dual SIMs, voice over LTE, and more
Another day, another Firefox: Version 31 is upon us ALREADY
Web devs, Mozilla really wants you to like this one
Put down that Oracle database patch: It could cost $23,000 per CPU
On-by-default INMEMORY tech a boon for developers ... as long as they can afford it
Google shows off new Chrome OS look
Athena springs full-grown from Chromium project's head
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
How modern custom applications can spur business growth
Learn how to create, deploy and manage custom applications without consuming or expanding the need for scarce, expensive IT resources.
Build a business case: developing custom apps
Learn how to maximize the value of custom applications by accelerating and simplifying their development.