EHM The Blue Line

So Ive started work on the game again. Im graduated now so everything should be okay, I have my passion back

Ive been playing around with Editors, because of course I have, and ive noticed weaknesses in database designs. Basically what I want to do is build databased out of constituent parts. IE if you create the British Columbia Professional Hockey league you create the 15 teams, and give those teams their 25 players. You usually would need to re-create those teams in every database you would want to use them in order to make sure they're compatible or else worry about version control and stuff like that. But in this design if you make a change to a team like Langley and make their jerseys Yellow instead of Black then that change would carry over to every database that uses that Langley team. So if you had this one league of teams in BC and you also had say a Database that separated Cascadia, Quebec, Ontario, the Maritimes, Texas, etc into their own countries you could plop them into that database and if you had a database where the US Anexes Canada you could plop them into that database, and if you wanted to use it in the default database you could plop it into that as well, so that when you make a change to the Langley team it makes the change to all 3 databases automatically so you don't have to worry about duplicating work (Which is a big problem in stuff like this)

That sounds much like in Football Manager.

Its definitely an inspiration, but FM uses database changes in its editor as opposed to the actual database so that creates a few problems, one of which is editing multiple countries and how it handles the importing of multiple files and It can get really messy

Its obviously a great editor, and its expansive as balls, I would just prefer to use a different system; One I think would be more beneficial to both user and database creator

Its a little crude, but it gets enough of it across I think. The squares are the source files, which can be edited outright. The Lines are a reference, meaning the source needs information from another source file. The Red Circle is an edit. An edit takes a source file and modifies some of it, but it wont change the original source file if something else uses it. The big circle is the Database itself, what the player loads up

This will let database creators modify a single file to change many databases. For example, if a new city in BC pops up called Surbottsley or whatever, only the cities file need to be edited. Then you can put ateam there called the Cardinals by editing the BC teams file. This will propgate changes to the BC League, the Cascadia League, and the North West League.

3 databases get 2 changes all at once. To do this otherwise would need 6. this will save a lot of time and encourage fans to work together. If one database uses another databases files, and one database comes out with a massive update, anyone using that database will get the updates aswell.