Home ›

Development Blogs

Post Date Title and Contributor Comments
May 04, 2012 SQL 101: Sub Queries
Shannon Lowder

In my next post Ill introduce you to JOIN statements. After youve been introduced to both these techniques consider the performance of a sub query against the performance of a JOIN. You will always want to choose the option that runs quickest with the correct results.

 0
Apr 20, 2012 Five Tips for Drupal Newbies
Adam Waid

The attendee list at this week’s Atlanta Drupal Meetup group ran a wide gauntlet. There was a mix of business owners, newbies, marketers, and even someone with a Drupal.org ID under 1000. We broke up our normal presentation format and had informal talks about Drupalcon Denver, the job market, and trends.

 0
Feb 16, 2012 SQL 101 - Summarizing Data (Part 2)
Shannon Lowder

How would we find out the total number of pencils I purchased? You could do that with a WHERE clause. What if I wanted to see a quantity of each product I ordered? Now that's different. If you need to use an aggregate function and break down that aggregate by categories (or groups), then you're going to need to learn the GROUP BY clause. This clause will help you summarize data by these groups. So basically I'm going to teach you an add-on to the aggregate functions lesson. Let's dive right in.

 0
Feb 02, 2012 Using PHP to Add Content to Plain Text
Scott Eiler

In my last blog message, I described how I use a converter to HTML-ize plain text. This is useful for taking URLs like http://www.eilertech.com/work/resume.htm and producing a link. Now that I convert each text file before display, I can add content.

 1
Jan 23, 2012 The Technical Realities of Cloud Computing: MATRIX Whitepaper
John Brothers

Everyone knows what Cloud Computing is. No one knows what Cloud Computing is. How can this be? Because Cloud Computing, like many buzz words, has been adopted by so many different organizations, people and disciplines, that it has no specific meaning anymore.

This white paper is an attempt to create some structure around Cloud Computing - to explain the different types of technologies that are all currently living under the “Cloud Computing” umbrella, and to describe the types of problems that these technologies are good at solving.

 0
Jan 16, 2012 SQL 101 - Summarizing Data (Part 1)
Shannon Lowder

When beginning to learn SQL, it won't be long until you have to answer questions that require you to summarize the data. It's one of the primary reasons SQL is used. You store many records detailing events, then you can summarize that data and report it back to users, so they don't have to summarize it by hand.

 0
Dec 29, 2011 Using PHP to HTML-ize Plain Text
Scott Eiler

I used to write my web site purely as HTML. Whenever I needed to post something as plain text (for instance, a resume on a job site), I would just cut and paste the text from my web browser into the plain text field. But that way, the links get lost. Enough people asked me for my links, that I started doing things the other direction: write the plain text, then convert it to HTML. I'm using the PHP scripting language for this.

 0