By Keith Yap

Things I've Learnt

Category

Uncategorized

Remote connection to Raspberry Pi

Easy SSH when your computer and your PI are on the same network (wifi) Mac/Linux: Open the terminal Windows: Install Putty Ensure the pi is turned on and connected to network Find the ip address of the pi SSH into… Continue Reading →

PostgreSQL Beginner’s Cheat Sheet

Terminal commands: Launch PostgreSQL terminal – psql Copy table from one db to another – pg_dump -t table_name copyfrom_db_name | psql copyto_db_name   PSQL commands: List databases – \d List tables in current database – \dt List table structure – \d table_name List… Continue Reading →

Web Apps

Twitter sentiments – Looks up the 50 most recent tweets from any twitter user, classifies the sentiment of those tweets and outputs the result as a pie chart KS50 Finance – A simulated stock market portfolio tool, useful for learning the… Continue Reading →

© 2017 By Keith Yap — Powered by WordPress

Theme by Anders NorenUp ↑