Software Development

Acquia used the first day of DrupalCon DC as well as their corporate site to announce the availability of their new service via a public beta program, Acquia Search. Acquia Search is "based on the powerful Lucene and Solr technologies from the Apache project" and "creates a rich index of your site content".  While Apache Lucene and Apache Solr are "free" and open source, the implementation and maintenance of these products can be rather daunting.  Acquia wishes to solve this complexity problem by offering Solr search as a service in their Acquia Network.

Before the beta was available to the public, CMSReport.com was invited by Jacob Singh to join the private beta program to test and review Acquia Search. I have only been using Acquia Search for a week so I still have some learning to do in order to take full advantage of the advanced configuration options in Apache Solr.  Although I'm new to Apache Solr,  I have to say that from a website owner's perspective the implementation of Apache Search was extremely easy.  After I signed up for the service on the network, implementing Acquia Search within the Acquia Drupal CMS was just a matter of activating the appropriate modules and waiting for my content to be indexed by the server.  Acquia Search works straight "out of the box" and I couldn't have asked for anything simpler.

During the past couple years I've had some brief but rewarding content management discussions with Deane Barker from Gadgetopia and Blend Interactive.  Dean has worked with quite a few Web content management systems over the years and appears to be most passionate to using eZ Publish.  Naturally, our discussions almost always involve Dean talking about ez Publish and me talking about Drupal.  Unfortunately, as I am more of a system administrator than a developer, the information I have been able to provide him about Drupal has always been limited.

Smashing Magazine has posted a couple articles to help web developers and designers with their Wordpress and Drupal sites.  Some great suggestions and resources are listed in these articles.

1. WordPress Developer’s Toolbox
2. Drupal Developer's Toolbox

The articles don't include everything, but it's a wonderful start for those just beginning to learn about Drupal or Wordpress.  Link found via Nick Lewis' blog.

One of the neat things about managing a site like CMSReport.com is that discussion on a topic can happen when you least expected. This is exactly what happened in the comment section of a rather benign post regarding a Latin American University's use of the content management system, Joomla! I was thanked by Open Source Community's Amy Stephen, also a Joomla! user, for posting an excerpt from one of the Joomla! working group blogs. Instead of a "you're welcome" I decided to ask some questions that have been puzzling me about the Joomla! community for some time.

The Joomla! community just completed migrating their forum from SMF over to phpBB3. Brad Baker posted some of the details on Joomla.org's use of phpBB3 for their forum. In part, some of the move to phpBB stemmed from Joomla.org's discomfort from bridging GPL applications with non-GPL applications. Baker answers the question in his own way.

Amy Stephen, site leader for Open Source Community, submitted her 5,000th post in the Joomla! Community Forum. The Joomla! community makes a big deal out of these type of achievements and we've covered some of their milestones in the past. You know what? It's hard not to celebrate someone else's contributions to open source communities. Congratulations to Amy!

Amy Stephen's 5,000th post in the Joomla! Community Forum

In 2006, I helped bring a friend's Fish and Tackle store online using open source osCommerce. The project was ugly in both appearance and code as I was merging a legacy site with an SMF forum together with the osCommerce software. As I indicated back then, while osCommerce was functional I was not pleased with the software. I kept on thinking how much easier this project would have been if I had used what I consider as modern CMS's. Specifically, I was thinking Drupal and perhaps even Joomla!.

Except for some Python programming, I've done very little software development this decade with most of my efforts in the 80's and 90's (BASIC, Pascal, Perl, Tcl, etc). Those that know me know I've wanted to dig more into PHP and Ruby, but I have been distracted by one sorry excuse after another.

A couple months ago, I experienced a number of errors at my Drupal site that all pointed to a corrupted database. I believe the problem likely was the caused by a sloppy export/import I performed with the MySQL database while moving the site to a new server.

While my particular database problem was an easy fix, if you really don't know much about databases you may find that you really need some guidance on how to solve problems like these. This article is the process I went through to correct this particular MySQL database problem in Drupal 5 and some general database rules that show why this problem occurred in the first place.

I'm hoping that later today the American version of ComputerWorld will carry the Dries Buytaert article I came across on their Australian site.  The article is an interview with Dries and titled, "Drupal: from a drop in the ocean to a big fish in the CMS World".  Yes, it's a catchy title for the interview, but I like sub-heading even more.