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.
![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png){kind=small}
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
branchandroot
(no subject)
Date: 2024-04-27 07:35 pm (UTC)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.