20 Jul 2010
So I created a poorly constructed 'SELECT' query in a stored procedure and I was up late last night trying to figure out how I could best optimize it. After sitting in my 94 degree basement for a few hours, I thought of using hashed values via CONCAT and MD5 functions to create an index of multiple...
15 Jul 2010
Several battles have been brewing from within the WordPress community.
It's WordPress, not Wordpress dangit!
A couple weeks ago, a snippet of code got sneaked into WordPress 3.0. The function, capital_P_dangit, is a filter that replaces "Wordpress" with "WordPress" throughout...
12 Jul 2010
There has been a lot of (virtual) ink spilled over HipHop, Facebook's new PHP-to-C compiler; but a similar approach has flown a little more under the radar. I'm talking about Quercus, a PHP interpreter/compiler written in Java by Caucho, the makers of the Resin app server.
Quercus is a...
24 Jun 2010
One frequent request we get from clients is to integrate their Drupal web site user profiles with a Customer Relationship Management (CRM) system so that their users' information can be used for email messaging and other purposes.
We've worked with a variety of CRMs including CiviCRM, ...
15 Jun 2010
In my last post, I glossed over MongoDB from a very high level. While it's useful to know how MongoDB works, I didn't cover exactly how to use it.
There are a growing number of NoSQL systems, and one of MongoDB's greatest strengths is its ease-of-use. It takes a couple of minutes to install the...
8 Jun 2010
MongoDB is one of the forerunners in the NoSQL movement, an effort to promote non-relational, schema-free data stores. It lacks any table JOINs, which avoids performance bottlenecks seen with traditional SQL servers.
Why NoSQL?
NoSQL servers are not meant to replace traditional SQL ...
17 May 2010
This week I'm participating in the Tek-X conference, one of the bigger PHP conferences (along with ZendCon) around.
I'm looking forward to some pretty epic geekery on the language itself, as well as scaling with MongoDB, battling users who attempt to "game" your system, and general OO PHP...
14 May 2010
At Forum One, MySQL is the open source database that powers most of our internet solutions. It's flexible, powerful and free. Our confidence extends to one one of the more complex and growing needs facing many of our clients: Data warehousing.
Data warehousing is a method for storing ...
4 May 2010
While at the 2010 DrupalCon San Francisco last week, I had the pleasure of attending Katherine Lynch's session on Accessibility in Drupal 6 & 7. The issue of accessibility is a very important one, especially given the large demographic of users with disabilities. Approximately 20 percent of...
2 May 2010
One of our goals at Forum One is to help our clients achieve a higher level of collaboration. The effective exchange of knowledge is one of the hurdles separating a good organization (or open-source project) from a great one.
An open-source project is only as good as its underlying community. This...
