.

I recommend SQLiteSpy to do this. Small, fast and portable. I keep a copy inside my Civ6 folder, another in my Civ5 folder and another one for general use.

I haven't found any other database in the user folder or the game folder. There are sql files with instructions to build a localization database but i don't know where it is kept, nor even if it si stored anywhere when the game is not running (might be stored in memory only)
 
Makes me wonder if we could edit the text using SQL request in game...
 
You mean dynamically alter the text while the game is running? Is it even possible to use SQL requests after initialization? Also the actual database would probably be read-only once a game is running.
 
The debug databases are copy, you can modify them from Lua using SQL request (you could in civ5 at least), but as they were just copy for debugging purpose, the DB in memory used by the game was not modified.

You could update text in game with civ5 by modifying the text database first then call the UI event to change the langage... yes, hacky, and it wasn't working on every context IIRC.
 
Does anyone know how we can read content from the database using a Lua script within the game?
 
Last edited:
I know this is an old topic, but the debug sql database is not getting written to the usual Documents/My Games/Sid Meier's Civilization VI/Cache folder (this is a new computer, I had it working on my old one). Anyone has the same problem?
 
I know this is an old topic, but the debug sql database is not getting written to the usual Documents/My Games/Sid Meier's Civilization VI/Cache folder (this is a new computer, I had it working on my old one). Anyone has the same problem?
Several files have been moved to the AppData directory beginning with the Great Builders update back in March.

 
Back
Top Bottom