This is an example of how to read a csv file retrieved from an AWS S3 bucket as a data source for a D3 javascript visualization. The D3 visualization would be an HTML document hosted on a web server. You will use the AWS SDK to get the csv file … Continue Reading →
AWS RDS Postgres database external secure connection
Requiring an SSL Connection to a PostgreSQL DB Instance http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.SSL Not great examples on that but take a look at this other documentation for secure connection to Redshift database which has working examples http://docs.aws.amazon.com/redshift/latest/mgmt/connecting-from-psql.html Go to EC2 Security Groups, and modify the Inbound PostgreSQL rule from the VPS server eg … Continue Reading →
Twitter Followers and List Membership Tracking
I have created my own historical reporting of my Twitter account followers and list memberships. I have hosted the reporting on this open webpage. Most people know what followers are but the list memberships aren’t as well known so here are definitions of them. Twitter Followers – Twitter followers are … Continue Reading →