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”