Move data to a database

Manitary / SobbleDex

Discord bot providing information about the game Pokemon Shuffle

0 stars 0 forks source link

Move data to a database #2

Open Manitary opened 1 year ago

Manitary commented 1 year ago

TSV files are cumbersome to use especially for read/write operations on a live service. Seems better to have a local database: faster speed, more safety with transactions, ...

[x] move data from tsv to a sqlite database
[x] remove all yadon dependencies
[x] add scripts to perform all such imports automatically (careful with encoding)
[x] update how each table data is accessed and modified

Manitary commented 1 year ago

Should be resolved in this branch. Waiting to close until appropriately tested and/or confirmation by the original owner.