Game Bundle database plans

[elf]

I'm working on a database for the itch.io megabundles and other bundles I've bought. I have a spreadsheet! I have Google sheets! I have lists! I have something like 10,000 games I have acquired through bundles.

...I need help figuring out how to collect all the info into useful database categories.

I would love to brainstorm with someone(s) who
1. Has something like database experience
2. Has some understanding of video games
3. Has played some TTRPGs; has some idea of the TTRPG industry/hobby area
4. Ideally, has bought at least one bundle and browsed the contents.

(If you haven't, I can suggest the currently-active Palestinian Relief Bundle, 373 items for $8, or TTRPGs for Trans Rights - West Virginia, 529 items for $5.)

Notes & more details:
1. I am doing this in MS Access. There's a vague idea of porting to MySQL later, but I don't speak SQL and couldn't figure out how to get started with it. (I can only work with Access because it mostly looks like Excel. I am not a database person.) A couple of decades ago, I had some basic training with Access queries; I am somewhat aware of types of data fields but it's very very beginner. I do not need a database expert but I need help figuring out how to set up the many-to-many tables.

2. Probably everyone here has enough video game experience. My main focus for this is the TTRPGs; I might like to eventually expand the "video game" category into things like RPGMaker, Visual Novel, Action Platformer, etc. but that's all distant and vague; I just need someone who knows the difference between "this is a video game" and "this is fun software" (e.g. Electric Zine Maker) so I can make the labels accurate.

I do not need someone(s) to sort through the games and figure out which is which - I need help establishing categories and noting what the edge cases are. Help figuring out exclusive video game categories would also be awesome.

3. TTRPGs are the reason I'm making this, with a strong sub-focus on solo TTRPGs. I can figure out how to deal with the games - it's the "not actually a game but definitely TTRPG content" I'm having trouble with.

Should adventure modules be tagged as TTRPGs? What about classes or playsheets? System-agnostic lists of monsters? And so on.

4. It'd help if people had acquired a bundle or two and then tried to find out "what the hell did I just purchase? What is all this stuff?" so they'd understand the scope of the problem. (Multiply by about 40; I have purchased 42 bundles to date.) (Okay, let's call it 35; some of those are basically "developer put their 4 games on sale together.")

I would love to chat, either in comments here (although that's very slow) or on Discord where I can screenshare and say "this is the main spreadsheet... here's my 350 edge cases which are too many..."

Comments

[elf]

Audience is:

1) Me - a way to categorize & sort the games so I can find what I'd like to try, what I'd like to share, etc. "Works for me" is top priority.
2) Other people who have bought bundle games, for fairly obvious reasons.
3) Gamer community in general - so the database could be used as a template for other game databases.

Access has two options for subtags - a yes/no cell (Gonna use this for "does this game need a GM?") and "link this to another table that has the options listed." I don't quite know how to do that, but I don't need to yet - I'm still wading through subcategory options. And main table option.

Option 1: Main table for "Games"; secondary main table for "Bundles" (games can be in more than one bundle);
Games list title, creator, game URL, creator URL, game-sort-as so they'll alphabetize properly (and "2ECONDS TO 2TΔRLIVHT" gets categorized under "Seconds" where I can find it) (there are games whose name is an emoji) - and then categories - main, secondary, etc.

Option 2: No "Main" table. Collection of tables for each main type of game, with only the fields appropriate for that type.

What I'm currently stuck on:
Do I have three main types: Video Game, TTRPG, and Other (includes fiction, soundtracks, zine software, etc.), or are the main types VidGame, TTRPG, Game Assets (art for video games, audio clips for video games, adventure modules, "5 NPCs for your Mork Borg game", etc.), and Other.

...When I search/filter for "TTRPG," should that include
* Adventure modules
* New class/race/region/etc writeups - some for specific games, some generic
* Lists of game content ("30 merchants for your fantasy rpg")
* Non-game content - print-and-assemble dice, essays on how to GM, magazines that might include a little of any of those)

When I search/filter "Video Games," that should include playable games. Should it also include
* Assets for game development - art, audio, maybe other?
* Game dev software
* Other, IDK, maybe there is something else in the vidgame support field I haven't noticed because mostly I've ignored the video game content

The general "Other" category has its own collection of hassles but doesn't matter as much. My notes so far:
* Fiction - Text
* Fiction - Comic
* Magazine/Compilation
* Art Assets
* Audio (Soundtrack etc)
* Nonfiction - Text
* Nonfiction - Comic
* Software (e.g. Zinemaker)
* Other
* Unidentified/untagged yet

...you can see how this gets troublesome. I'm aware that nobody can tell me "you SHOULD have these things in the same filter," but it'd be nice to have some idea on how database setups work enough to know whether some options are smoother than others.

Oh, and somewhere in the mess is probably "add a field for the itch.io tags and another for the listed price," but that is data that presumably could be grabbed by a bot at some point.

[melannen]

If you're prioritizing for you, that makes it somewhat easier, I'd come up with something that does what you need to do and then think about add-ons that might add flexibility for other people. One thing I've found when trying to come up with personal cataloging systems is that taking some of the things I'm organizing and actually shuffling them between piles can really help me figure out my priorities (whether that's actual index cards or using software that's designed for visualizing that or whatever. Making it physical helps my brain spin it a different way and can also help you figure out how the size of the various categories matters to you.)

But yeah a lot of those are more database architecture questions than cataloging questions, and I don't really remember enough about Access to help (I do remember that the "link this to another table that has the options listed" part was where I decided screw it I'll just use a spreadsheet the last time I tried :P )

But I vote for Option 1: main table with everything unless there's a good logistics reason why not; it will make things much more flexible later if you change your mind about what you want your top-level categories to be or where individual items go in them. The only reason I might not would be if I want to go way more fine-grained on on other fields for some things, but even then I might be tempted to load everything into a main table first and then pull out those special categories into separate databases just for them (if the software will let you do that easily!) But as someone who extensively uses library databases, I can tell you that most of them have a lot of fields that are blank on most records because they only apply to certain media types.

For the other: I think it's important to have "video game, playable"; "video game assets, not playable", "ttrpg, playable" and "ttrpg, not playable" as very top-level filters, but I don't know the best way to do that. (I don't think I would ever actually be interested in "All tabletop related, playable or not" or "all game assets, video or tabletop". The only big-bucket one of the four I might want is "all playable games".)

I probably would separate out the game assets from the other-other stuff; 'game devs' is a very specific category of users and non-game-devs probably won't care about most of those, ever, but they might want to browse comics or soundtracks. Whether I did any other top-level divisions on the Other category would depend on if there was one kind of content that was heavily dominating it, probably.

[elf]

ooh, I hadn't thought of "playable" vs "not-playable" as a category. I could do that.

That puts (in my mind) adventure modules in "playable" and TTRPG expansions like "2 new classes" or "12 NPCs for your wizard school" into "not-playable." Cool.

And "Dev" can be a category, with sub-sections software, audio, art. And yeah, most people are never going to care about "30 new pixel sprites for your RPGMaker game." (I mean. There's stuff like "tarot cards in 10x15 pixels" for game assets. Which is nice, but... not actually useful outside of a game design space.) (Also I could be misremembering the size of the tarot cards.)

Dev-Software is interesting to some people. The other stuff, less so.

There is other software but it's rare enough that I'm not worried about it.

So: Play-Vid, Play-TTRPG, Dev -Soft -Audio - Art, Resource-TTRPG...
Read -FicText -FicComic -NonficText -NonficComic, Other -Audio -Art -Misc.

(Soundtracks are Other-Audio. Sound effects collections for video games are Dev-Audio.)

Probably.