Alpha. More alpha than a full fleet of Catalysts, in fact.
This software requires:
- Node.js v0.12
- PostgreSQL v9.3 or higher
- Redis (developed using v3.0)
- A CREST API key.
It is tested on Linux, FreeBSD, and OS X. Windows is untested but should work.
eveindy currently requires two PostgreSQL databases:
- one containing the SDE dump as provided by Steve Ronuken
(by default,
evetool
), and - one for user data (
eveindy
).
I'll probably end up using two schemas in one database, but that hasn't happened yet.
This application will require a user to connect to the database.
CREATE ROLE eveindy WITH
LOGIN
PASSWORD 'correct horse battery staple';
-- or a different authentication method.
Create a new database for the SDE dump using the instructions provided in evego. Grant the database user to be used by eveindy read permission on everything in this database. (Yes, I know this part is all public data.)
BEGIN;
REVOKE ALL PRIVILEGES ON DATABASE evetool FROM public;
REVOKE ALL PRIVILEGES ON SCHEMA public FROM public;
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM public;
GRANT CONNECT ON DATABASE evetool TO eveindy;
GRANT USAGE ON SCHEMA public TO eveindy;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO eveindy;
COMMIT;
Create a new database (we use eveindy
) and run the provided SQL (in the sql
directory) to set it all up.
(echo "SET search_path TO eveindy,sde,public;" && cat *.sql) | psql -1 eveindy
You'll then need to configure this database's security using something like the following:
BEGIN;
REVOKE ALL PRIVILEGES ON DATABASE eveindy FROM public;
REVOKE ALL PRIVILEGES ON SCHEMA public FROM public;
REVOKE ALL PRIVILEGES ON SCHEMA eveindy FROM public;
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA public FROM public;
REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA eveindy FROM public;
GRANT CONNECT ON DATABASE eveindy TO eveindy;
GRANT USAGE ON SCHEMA eveindy TO eveindy;
GRANT SELECT ON ALL TABLES IN SCHEMA eveindy TO eveindy;
COMMIT;
To update the local SDE copy, use the update_sde.py
script in evego
following the instructions in that project's README file.
The contents of this repository are © 2014–6 Brad Ackerman and licensed under the Apache License 2.0, the full text of which is in the LICENSE file.