<11muxxer.exe> Man we were talking about the GamesBrainz idea the other day and now I can't get it out of my mind
2024-08-17 23034, 2024
discordbrainz
<11muxxer.exe> I really wanna work on that but I wouldn't know where to begin
2024-08-17 23047, 2024
discordbrainz
<11muxxer.exe> Doubt my backend skills are even remotely decent enough to build such a system
2024-08-17 23006, 2024
discordbrainz
<04elomatreb> you can start small
2024-08-17 23038, 2024
discordbrainz
<04elomatreb> "database of books/movies/games/etc" is a really common thing to build in database classes fwiw
2024-08-17 23000, 2024
discordbrainz
<11muxxer.exe> Yeah but I'm more worried about how to build a project that is scalable and maintainable
2024-08-17 23004, 2024
discordbrainz
<11muxxer.exe> I can model a DB and then build a backend with endpoints for such an idea, but going from that to having a working system beats me a bit, not that I can't outright do it, I just don't think I can do it right.
2024-08-17 23043, 2024
discordbrainz
<11muxxer.exe> I will, however, try to start building something along those lines, at least a working back end with some basic frontend, no auth or much control and validation on data, see what I can achieve at first.
2024-08-17 23001, 2024
discordbrainz
<11muxxer.exe> First thing I'll do is model the DB, if anyone is interested I could really use a hand too.
<04elomatreb> one note would be that you probably want to include a secondary column for stable external IDs
2024-08-17 23048, 2024
discordbrainz
<04elomatreb> MBID-style identifiers are easier to keep stable than normal row IDs
2024-08-17 23032, 2024
discordbrainz
<11muxxer.exe> Such as?
2024-08-17 23057, 2024
discordbrainz
<04elomatreb> UUIDs are good because they will be unique globally
2024-08-17 23011, 2024
SigHunter joined the channel
2024-08-17 23036, 2024
discordbrainz
<11muxxer.exe> I'll try to keep that in mind
2024-08-17 23051, 2024
discordbrainz
<11muxxer.exe> So far the entities I've thought of are: - Game - Game release - Organization - Series - Franchise - Genre - Console/System - Engine/Software/Middleware - Person/Group - Event - Award
2024-08-17 23011, 2024
discordbrainz
<11muxxer.exe> Then all the tables for relationships, naturally
2024-08-17 23004, 2024
discordbrainz
<11muxxer.exe> I've been thinking that some of these could also have BookBrainz and MBz relationships
2024-08-17 23022, 2024
discordbrainz
<11muxxer.exe> Game releases should have barcodes, perhap some other identifiers
2024-08-17 23048, 2024
discordbrainz
<04elomatreb> Series and Franchise seems a bit close
2024-08-17 23058, 2024
discordbrainz
<11muxxer.exe> Relationships with other websites and databases: PSN, Steam, VNDB, HLTB, etc
2024-08-17 23020, 2024
discordbrainz
<11muxxer.exe> Series is thought of as, like, "Xbox Classics"
2024-08-17 23021, 2024
discordbrainz
<04elomatreb> Genre is troublesome because it gets subjective
2024-08-17 23002, 2024
discordbrainz
<11muxxer.exe> Should work as tags but also might add some main genres such as "Action" or "Simulation"
2024-08-17 23050, 2024
discordbrainz
<11muxxer.exe> It's a bit complicated though so might just leave it to tags, really
2024-08-17 23043, 2024
discordbrainz
<11muxxer.exe> Wondering if certain information should be included, such as price on release
2024-08-17 23025, 2024
discordbrainz
<11muxxer.exe> But that might be complicated considering different currencies and that one release might cover various regions or nations with different prices
2024-08-17 23048, 2024
discordbrainz
<11muxxer.exe> Perhaps I should also consider a Expansion or DLC category
2024-08-17 23034, 2024
scrumplex joined the channel
2024-08-17 23041, 2024
scrumplex_ has quit
2024-08-17 23039, 2024
SigHunter has quit
2024-08-17 23009, 2024
iconoclasthero joined the channel
2024-08-17 23048, 2024
scrumplex_ joined the channel
2024-08-17 23054, 2024
scrumplex has quit
2024-08-17 23055, 2024
otisolsen70 joined the channel
2024-08-17 23047, 2024
d4rkie has quit
2024-08-17 23031, 2024
iconoclasthero has quit
2024-08-17 23031, 2024
d4rkie joined the channel
2024-08-17 23037, 2024
iconoclasthero joined the channel
2024-08-17 23050, 2024
iconoclasthero has quit
2024-08-17 23022, 2024
iconoclasthero joined the channel
2024-08-17 23008, 2024
trolley has quit
2024-08-17 23047, 2024
trolley joined the channel
2024-08-17 23022, 2024
iconoclasthero has quit
2024-08-17 23001, 2024
tatar1 has quit
2024-08-17 23025, 2024
tatar1 joined the channel
2024-08-17 23030, 2024
tatar1 has quit
2024-08-17 23017, 2024
tatar1 joined the channel
2024-08-17 23033, 2024
iconoclasthero joined the channel
2024-08-17 23009, 2024
otisolsen70 has quit
2024-08-17 23023, 2024
SigHunter joined the channel
2024-08-17 23012, 2024
minimal joined the channel
2024-08-17 23041, 2024
crism joined the channel
2024-08-17 23050, 2024
bitmap[m] has quit
2024-08-17 23043, 2024
SigHunter has quit
2024-08-17 23050, 2024
SigHunter joined the channel
2024-08-17 23042, 2024
beanbrain joined the channel
2024-08-17 23004, 2024
SigHunter has quit
2024-08-17 23029, 2024
SigHunter joined the channel
2024-08-17 23054, 2024
SigHunter has quit
2024-08-17 23050, 2024
Sciencentistguy has quit
2024-08-17 23003, 2024
SigHunter joined the channel
2024-08-17 23035, 2024
beanbrain has quit
2024-08-17 23046, 2024
Sciencentistguy joined the channel
2024-08-17 23047, 2024
SigHunter_ joined the channel
2024-08-17 23026, 2024
SigHunter has quit
2024-08-17 23022, 2024
sentriz has quit
2024-08-17 23024, 2024
sentriz joined the channel
2024-08-17 23040, 2024
leftmostcatUTC-7 has quit
2024-08-17 23036, 2024
sentriz has quit
2024-08-17 23047, 2024
sentriz joined the channel
2024-08-17 23040, 2024
discordbrainz
<12Aerozol> Clone MB, rename all the pages and relationships to game stuff 🤔 (joking... kinda??)
<04anomalockaris> This is really dumb, probably not what this servers for, but I want to listen to ever artist ever. Anyone have suggestions for what the easiest way to do that would be? I'm trying to find at the very least a easily accessible list of every artist or maybe release
2024-08-17 23055, 2024
everypizzasheher joined the channel
2024-08-17 23055, 2024
everypizzasheher
i don't think there's enough time to listen to even one song from every artist ever
2024-08-17 23056, 2024
discordbrainz
<08afrocat_> i don't think that's a realistic goal to be honest
2024-08-17 23018, 2024
discordbrainz
<04anomalockaris> not every song, just a song from every artist, or at least every english artist
2024-08-17 23045, 2024
discordbrainz
<04anomalockaris> I'd also be skipping through most of it, and just listening to what i find interesting
2024-08-17 23057, 2024
discordbrainz
Command sent from Discord by afrocat_:
2024-08-17 23057, 2024
discordbrainz
...musicbrainz alone has over 2 million artist pages
<04anomalockaris> if i get through 1000 artists a day, again skipping most of them, it would only take me 5 and a half years, and even if I'm not that efficient 10 or 15 years is a perfectly reasonable amount of time for this I think
2024-08-17 23013, 2024
discordbrainz
<08afrocat_> you still have to like, eat and sleep too
