Saturday, January 29, 2022

I think I'm making a Mouse Guard app

So it just so happens that I started running a tabletop RPG, not Dungeons and Dragons, but a quirky little system called Mouse Guard.  All of the players' characters are sentient mice in a world where the Mouse territories are in a fight for survival against harsh elements of the weather, ferocious animals, and other mice.

Anyway, as part of preparing for a game session, I want to flesh out some towns, NPCs, and dungeons.  Some research tells me that I should determine a few attributes in advance.  The NPCs, for instance, should have a goal, a level of education, a trade, and so on.  The town itself should have a main industry, a determined size, a level of wealth, local resources, and so on.  For my game in particular, I want to simulate various political factions, so I want to record a list of relationships between different political factions and trades, so for instance if one faction would make one trade more powerful, a second trade would make that trade less powerful, then a person with that trade should be much more likely to support the first faction.

Anyways, at first I started typing this information into spreadsheets, but I realized that if I put it into a database, I could query and write programs to answer all kinds of questions about the data.  So I decided to do that.

Tomorrow is the second game session, so the best I could possibly hope for is to have a few towns and NPCs in SQLite db browser, but even that is going to be a big help.

No comments:

Post a Comment