Skip to content
This repository has been archived by the owner on Jul 29, 2020. It is now read-only.

thepatrick/rtcstats-server

 
 

Repository files navigation

rtcstats-server

server for https://github.com/opentok/rtcstats

Load errors

select starttime, colname, col_length, type, err_reason
    from stl_load_errors
    order by starttime desc;

views on recent data

create or replace view recent as select * from features_new order by date desc limit 100000;

Sample queries

The queries directory contains nodejs script that will connect to redshift, run a large number of queries and output a HTML file to stdout.

Extracting features from a local dump file

  1. Move the dump file to the temp folder
  2. Run node extract name-of-the-file

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 88.3%
  • PLpgSQL 9.6%
  • HTML 2.1%