![]() Not going to say which word, just in case you didn't notice. Pay no attention to the terrible terrible spelling. Here are the queries we will be reviewing below. I'll try to cover it all later in this guide).įor text modding, we're going to start out just like we did in the Production section and add a new SQL file. The reason the Execute SQL tab is the best tab, despite not having a UI, is because the UI cannot do advanced queries that join results from multiple tables together, like below (there's a lot going on below so don't get intimidated.By pressing the blue play arrow or pressing F5 you can execute your statements (don't forget your semi-colons). ![]() Here you can execute SQL statements from really advanced to really simple. ![]() The 4th and last tab is the most useful tab, Execute SQL.It's irrelevant, unnecessary, and complex for Civilization VI modding. We're going to ignore/skip the 3rd tab (Edit Pragmas).Here you can select a table (in this case the first one, Adjacency_YieldChanges) and edit the data in the table with the UI on the right-side. The second tab across the top is the Browse Data tab.This shows you, among other things, all tables in the database (so in our case all gameplay tables) and if you click the arrow next to the table name you can view all of its columns (names and data types). The first of which is the Database Structure tab. sqlite database, you'll find a few tabs across the top. Once open, you'll need to open a database.Once complete, open Sqlite Browser by running "SQLiteDatabaseBrowserPortable.exe".You can move that folder anywhere you want after installation, even a flash-drive. Really all the portable version does is extracts the files to a folder despite them calling it an installer. After that, run the installer that you've downloaded.Download SQLite Browser (portable version recommended).Feel free to install another version, you should be able to still roughly follow along. The guide below shows you how to setup SQLite Browser (portable version). * - My statement about stability and performance is probably controversial to some, sorry. Commonly used by companies and corporations that can afford to pay licensing fees for the increased stability and performance*. SQL Server & T-SQL - This is Microsoft's take on SQL.The strength of MySQL is that it's open sourced and doesn't have those hefty licensing fees like Microsoft SQL Server. It is not used in Civilization VI modding, but most SQL is very similar so learning/knowing it doesn't hurt. MySQL - This is a commonly used version of SQL.It's core strength is that it doesn't rely on a server, but instead the existence of a file on the client (i.e. sqlite files and is usually smaller in nature. SQLite - This is what we're using when modding Civilization VI.SQL OverviewSQL (commonly pronounced sequel) is a language for retrieving data from a relational database.
0 Comments
Leave a Reply. |