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#).
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 visualiser 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 solution/tool 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.
Is there anything out there that does this? I realise some compromises will have to be made for both areas but has anyone had experience with this?