Category: O&A Database

In a recent post, I described how to install the software that drives the College of Arms’ Ordinary and Armorial on your own web site, but if you’re interested in modifying that software, you’ll need to be able to build it from source.

The O&A web search software is bundled into an open-source package named Morsulus-tools, along with the utilities that are used to manage and update the database. Continue reading “Building the O-and-A Search from Source”

When using the complex search form in the SCA’s online ordinary & armorial, each line of the search is typically coded with a weight of 1, and most people never change this value, but setting these weights to other values do allow for some interesting search techniques.

A while ago, I asked on SCA Heraldry Unofficial Chat about how how different folks used these weight fields, and have summarized that discussion below.

Weight values are limited to non-negative integers, and may optionally be prefixed with a “+” or “&” character. Continue reading “Unusual Weights for the O&A Complex Search”

On July 25, 2020, Master Herveus d’Ormonde led a few interested heralds through an online session in which we were able to observe core portions of his workflow as Morsulus Herald, watching as he applied the changes from a recent LoAR to the O&A master database and published the changes to the public O&A web site.

I am attaching my notes from this session below in hopes that they might be of interest to other members of the community, although this is admittedly a fairly-obscure topic with a limited audience. Continue reading “Updating the O-and-A Database”

The Ordinary and Armorial of the SCA is a web-based searchable database of the names and armory registered by the SCA College of Arms over the last five decades.

At its core, the O&A consists of a 125,000-line pipe-delimited text file named “oanda.db” which typically contains a line for each registered item. (Although note that in some cases a name and associated armory are bundled together into a single line, and other times updates result in there being a couple of lines that document a single registration.)

Generally speaking, nearly everyone interacts with this data via the O&A web site, maintained by the SCA’s Morsulus Herald, but in theory you could just read through that text file to find relevant records, or utilize one of the small number of third-party applications which transform the oanda.db file into an e-book or import it into a third-party database engine.

The software that powers the O&A web site is open-source, and packaged in a way that makes it easy to install, as long as you have a machine that meets these requirements: Continue reading “Installing the O-and-A Search on Your Web Site”

As powerful as the Morsulus O-and-A software is, it’s not particularly easy to install and get running on your own computer, and it’s a bit daunting to extend with new functionality.

I had an idea that it would be easier to work with the armorial data if it was loaded into a regular SQL database, and spent my weekend putting together a proof-of-concept implementation.

The results are available as Clerk-0.1.tar.gz, a pair of Perl scripts designed to work with a MySQL database. Continue reading “A SQL Interface for the SCA Armorial”

I’m working on some possible improvements to the web interface used to search the SCA’s heraldic database, known colloquially as the “O and A,” short for “Ordinary and Armorial.”

(Traditionally, an armorial is a printed listing of armory registrations with their blazons and the names of their holders; mundane armorials typically include all, or all of the notable, registrations within a certain heraldic jurisdiction. An armorial is typically organized alphabetically by the holder’s name; in contrast an ordinary is a specialized index used for looking up armory based on its blazon or appearance, grouping registrations under their primary charges.)

For decades the SCA’s armorial database has been maintained and distributed as a delimited text file, but searching it by hand in this format is inconvenient, and so there are several tools that provide an interface to this data. Continue reading “Interfaces to the Armorial Database”