EVE SDE Postgres updater
CLI utility for updating the EVE Online static data export postgres database.
This has been tested with the Fuzzwork postgres conversion but might work with other versions as well.
You should use a separate database for the sde and use for example postgres_fdw to use it with your main db.
Usage
Requirements
- Python 3
- pipenv
- docker-compose (if you want to use the included docker setup)
Environment setup
pipenv install
Easy setup
docker-compose up -d
./sde_updater.sh -e .env.local
Custom settings
⚠️ NOTE: the script clears the entire database when restoring from the dump.
⚠️ DO NOT USE THIS ON A DATABASE WHICH CONTENT YOU DO NOT WANT TO LOSE.
Make a copy of .env.template and save it as .env. Change settings as needed and run:
./sde_updater.sh
Scheduling
The script keeps track of update history in .update.log and checks the latest entry against the “last-modified” header
of the Fuzzwork dumps. The databse is only updated if the dump is newer than your local version.
You can use cron or other scheduling tools to prediodically run this script to keep your database up to date.
