Book Review—Citizen Designer: Perspectives on Design Responsibility

A long time ago I briefly worked to help promote a political campaign. The campaign wasn’t for a candidate running for office, but rather an amendment to the state constitution or something along those lines.

Continue reading

How To Create And Add Indexes To MySQL Tables

For the last couple of weeks I’ve been talking about indexes and how they help speed up database searches. I talked about their pros and cons and then talked about the different types of indexes and when each is appropriate.

Continue reading

The Types of Indexes You Can Add To MySQL Tables

As useful as indexes are to finding information in a database, they aren’t all created equal. Sometimes you need to find specific values in a table and sometimes you need to find something inside a specific value, say a blob of text. Not all indexes are suited for every task.

Continue reading

The Benefit Of Using Indexes In Database Tables

It takes time for a database to search through row upon row of information and find specific values. It’s a task made more difficult as rows of data are removed and new ones are added. Over time, data can be stored more randomly than you would think or like. Indexes are a way to overcome this and to help make it quicker to find values in database tables.

Continue reading

The End of View Source?

I remember when I first learned how to build websites. I would read books after coming home from my job testing software and I would build the simplest of web pages to practice what I read about. A few nights a week I took continuing education courses on my way toward earning a certificate in website design or something to that effect.

Continue reading