bbalaran/database repository overview

\d+ halcyon

select * from halcyon."Test_Hourly_Watches" limit 5

select * from halcyon."Test_Repos" limit 5

select repo_id, repo_name, language, num_stars, count(*) AS stars from halcyon."Test_Hourly_Watches" 
Inner Join halcyon."Test_Repos" On repo_id = id
where num_stars > 0 
  AND date >= current_date - 47
  AND date <=  current_date - 40
group by repo_id, repo_name, language, num_stars order by num_stars desc

docker build -t custom_psql .

docker run -d --name custom_psql_running -p 5432:5432 custom_psql

exec -it custom_psql_running psql -U postgres

docker run -it --link custom_psql:postgres --rm postgres sh -c 'exec psql -h "$POSTGRES_PORT_5432_TCP_ADDR" -p "$POSTGRES_PORT_5432_TCP_PORT" -U postgres'