Vos Virtual Network

Author Archive

Book Review: MySQL in a Nutshell, 2nd Edition, by Russell J.T. Dyer, published by O’Reilly Media, April 2008, 545 pages, ISBN:0-596-51433-6, price: US $34.99 (Reviewed by Daniel Vos)

MySQL in a Nutshell, 2nd ed.

Behind virtually every web application, there’s a database management system.

Ever used Facebook? Guess what? It runs on a (huge!) database. What about your favorite discussion forum? Are you into auto maintenance, fly fishing, or (if you’re like my wife) do you like to swap recipes, trade amusing anecdotes about your kids, or post blog articles? All database-driven.

Many of the most popular, thriving websites are database driven. Behind the scenes many Web 2.0 websites are running MySQL, Sun Microsystem’s open source database. (There are other popular databases from Microsoft, Oracle, and IBM — but that’s another story.)

MySQL is the M in LAMP — the very popular Open Source web site platform/framework (Linux, Apache, MySQL, Perl, PHP, Python). MySQL is the database used with WordPress (the software that runs this VVN blog). MySQL is the default database server used with Ruby on Rails.

If MySQL is the world’s most popular open-source database, then MySQL in a Nutshell (2nd ed.) by Russell J. T. Dyer is the Encyclopedia Britannica of MySQL. Weighing in at 545 pages, the book is divided into five parts:

1. Tutorial – A brief tutorial on installing MySQL and performing basic database management tasks (35 pages).
2. Statement and Function Reference – A comprehensive reference to SQL statements, clauses, and functions implemented by MySQL. (SQL is the standard language implemented by all major database management systems, but MySQL, Oracle, MS SQLServer, and the rest all have their own quirks.) This section weighs in at nearly 300 pages, and covers database user administration, data manipulation, and database replication, and more. String function, date and time functions, mathematical functions, and flow control functions are described here, too.
3. Client and Server Administration – A guide to MySQL server and client configuration and administration (90 pages). This is where you will learn the difference between mysqld (the database server) and mysql (the command-line client), and the configuration options of each. A reference to command-line utilities such as mysqladmin, mysqlcheck and mysqldump is also included.
4. Programming APIs – A 100-page guide to three popular programming language APIs – C, Perl, and PHP – which websites or programs use to interface with MySQL.
5. Quick Reference – A 15-page set of appendices with a quick reference to the data types, operators (arithmetic, relational, and logical), and environment variables used by MySQL.

If you are an absolute beginner to MySQL and database management systems, this book might not be the best first choice for you. A good place to start instead might be here. But if you know that MySQL is in your software development or web site development future, MySQL in a Nutshell deserves a place on your bookshelf.

Editors Note: Special guest author, Daniel Vos was invited to write a book review of Designing with Web Standards. Daniel is a graduate of Washington and Lee University (and also studied at Oxford.) Currently, he is an academic coordinator, budding web designer, and occasional writer for Roanoke area newspapers and business journals.

In my last post, I explained five reasons why Designing with Web Standards by Jeffrey Zeldman is a must-read classic of web design. In this post, I want to start a conversation about new developments in web standards since the second edition of the book was published two years ago.

As DWWS 2nd edition went to press in the second half of 2006:

• Internet Explorer 6 was the most popular browser, with about 77% of the market share; meanwhile, Firefox 1.5 ran a distant second in popularity, at 10.5% of the market share. (Source: Market Share).
• Internet Explorer 7 was just being released.
• Not long after its first birthday, Ajax was already (to quote Zeldman) “stealing the rich applications market from Flash and generating nutty and probably unsustainable excitement.”
• Microsoft was about to release Expression Web, a relatively standards-compatible WYSIWYG web page editor to replace its notoriously bad FrontPage editor and compete with Adobe’s standards-compatible Dreamweaver.
• Implementations of CSS across browsers remained inconsistent: Zeldman documented the Float bug in IE6/Windows, and other standardistas recommended the Simplified Box Model Hack to address different interpretations of the CSS box model.

Here’s where we stand today:

• Internet Explorer 7.0 has less than 50% of the browser market share, although IE still dominates nearly 75% of the market. But Internet Explorer use overall has been steadily declining as Firefox, Safari, and Opera continue to win more users. (Source: Market Share).
• Browser bug watchers are still at it, and still finding new bugs and workarounds: See, for example, Position is Everything.
• The Web Standards project has launched AcidTest 3.0, which tests CSS, DOM, ECMAScript, and XML compliance. Verdict? All browsers still have plenty of room to grow — some more than others, I’m afraid!
• Opera recently announced their Web Standards Curriculum, which they plan to complete by Sept 2008. Here’s hoping they finish what they’ve started. This could be a big help for those educating the next generation of web designers.
• Finally, the ability to separate content from presentation via semantic XHTML markup and CSS will continue to be crucially important as the mobile web browser market grows. The W3C Mobile Web Best Practices are worth a glance, given predictions that there will be 82 million Internet-enabled mobile devices within three years.
• Adoption of web technologies which promote greater interactivity continues to grow. Was Zeldman right about Ajax generating unsustainable excitement?
• Big software publishing companies such as Microsoft and Adobe seem to be making their products more and more standards-compatible.

Web standards remains an exciting field, because new standards are still emerging, and using them (rather than proprietary solutions) is still the best way to publish elegant, attractive, findable, and accessible content. Books like Designing with Web Standards by Jeffrey Zeldman got the ball rolling, and now it’s up to us to use the Web to market our products and services, target our audiences, and (perhaps most importantly) to build and sustain relationships.

