I'm programming on a game that relies on a database for a lot of the creatures and items in the game (think Pokémon).
Currently, we have a Google Sheet that the designers are making. They will be using it to populate all of the items necessary for the game, so it acts as a 'source of truth'. However, to translate this into the database (SQLite) we'll need to write some code to pull the data, format it and put it into the database. The maintenance of this will also be pretty annoying, as we already need to maintain the database schema and the code representation (Unity C#). DB tables are can be static or dynamic, and the implementation on the Unity side for the DB is not an issue.
Before writing this code I'm exploring other options. I've looked into Microsoft Access (and similar programs) but they seem to be geared towards making applications now and don't have much in the way of SQLite integration. I'm leaning towards using a visualizer tool like DB Browser for SQLite or SQLiteStudio, but the lack of cloud syncing might mean a janky solution with Google Drive or AWS.
I'm looking for a workflow that:
- will be accessible for game designers (who have little to no SQL experience, but willing to learn)
- will keep changes between designers synced
- will be easy to manage and maintain for the codebase and SQLite database.
How can we solve this problem?