Dilbert Strip Finder

So I'm trying to keep the DSI index more up-to-date than the annual releases that I've been in the habit of lately. So here's a new release only two months since the last one.

The most important feature of release 3.04 is it contains strip descriptions up to 2011-09-30. Other minor features are described in the Changelog file.

It's available on the Downloads page.

Time for another release for the Dilbert Strip Index (DSI) on the download page. Version 3.03 has the following new features:

• Strips added up to 2011-07-31. Grammar corrections to older strips.

See the Changelog included in the zip file for further details.

Grab this from the Downloads page.

Another release for the downloadable Dilbert Strip Index (DSI) is available on the download page. Version 3.02 has the following new features:

- Strips added up to 2010-07-31. Some spelling and grammar corrections to older strips.
- No more strip descriptions containing lists of words from the dialogue. They are all real sentences now.
- Word stemming has been added to the library.

See the Changelog included in the zip file for further details.

You can grab this from the Downloads page.

The Dilbert Strip Finder now uses word stemming during the searches.

This means that searching for the word "meet" will also match "meeting" and "meets."

This will increase the number of hits and hopefully will help you better find the strip you are looking for.

Other than the word stemming, searching the Dilbert Strip Finder is the same as it was. It still uses the MySQL search engine and still has the same set of strips to search (though now this last part will change soon).

Questions? Problems? Drop me a line!

What to Search

There are two types of searching on this website. The Dilbert Strip Finder and the Web Site Content.

The search box on the side navigation bar every page will search the Dilbert Strip Finder.

If you want to search the web site content instead -- say for Pho Ottawa restaurants -- then select the "Search" button on the side navigation bar (with or without entering a search word), and then select the "Content" tab.

Here are some tips for the Dilber Strip Finder:

• Boolean operators like AND, OR and NOT are not recognised. The search engine uses Natural Language mode.
• Not case sensitive.
• Wildcards (using the asterisk) are allowed except at the beginning of words. For exanple, meet* is allowed, but *ful will not work. (In this case, searching for *ful will instead search for ful)
• Search for individual dates using the formats YYYY-MM-DD, YYYY/MM/DD or YYYYMMDD. Wildcards are not available for dates.

Another update to the download section. Version 3.01 is available immediately with the following new features:

- Strips added to 2009-06-14. Some spelling and grammar corrections to older strips.
- Some improvements to an included script.

See the Changelog, included in the zip file, for further details.

You can grab this from the Downloads page.

Here's what's changed:

• Results are ranked by relevance instead of by date
• Pagination works properly
• search by date works. Use the form YYYY-MM-DD or YYYYMMDD
• Searching now defaults to the Dilbert Strip Finder instead of the site content and comments. This happened several days earlier than the other changes.

The search function is based on MySQL's full text search in natural language mode. That means that boolean operators like AND and OR aren't needed. The gory details are at http://dev.mysql.com/doc/refman/5.1/en/fulltext-natural-language.html if you're interested.

One of the side-effects of the natural language mode is that words which occur in more than half of the indexed items aren't available for searching. The only word that this affects is "Dilbert", ironically enough.

After a three month absence, searching on the Dilbert Strip Finder is functional once again. You can search for your favourite strips by typing your words in to the search box on the left, and, after the results, select "Strip Finder".

All strips are indexed from the beginning up until 2009-04-30. In the results, you can see the full title of the book by hovering your mouse over the book name. Or, just select the date to see the strip at the Dilbert website.

The Finder is still rough around the edges, though. For example, pagination does not yet work, and booleans are limited to all your words being "OR"ed together. But I wanted to release this now to get your feedback.

Please don't hesitate to leave a comment or drop me a line on the contact form and say what you think, and how it can be improved.

The Dilbert Strip Finder is being updated and readied for relaunch.

The Dilbert Strip Index (DSI), the data used for searching, has been updated and is available for downloading. It's been about 5 years since the previous release, so it's way overdue.

Highlights of the changes include:

• Strips to 2009-04-30 were added so data for all strips from the beginning are included, though the strips past 2007-02-02 are not complete.
• The data is now in JSON format instead of XML. JSON is easier for computers and people to read and update.
• The strip descriptions and book descriptions are now combined into one download.

For a complete list of changes, see the Changelog file included in the download zip file.

The file is available from the Downloads page.

The data used for searching in the Dilbert Strip Finder is available for download. The latest is version 3.04 and is here:

dsi-3.04.zip (550 kib) released on 2011-10-02.