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.