My Cheat sheets

sqljoins



vim_cheat_sheet_for_programmers_screen

OpenStreetMap – Wikipedia for maps

OpenStreetMap is a website for collaborative mapping. I just signed up and spent about an hour editing the map nearby my apartment and workplaces. It was so much fun. Added a bunch of bus stops, library, grocery supermarkets and banks. Its good that we have an alternative to Google map and it belongs to no one and everyone.

http://www.openstreetmap.org

List of online courses sites

CanopyLAB is an interactive learning LAB for youth from across the world
CourseBuffet: http://www.coursebuffet.com
Data Camp datacamp.com
http://www.mooc-list.com/
CourseSites MOOC Catalog
Curcle http://curcle.co
Mytestbuddy: http://mytestbuddy.com
Berkeley Webcasts: http://webcast.berkeley.edu/
Carnegie Mellon: http://oli.cmu.edu/
[Read more…]

Google play store update not receiving for alpha or beta tester

If your testers are not receiving the update option for alpha or beta testing, try the following
  • Make sure you followed Google’s instruction correctly. That is, a) Create google group b) Add the tester to the group c) Make sure tester accepts to be a tester
  • If your tester has several Google accounts in his/her phone, then either add all these accounts as testers or remove non tester accounts from the phone. ‘Application already exists’ notification error shows up if you have any non testing Google account in the device. It is just┬ábest┬áto have only one Google account in the device which is the testing account.

Customizing linux terminal colors

Add the following to ~/.bashrc

alias ls='ls --color'
LS_COLORS='di=95;1:fi=0;1:ln=91;1:pi=5;1:so=5;1:bd=5;1:cd=5;1:or=31;1:mi=0;1:ex=96;1:*.rpm=33;1:*.deb=33;1'
export LS_COLORS

Then execute .bashrc to apply the changes.

source ~/.bashrc
0   = default colour
1   = bold
4   = underlined
5   = flashing text
7   = reverse field
31  = red
32  = green
33  = orange
34  = blue
35  = purple
36  = cyan
37  = grey
40  = black background
41  = red background
42  = green background
43  = orange background
44  = blue background
45  = purple background
46  = cyan background
47  = grey background
90  = dark grey
91  = light red
92  = light green
93  = yellow
94  = light blue
95  = light purple
96  = turquoise
100 = dark grey background
101 = light red background
102 = light green background
103 = yellow background
104 = light blue background
105 = light purple background
106 = turquoise background

For more details

http://linux-sxs.org/housekeeping/lscolors.html

Capital City to Country Android Quiz App

Download “Capital City to Country Quiz”
Get it on Google Play Get it on Amazon App Store Get it on Samsung App Store

Just about a couple of weeks ago, I released a free android app called ‘Capital City to Country Quiz’. There are a bunch similar apps in the Google Play Store. The main difference at the time of this writing about my quiz app is that the quiz is set opposite. Most of the capital cities app shows country name to player and the player has to guess the capital city. In the app I created, it shows the capital name and the player has to guess the country. There are few reasons why this is more fun compare to the former.

[Read more…]

How to get the real time bus location for sf muni:)

Download the ‘MUNI Live’ android app

Get it on Google Play

https://play.google.com/store/apps/details?id=com.hellothupten.sf_muni

[Read more…]

If statement is not always followed by a condition in java

This code will compile and run. Notice the assignment operator(=) in the condition.

boolean a;
boolean b = true;
if(a=b){
   //do anything;
   //this compiles
}

But this won’t compile

int a;
int b = 5;
if(a=b){   
   //notice its still = not ==
   //do anything;
   //this does not compile
}

The reason is because the previous code’s a is of

boolean
type and the latter’s is of
int
type.

if
statement is not necessarily followed by a condition.
a=b
is not a condition. Its an assignment. But it works if the left variable (i.e. a) is of a boolean type.

So its better if we think

if(boolean)
instead of
if(condition)
. Anyway, a condition like a==b or a>b etc will result a boolean result.

Toronto 2013 Blackout shelter places on Google map

About 200,000 or more Torontonians are suffering blackout right now.(December 23, 2013). I am writing this in candle light with a little bit of battery left on my phone and laptop by using tethering the internet of my phone to the laptop.

If you are on the road in this freezing weather and need to find a closest shelter, check this map I created on google map. The list is as per emailed to me by the toronto city’s newsletter. I may not be able to update when the list changes in future, so please after finding the location on the map. Call them to verify.

[Read more…]

Splitify – chrome extension to split a webpage for wide screen

I created this chrome extension that splits the webpage that uses the wide screen more effectively. Extract the zip file and install the extension. [Read more…]