Home / Resources / Blog / Technology


Facet queries? Making custom Solr facets for fun and profit.

It sounded like a really simple request: "Is it easy to add a search filter for 'My posts'?". In other words, add a search result facet for posts by the current (logged in) user through the Apache Solr Search Integration module APIs? But then the wheels start turning - we want not just one blind link, but a real facet link that tells us how many results we'll get. Also, if we are filtering by 'My posts' then we probably have an equal use case for the opposite filter 'Posts not by me'. So we really need a facet block with two links and... More

Drupal 7 Apache Solr Search Mastery

It is day two at Drupalcon Copenhagan, and Robert Douglass and I presented this afternoon on Apache Solr Search Mastery. While the concepts in this talk apply to the Drupal 6 versions, all the code examples are taken from the Drupal 7 port of the Apache Solr module. Changes in the Drupal 7 version include wrapping all the data for the Solr query into the $query object and transforming the CCK integration from 6.x-2.x into an integration with the Drupal 7 Field API. Of... More

Module authors: In SQL, don't assume INCREMENT(1) == 2

Trivia question: Suppose you execute the MySQL queries CREATE TABLE t1 (  id INT UNSIGNED NOT NULL AUTO_INCREMENT,  n INT NOT NULL,  PRIMARY KEY (id))INSERT INTO t1 (n) VALUES (100)INSERT INTO t1 (n) VALUES (200) What are the values for the id column in your two rows? If you said "1 and 2", you are in good company but you are mistaken. If you want your module to be good enough to run on Drupal.org or Acquia Hosting some day, keep reading. The correct answer is "they could be anything." On Acquia Hosting, the results are: mysql> SELECT * FROM t1;+----+-----+| id | n   |+----+-----+|  1 |... More

Problem with the Drupal learning curve

What's so wrong with saying "Drupal has a steep learning curve?" Well, it's not the most helpful analogy. And it's one of my pet peeves. I agree, it is a myth. Yes it is. We have to keep in mind that the curve is not the path, and the initial sensation of difficulty comes from getting one's habits unstuck. Using this tired analogy... More

Acquia Search versus Drupal search

It's been several days since we launched Acquia Search commercially. After reviewing the press, articles, comments, and tweets, I wanted to address the question of why we seem to care so much about search and why we can't simply improve Drupal's built-in search module. These questions came up during the beta test period as well, and have even resonated with the WordPress community on Matt Mullenweg's blog. I feel they are important questions to address. I've... More

Acquia Search: benefits for visitors

Why will the visitors of your site care about Acquia Search? For a while now, I have Acquia Search installed on my personal site. To understand what Acquia Search can do for your site, have a look at what it has done for my site. While I have a very simple Drupal site, you should be able to experience some of the benefits of Acquia Search. For example, search for "Drupal" on my site (use the search widget in the sidebar) and you can see the facets that allow you to filter the results by topic, location and industry. Using these facets, it... More

Acquia Search screencast with RedMonk

In this screencast, Bryan House from Acquia discusses Acquia Search with Michael Coté from RedMonk. Great demo, Bryan! More

Acquia Search goes public beta

At Acquia, we've launched Acquia Search in public beta today. As I've previously announced, Acquia Search is a hosted Acquia Network service, delivering the capabilities of the Apache Solr as a web service to Drupal websites of any size. Acquia Search is 100% free for now, and here is our marketing pitch: "Acquia Search can be installed as a module on any Drupal 6 site, and enhances a... More