Game Bundle database plans
Apr. 27th, 2024 09:42 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
elf posting in ![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png){kind=small}
indie_gamesI'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..."
...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..."
