RetroCollect Video Game Database Preview: Introduction

VideoGameDatabasePreviewIntroduction

As you probably have heard by now, we have been working on a completely revised RetroCollect video game database for quite a while. In this series of preview posts we want to show you what to expect from the update and highlight some exciting new features.

Before we delve into more specific features of the new database though, a few introductory words are in order. This post serves just as that introduction. You should definitely read it if you want to follow the upcoming previews, otherwise some things might be hard to understand.

First of all, the good news and the bad news. The good news is, every feature described in this preview series is being worked on and is fully supported by our new database design (more on that at a later date). The bad news, not all of it will be available immediately. We would rather be able to offer some of these features earlier than having to wait for all them until they are all done. We are confident you feel the same way! Unfortunately, we also can not promise a launch date for our new database yet. Rest assured though that we want this to happen as soon as possible.

So, what exactly do we mean when we say "new database"? Of course we're not starting from scratch. All the data currently on the site will still be there. What's changing though is the entire way in which this data is stored. In more technical terms: We are switching to a new data model, rewritten from scratch and featuring roughly 500 database tables. Using the experience of running RetroCollect for over five years, we have designed this new model with the intention of solving the problems plaguing all game databases out there and addressing their and our shortcomings. You don't have to take our word for it though, we'll be highlighting some of these problems in these preview articles. If you're interested in the technical details, please let us know so we can incorporate such information into this series.

With all that out of the way, lets quickly list some of the topics we will be covering in the upcoming posts: vastly improved collection tracking, a public contribution system, new platforms including computer systems, database statistics, data accuracy tracking, a proper company database, tagging mechanisms, a redesigned core data model, tracking of preservation efforts, lots of additional hardware information, a revamped genre taxonomy and various other game classification attributes, a public API, user top lists, custom/local platform names and a glossary of our database terms. Of course, presented as a list all of this probably doesn't mean much to you, does it? We'll make sure to fully explain all of it in this series. If you have specific requests or questions, please let us know.

That's it for today's introduction, let us know which details you'd like to hear more about first in the comments!


Last Updated ( 21 May 2016 )  

Comments 

(Link to this comment) gunstarhero 2016-05-21 20:57
good stuff
(Link to this comment) Schlibbylibby 2016-05-21 21:03
Look forwards to it
(Link to this comment) The Saint 2016-05-21 23:16
It all sounds great. Looking forward to more preview articles! Just one question, what's an API? I'm guessing an interface of sorts?

Kudos to all the team and your good self Hydrox for making this happen.
(Link to this comment) hydr0x 2016-05-22 07:11
To put it simply, an API is a way to access our game data from within other (web) applications. This allows the creation of mashup services, smartphone apps etc. which use our data (to a certain extent).
(Link to this comment) The Saint 2016-05-24 15:55
Thanks for explaining Hydr0x!
(Link to this comment) DerMicha75 2016-05-22 19:11
I like to hear the API feature... I can think of some things to do then (fleemarket app for missing titles, ebay searcher, ...) Also I would interested in database design. Esecially the company database is difficult I think (renaming comanies, bying each other, ...). So please feel free to show your ideas here :-)
(Link to this comment) hydr0x 2016-05-22 22:06
Yeah, the company section of the db is complex. We support name changes, changing addresses, buy-outs, mergers etc., different publishing labels within companies, development departments within companies and more ;) I probably can't make the exact table structure public, but I'll keep your request in mind when it comes to that part of the preview.
(Link to this comment) DerMicha75 2016-05-24 18:02
Quoting hydr0x:
Yeah, the company section of the db is complex. We support name changes, changing addresses, buy-outs, mergers etc., different publishing labels within companies, development departments within companies and more ;) I probably can't make the exact table structure public, but I'll keep your request in mind when it comes to that part of the preview.


Thank you! The todays article about core data model gives a good feeling...
(Link to this comment) Craig20789 2016-05-23 16:01
android accessible database phone app would be awesome
(Link to this comment) Sharpless512 2016-05-30 10:21
If you are interested in an all around video game database, maybe igdb.com is good?
You can even use the api for free aswell
Banner
Banner

Retro Game Database Search

Retro Gaming Podcast

Join the RetroCollect Squad as they discuss our gaming past in the all new RetroCollect FM - Retro Gaming Podcast.


Retro Games on eBay now



About RetroCollect

RetroCollect is your one stop for everything retro games and retro gaming. Featuring the latest classic gaming news around, informative reviews and an ever active forum, you'll feel right at home with other retro gamers.

RetroCollect FM - Retro Gaming Podcast

Join the RetroCollect Squad as they talk their way through the wonderful world of retro gaming.

Listen to RetroCollect FM - Retro Gaming Podcast

Join RetroCollect on the web