this post was submitted on 22 Jul 2023
1065 points (98.8% liked)
Games
32670 readers
1209 users here now
Welcome to the largest gaming community on Lemmy! Discussion for all kinds of games. Video games, tabletop games, card games etc.
Weekly Threads:
Rules:
-
Submissions have to be related to games
-
No bigotry or harassment, be civil
-
No excessive self-promotion
-
Stay on-topic; no memes, funny videos, giveaways, reposts, or low-effort posts
-
Mark Spoilers and NSFW
-
No linking to piracy
More information about the community rules can be found here.
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Napkin maths to illustrate the point: Steam's game IDs are short numbers, typically close to 5 digits long. ASCII characters are one byte each, so let's assume 5 bytes plus one more for a separator character per game. If you wanted to store 8 billion accounts with 50 games each then the IDs would be about 2.4 TB, so a consumer hard drive worth ~$100 would do the job at least in the raw terms of data capacity
Your sums are right, but a 'hard disk somewhere' is not a robust, always on-line database. Running a 3TB Postgres instance on Amazon RDS will set you back something more like $1k/mo. Still absolute pocket change for Ubi, though.
https://calculator.aws/#/addService/RDSPostgreSQL