Messages

1

Video Game Database Discussion / Re: Adding more detail (extra columns) to game data

« on: January 05, 2022, 05:48:57 pm »

If you're talking "game" and not "release" yes, definitely MSRP changes, because of re-releases.  But also even for a release MSRP changes as publisher will do a permanent price drop, thus game's MSRP was $60 for a year, and then it was $50 for a year, and then it was $40 for a year, and then it went OoP.

I was referring to "per release", yes. Fair enough though, it could be modeled as a relation to a price table containing start/end dates, which could be queried by the purchase date giving the same end results.

It does feel overengineered at that point to me, but it's what would need to be done to capture all the info I guess. It could even capture temporary official discounts that way (mostly applies to digital).

I still think a "MSRP at launch" field would capture the usefulness in a vast majority of cases, however.

2

Video Game Database Discussion / Re: Adding more detail (extra columns) to game data

« on: January 04, 2022, 05:35:26 pm »

The MSRP tends to change from time to time.

You mean for a specific, given game? I'm suggesting a MSRP field per release, not a global one.

Now, if there is a case where it changes like that, i assume it must be for very old games? This doesn't happen today, right?

I know that on several of the North American PS2 titles, there is an estimated value according to pricecharting.com. It tracks what games sold for & what the approximate value was for various years.

I feel like that would be separate information from MSRP, but it could be useful.

3

Video Game Database Discussion / Adding more detail (extra columns) to game data

« on: January 03, 2022, 05:16:20 pm »

Would it be possible to add more fields to the game db model and expose them in the UI?

There are numerous things that come to mind, but here are a few ideas:
- Package size: have a table containing all standard/fixed sizes based on platform (for example, "standard Nintendo switch game case", "PS1 long box", "standard 1-disc CD case", etc), and allow entries to pick from one of those or choose a "custom" value for collector's editions and such. Field would contain all 3 dimensions. Could be tied to the platform value, so that it is not possible to select "PS1 long box" for a SNES game). Package/case size would be really helpful for protectors, as there are some box protectors for all sorts of custom sizes (for example jp Bayonetta Climax Edition)
- MSRP/retail price: for each game entry, add a field that indicates it's MSRP. When adding this game to collections, allow automatically selecting this value for the purchase price, or a custom value (like today) for non-retail purchases, discounted purchases, etc.
- Instead of having a fixed set of 3 pictures (front, back, media), allow adding an arbitrary number of pictures to an entry, and have each entry have it's "type", among for example "case front", "case back", "case spline", "game cart", "game CD", "game manual", etc. This would allow us to capture all contents for every release, including collector's editions
- Print run information: a field indicating how many instances of the release were printed. Limited run companies provide this info, and it may be known for retail releases as well in some cases
- Field indicating the type of the game version. Possible values "original release", "port", "remaster", "remake", "DLC" etc
- Field indicating which game series the release is part of. Ideally would include a separate registry containing all game series. Series could potentially include sub-series. Example: Metroid Prime 2 is part of the Metroid Prime series of games which is part of the Metroid series/franchise.
- When adding the price paid for a purchase (when adding it to your collection) allow picking which currency the price is in. It is very normal for me for example to purchase games in at least USD, EUR, GBP and BRL.
- Separate the concepts of a "release" from that of a "game". A game has 1..n releases. Example: "the JP SNES Prince of Persia release is one of the releases of the original Price of Persia game". Alternatively, as an even more complete model, "the JP SNES Prince of Persia release" is "the JP release of the SNES Prince of Persia remake game", and the SNES remake entry would be separate from the "original" entry. Each "game" entry would have at least 1 "release", for simpler/smaller games, but most of the time multiple"releases", for example jp, us, eu. When searching in the platform, we would then search on "games" by default, and each game would present the releases it has. Lastly, a "game" would not have a publisher, only releases would

I could probably come up with a few more ideas on how to add more information to game entries but just wanted to share the more obvious ones and gather feedback.

4

Video Game Database Discussion / Re: Developer/Publisher Requests

« on: December 30, 2021, 11:39:37 pm »

Skunkape Games LLC, the developer behind Sam & Max Save the world, is missing:
https://skunkapegames.com/

Lateralis, the dev behind Dogworld, is also missing:
https://lateralis.itch.io/