github-traffic-stats icon indicating copy to clipboard operation
github-traffic-stats copied to clipboard

enhancement: export to sql

Open thirschbuechler opened this issue 8 years ago • 4 comments

export to a database, e.g. sql would be awesome. someone has done something similar already, but in MS Visual Studio: https://github.com/Microsoft/GitHubTelemetryParsor

thirschbuechler avatar Feb 24 '17 16:02 thirschbuechler

@thirschbuechler and @nchah - In a new fork, I have updated the original main to connect to a PostgresSQL database, and send the results there. https://github.com/oshadmon/github-traffic-stats

PR: https://github.com/nchah/github-traffic-stats/pull/15

(If this works issue can be closed)

oshadmon avatar May 23 '18 21:05 oshadmon

@thirschbuechler - PR #15 is merged. Please let me know if that's good enough, or you want actual SQL file.

Just as FYI you can do pg_dump to send data in PSQL to SQL file.

oshadmon avatar Jun 03 '18 00:06 oshadmon

@oshadmon @nchah thanks, i'll give it a shot

thirschbuechler avatar Jun 07 '18 09:06 thirschbuechler

@thirschbuechler - If that doesn't work let me know, and I can enhance the code to do a write SQL to file as well.

oshadmon avatar Jun 11 '18 14:06 oshadmon