Databases and integration

While planning for the basic characteristics of the game, I mostly put emphasis on the ship creation, how combat and ship actions worked and trading. However one thing that completely went over my head are the planets themselves. I plan to make 3 different solar systems with many planets and moons, so you can imagine the amount of work needed to make each planet.

That last paragraph did not come into my mind until after I started writing down each planet and moon and how they looked and the civilization types in those planets.

Another thing that came to mind while creating the tables and DB schema is how this could be used to facilitate modding for my game, users could add new items, planets and solar systems into it while the software itself interprets the data and includes the processed data into the game

After this post, i'll fill out the rest of the Items table and get to work on the Planet Interpreter, it will just read the contents of the Planets table and procedurally create the moons and planets based on their color, distance from the sun and texture index stored in that table.