steve-ng
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Assume the table is called order on Athena */ | |
| SELECT | |
| "item category", | |
| reduce(kv1['Asia Pacific'], 0.0, (s, x) -> s + x, s-> s) AS "Asia Pacific", | |
| reduce(kv1['North America'], 0.0, (s, x) -> s + x, s-> s) AS "North America" | |
| FROM ( | |
| SELECT | |
| "item category", | |
| multimap_agg("region", amount) kv1 |
steve-ng
/ result.csv
Last active
January 26, 2020 08:36
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Lambda Memory | Timeout (secs) | Routed within VPC | Routed to Internet | |
|---|---|---|---|---|
| 256MB | 30 | 8 | 6 | |
| 256MB | 60 | 17 | 14 | |
| 512MB | 30 | 11 | 10 | |
| 512MB | 60 | 25 | 21 |
steve-ng
/ testsetup.csv
Created
January 26, 2020 05:44
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| test | 1 | |
|---|---|---|
| 2 | 3 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| server { | |
| listen 443 ssl; | |
| server_name xxx.xx.io | |
| ssl on; | |
| ssl_certificate /etc/asterisk/certs/xxx.io.pem; | |
| ssl_certificate_key /etc/asterisk/certs/xxx.io.key; | |
| ssl_session_timeout 5m; |
steve-ng
/ Asterisk v12.3 setup
Last active
June 18, 2020 10:37
Environment Ubuntu 64bit. This setup will allow SIPML5 to connect to your Asterisk server. Refer to the comment in gist for the location of the configuration files
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Asterisk set up step by step guide | |
| 1) sudo apt-get update && sudo apt-get upgrade && sudo reboot | |
| 2) sudo apt-get install ntp | |
| 3) sudo apt-get install build-essential subversion libncurses5-dev libssl-dev libxml2-dev libsqlite3-dev uuid-dev vim-nox | |
| 4) Install uuid sudo apt-get install uuid uuid-dev uuid-runtime libuuid1 libjansson-dev | |
| Install srtp | |
| 1) mkdir ~/src | |
| 2) wget http://srtp.sourceforge.net/srtp-1.4.2.tgz |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| * Chrome 35 forced dtls fix | |
| */ | |
| var tmedia_session_jsep01$prev = tmedia_session_jsep01; | |
| tmedia_session_jsep01 = function tmedia_session_jsep01(o_mgr) { | |
| tmedia_session_jsep.call(this, o_mgr); | |
| this.o_media_constraints = | |
| { 'mandatory': | |
| { | |
| 'OfferToReceiveAudio': !!(this.e_type.i_id & tmedia_type_e.AUDIO.i_id), |