How to use CASE statement in sql select statement to deal with if-then-else logic.

How to insert a new object into mongodb using pymongo with reference to other objects using DBRef.

How to quickly print out or remove duplicated items from given list in python.

Quick fix to an ssl error was encountered with python requests on ubuntu 14.04.

Github pages currently does not support https for blogs that use custom domain name, and here is what CloudFlare comes to a rescue.

How to redirect http traffic to https in nginx configuration.

Let’s Encrypt is a free, automated, and open CA (Certificate Authority) and let's make use of it to enable ssl access to web application serviced by nginx.

A compiler error was observed during installing lxml on ubuntu the error looks something like: error: command 'x86_64-linux-gnu-gcc' failed with exit status 4, and it's most likely caused by low memory.

With python2 builtin SimpleHTTPServer (or http.server in python3), you can start an http service to easily and quickly share a directory with files, which is especially useful and convenient in LAN environments.

How to use nginx to proxy http request to default port (e.g. 80) to other processes running on different ports on the same server.