I’ve said my bit. What do you think? What are some of the most important developments in web standards in the past 18 to 24 months?

Editors Note: Special guest author, Daniel Vos (son of Douglas Vos) was invited to write a book review of Designing with Web Standards. Daniel is a graduate of Washington and Lee University (and also studied at Oxford.) Currently, he is an academic coordinator, budding web designer, and occasional writer for Roanoke area newspapers and business journals.

This is the first in a series of posts on a book that has become essential reading for web designers. The book is the second edition of Designing With Web Standards (DWWS) by Jeffrey Zeldman, published in 2007 by New Riders in association with AIGA.

Designing With Web Standards by Jeffrey Zeldman

Two reasons you might hate this book:

1. If you’re a sloppy web designer who doesn’t care about making the content of the web site you’re designing both beautiful and accessible to the widest possible audience of users, you’ll hate this book. Mr. Zeldman chose the title – “Designing With Web Standards” carefully: His book is about designing web sites using the most up-to-date standards published by W3C and ECMA, whose web sites have never represented the vanguard of graphic design. Mr. Zeldman cut his teeth in the “paper publishing” graphic design and copy writing business before the web changed everything in the 1990s. DWWS is not an encyclopedic catalog or desk reference to the fundamentals of web standards. It’s a playful Wonka-esque romp (as in Willy Wonka) through the wonders of web standards which gives copious examples of practical ways in which you can use web standards to optimize both your products and processes to result in more effective, more usable, and more attractive websites.

2. If you read W3C specifications for fun and pleasure, and keep the most recent edition of the U.S. Tax Code along with a well-worn copy of Immanuel Kant’s collected works on your bedside table, you’ll probably hate this book. To which I say, in the words of my wife: “You’re far too smart and far too serious for your own good.” The W3C specifications are publicly available on the web for you to peruse at your leisure, and every web designer should be familiar with them. But if you’re expecting a thorough desk reference to XHTML, CSS, and the Document Object Model (DOM), then this may not be the book for you. Sorry.

Jeffrey Zeldman - Designing With Web Standards

The top five reasons this book is a classic:

1. It’s a clear, witty, and often entertaining introduction to web standards from the perspective of a working web designer, as opposed to a W3C specifications wonk. XHTML controls the structure of a web page, CSS defines its presentation and DOM scripting directs its behavior. The power of web standards lies in learning how to use each standard for its intended purpose. For example, XHTML should not be used to define the presentation of web page: colors, fonts, positioning, and the rest. Au contraire, presentation is a job for CSS. This sort of thing is potentially a sterile topic, but Mr. Zeldman is an engaging writer and as I read the book the pages often seemed to turn themselves.

2. Few have a better grasp of the history, politics, and economics of web standards than Jeffrey Zeldman. As a co-founder of The Web Standards Project in 1998, Mr. Zeldman fought on the front-lines of the battle for a more elegant, usable, and accessible web. In fact, the first hundred pages or so of DWWS contain an eyewitness history of the browser wars and the emergence of web standards. Why is this important? Why bother with the nitty-gritty of early battles between Internet Explorer and Netscape? Because, in the midst of those battles, many web designers formed bad habits which web standards were designed to fix. Not to mention that it makes for great David vs. Goliath story.

3. Great explanations of real-world objections to web standards in a business setting and detailed refutations of these objections. Designing attractive standards-compliant websites is appealing in its own right as an art form, but Mr. Zeldman recognizes that even high-minded web designers need bread for their tables. Well he knows, too, that the typical business website needs a bit more panache than, say, the W3C homepage. For example, DWWS has a chapter on accessibility standards: Section 508 in the U.S., and WCAG in the European Union and most other countries. Everyone who supports human rights – including the rights of the blind, the deaf, and the disabled – should be interested in such standards. But Zeldman also shows how using accessibility standards can improve web sites’ visibility to “blind” web crawlers such as the Google search engine. And who’s not interested in that?

4. Tons of case studies. Zeldman gives us all the gory details. Like Dante in the Divine Comedy, he leads us first through web-site hell (web sites based on inelegant, non-durable proprietary technologies), then through purgatory (transitional strategies for converting web sites from sloppy proprietary HTML into well-crafted Transitional XHTML and CSS), and finally into paradise, where we are afforded the opportunity to gaze upon the beauty and utility of XHTML, CSS, and the DOM (“the trinity of web standards”). See, I told you this book was a classic of web design!

5. An emphasis on practical, standards-compliant workarounds and hacks for problems that still remain in current browser implementations. Web standards have steadily continued to win acceptance since the first edition of DWWS was published in 2002 (e.g., try this Google Trends query), and the most popular web browsers are more standards-compliant than ever. Moreover, web browser software publishers and web site designers are finding that the costs and risks of using proprietary web technologies are growing. But despite the increasing ubiquity of web standards, problems remain. Neither Internet Explorer 7.0 nor Firefox 3.0 are fully standards compliant, untold millions of Internet users still use older versions of browsers, and more and more people are accessing the web from crippled web browsers in cell phones and mobile PCs. Remember those case studies I was telling you about? Lots of them explain standards-compliant solutions for annoying quirks in supposedly standards-compliant browsers, such as different implementations of the CSS box model.

Case closed. Designing With Web Standards is well worth your time and money and highly recommended.

Update, 29-July-2008 /  See Part 2 – Designing with Web Standards Two Year On — or what’s happened in the two years since the 2nd edition of the book was published.