HeraldicArt.org: Traceable Art | Emblazons | Blog

A SQL Interface for the SCA Armorial

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”

Interfaces to the Armorial Database

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”