When I’m building projects I’m often targeting the library I work for, or a library I work with. Either way, those libraries have their branches and affiliates and so on. Those locations and their information usually get shoved into a database and I’ll pull from that database as needed.
Well, with the FOSSiL Projects, I want to make sure folks have some data to play with, so they can try the software and see how it works. However, I don’t always want to use real world data just so things don’t get screwed up, confused, or otherwise mixed in. Sometimes, you want to keep your chocolate and peanut butter in separate containers, you know?
So I invented a fictional library district, with branches and local community library systems that it works with. That way I can populate databases with information you can fiddle with, but you’ll know that these libraries don’t actually exist. They’re purely used for testing and evaluation purposes and, if you decide to use the software, you can always dump them and add your own data.
That in mind, I do not build creative databases. I try and keep things as straight forward as possible.
So let’s talk about the Sable County Library District, a fictional district in the fictional county of Sable, located in the same state as Springfield, home of The Simpsons.
Sable County Library District, or SCLD, serves a large population over a wide geographic area. For that reason, it has 18 branches. And, because it’s a county library system, it works with local city and town library systems that also operate within the county, but separate from SCLD. There are eight of those. Of SCLD’s 18 branches, there are three regional libraries that act as distribution centres for SCLD branches in their areas. To the north you’ll find Wagner Regional Library. The east side is handled by Baker Regional Library. Out west is the Germanotta Regional Library. These are large library buildings, big enough to hold three or more branch libraries comfortably inside them.
So with that, here’s the layout for SCLD along with the branch abbreviations used in the SCLD library automation system:
- Amuro Branch Library (AMU)
- Baez Branch Library (BAE)
- Baker Regional Library (BAK)
- Bourdin Branch Library (BOU)
- Bowie Branch Library (BOW)
- Clancy Branch Library (CLA)
- Collins Branch Library (COL)
- Crothers Branch Library (CRO)
- Evangelos Branch Library (EVA)
- Germanotta Regional Library (GER)
- Harry Branch Library (HAR)
- Hawkins Branch Library (HAW)
- Kelly Branch Library (KEL)
- Monae Branch Library (MON)
- Rollins Branch Library (ROL)
- Smith Branch Library (SMI)
- Sudo Branch Library (SUD)
- Wagner Regional Library (WAG)
And of the surrounding areas, there are eight local city libraries, which includes a community college library. These are:
- Barrington Public Library (BARR)
- Blue Ridge Library System (BLUE)
- Hartleydale Public Library (HART)
- Knightsford Community College (KNIT)
- Leeburg Public Library (LEEB)
- Lynnport Public Library (LYNN)
- North Heights Public Library (NORT)
- Parkerfield Public Library (PARK)
So now, if you happen to be pursuing some of the software around the FOSSiL Projects and come across these libraries, at least you’ll know what they are!
And, as always, if you have questions or need help setting up anything you find here on the FOSSiL Projects, let me know.
cyberpunklibrarian (at) protonmail (dot) com