Clan of the Cats Database Archive

Welcome

Overview

This site is a technology demonstration for the SourceForge project wcdba. At present, this search engine works only for the web-comic Clan of the Clats, by Jamie Robertson. To get started, select a function from the list below:

Search by Strip
All comic strips have been combined into a full-text index, and are searchable by script, characters, date and unique ID.
Search by Character
Characters are searchable by fullname and strip appearances, and detailed appearance statistics are available for each result.
Options
Change the appearance of this site to suit your preference (uses cookies).
Information
Frequently asked questions, such as how to use the archive, make suggestions, or get involved.

Archive Status

The database was last updated on 2006-07-26. It currently indexes comics from the first strip up until 2006-07-15, comprising 1861 strips and 358 characters.

Archive Messages

Article: Searching the Archive

Looking at the server logs, I can see some attempts to try to find strips using keywords, such as change hair. Whilst this works with a keyword-based engine like Google, the Database Archive engine uses very precise boolean logic. So how can you use this feature to find the strip you want?

Let's suppose you wanted to find that strip where Mel is "killed" by Marcus Ferox with a blessed sword. Using keyword techniques, you might try something like Mel killed by Marcus. Unfortunately, in Character:Text mode (the default), the archive will try to match your search as a phrase within someone's speech bubble -- and the result is no matches. Unless you happen to remember an exact phrase from a strip, this approach isn't going to work.

A better idea is to construct a query using the boolean functions. You know that Marcus was present, so you can write Marcus: meaning "Marcus appears in this strip". But you also know that Mel was also there, so you can use the AND operator (+), and write Marcus: + Mel:. That narrows things down to 24 strips, which is better, but not ideal. Remembering a word from the strip comes in really handy at this point; they were having a sword fight, so "sword" is a good bet; Marcus: + Mel: + sword yields just two strips, the second of which being the one in which Mel is stabbed.

To make searches for other people easier in the future, you could suggest that this strip is an important one, and I might add it to Mel's details. From another viewpoint, a blessed sword is an important artifact that really ought to be tracked by the archive, so you might want to tell me that too. If you do that, it really helps if you can tell me the strips in which the sword appears, so I don't have to trawl the archive looking for it.

Finally, don't forget about the Help and Tips. At the bottom of most search pages is a set of examples that explain how to get the best out of each search feature, and how to use boolean logic to aid in your searches.

Recent Bug-fixes

Character-Encoding (2005-01-01)
I've finally managed to fix the symbols that kept showing up whenever a non-ASCII character was used. That took a year to get around to, but hey - better late than never, eh?
Validation Errors (2005-01-01)
Fixed the validation errors introduced by adding the SourceForge logo to the bottom of each page. Note to self: Copying and pasting other people's code is BAD.

Ongoing Work

Proof Reading
The archive is still proof-read only up to about strip 350. That leaves about 1000 strips up to the start of the current storyline that need looking at. Any volunteers? I can supply the data in offline format if that helps.
Maintenance
I've been trimming the back-end down a bit. Nobody used the feedback feature at all last year, so I've taken it out to reduce the cost of maintaining it. I've also fiddled with the directory structures, so if you see any dead links, please drop into the Clan of the Cats forum and tell me about them.
SourceForge project
The biggest change is that this project is now hosted by SourceForge. At present, the biggest weakness of the source code is that it is tied to Clan of the Cats. I hope to make it much more flexible by separating the comic-specific text from the page-generation engine.
Another goal is to create a program to support editing the archive. At the moment, that's accomplished by just one person, using a Microsoft Access 2000 database. That's convenient for me, but not very portable. I'd welcome offers of expertise in this area.