peeringdb-simplesync - Minimalistic PeeringDB synchronization tool ================================================================== A simple tool for keeping a local PostgreSQL database up-to-date with PeeringDB. Requirements ------------ * PostgreSQL 9.5+ * Python 3.6+ * psycopg2 2.7+ * python-requests 2+ Installation ----- ```sh sudo apt install git python3 python3-requests python3-psycopg2 git clone https://git.2e8.dk/peeringdb-simplesync cd peeringdb-simplesync cp config.py.sample config.py editor config.py # change credentials createdb pdbtest psql pdbtest < schema.sql ``` Usage ----- ```sh ./sync.py # initial sync takes about 10 minutes ``` Then try the following query with `psql pdbtest`: ```sql SELECT asn, data->>'irr_as_set', (data->>'info_prefixes4')::int pfx4, (data->>'info_prefixes6')::int pfx6 FROM peeringdb.net WHERE deleted IS NULL ORDER BY asn; ``` Note: if you add an `info_prefixes4` column to the schema, then it will automatically be used, just like the `asn` column. Disclaimer ---------- This tool is not affiliated with PeeringDB.