search

hasadna / open-bus

:bus: Analysing Israel's public transport data
93 stars 27 forks source link

re:dash access to our DB #15

Closed daphshez closed 8 years ago

daphshez commented 8 years ago

Re:dash is a really useful tool that allows people to run queries, share the queries and also do visualisations and dashboards. Various other Sadna projects are using it heavily as far as I understand.

Ideally this could be a way to look at all our data (gtfs, siri & bus2train).

What seems to be required:

  1. Creating a read-only user on our database. Something like:
create role UESRNAME with login password 'PASSWORD';
GRANT CONNECT ON DATABASE obus TO USERNAME;
GRANT USAGE ON SCHEMA public TO USERNAME;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO USERNAME;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO USERNAME;
  1. Opening the database for access from remote addresses. Preferably not from the entire world wide internet though. See for example here: http://www.thegeekstuff.com/2014/02/enable-remote-postgresql-connection/
  2. Sending the details to @akariv so he can set up re:dash for us.
daphshez commented 8 years ago

Our data is now available on re:dash!

See an example query here: http://data.obudget.org/queries/760

Login with your google account.

Thanks @akariv