Database editing with DataGrip

[pygmalyon]

Hi everyone!

I'm writing to you to show a method that could help enrich custom content of the game. Like we all know with every major update previous database becomes useless.

However DataGrip programme solves this issue as well as it makes the process more productive. It enables conversion of the database in order for it to work with different versions of the game. Without further ado here is instruction:

USING DATAGRIP - INSTRUCTION
(to understand it better I recommend installing the programme and loading the database; there is free 30-day trial period)

"..." → is about the TABLES that you can find in DataGrip [Database>main>tables]

'...' → is about the COLUMNS inside a table that you can find in DataGrip [Database>main>tables>e.g. Award]

(1) when you want to add movie - add information on it in table "Source", roles in table "Role" and topics in table "TopicList" (column with 'id' or 'source id' have to be distinctive so you can just use Excel to give you whole column with mydatabase00001, mydatabase00002, mydatabase00003, ... and insert it there in 'id'/'source id')

(2) when you want to add actor, director, producer or showrunner - add information in "Person" (this 'id' is used to make relations in table "Relationships")

(3) when you want to add franchise - add information in table "Franchise"

(4) IN CASE OF AN MAJOR UPDATE if you want to make changes between different versions of the database compare them and insert columns that were added in a newer version OR just write to me and I will send you "updated" version of your database

MAKING 1.5.x DATABASE COMPATIBLE TO 1.6.x

(1) add columns in "Role" with name Popularity (INTEGER type) AND name Archetype (TEXT type)

(2) add row in "Genre" called Family and put there values that you think Family movies should have



I guarantee it is easier than it looks!

[bgoldey]

Good information & suggestions - Managed to merge 2 databases together to save having to re-enter each time a new update comes out.

However, how do I save the Database once completed so it can be used in game?

[pygmalyon]

Jul 26, 2022 11:28:13 GMT bgoldey said:

Good information & suggestions - Managed to merge 2 databases together to save having to re-enter each time a new update comes out.

However, how do I save the Database once completed so it can be used in game?

To save it you just have to click on Submit (the green arrow) or use Ctrl+Enter. By doing so you are updating the database

[Admin]

You guys can also use SQLite. It's what I use.

[bgoldey]

Both programs work well. I have found datagrip slightly easier to navigate when merging databases etc.

Thanks both

[mithrilpotion]

this is nice to know for the STARLIGHT Database if an update ever eventually comes.