Step-by-step guide to setting up Ruby 2.1 + Rails 4 + Nginx + Phusion Passenger + MySQL on Ubuntu 14.04 using rbenv for a production environment.
Rails 4 作為 API 使用時出現 InvalidAuthenticityToken 的解法：在 ApplicationController 中將 protect_from_forgery 改為 with: :null_session。
Complete guide to configuring SSL on Apache: self-signed certificates (generating key, CSR, CRT, and VirtualHost setup) and purchasing commercial certificates from Symantec.
How to update OpenSSL on Mac using Homebrew. If the version still shows the old one, manually remove /usr/bin/openssl and create a symlink to the new version.
MySQL 對兩個欄位組合建立複合唯一索引的 ALTER TABLE 語法，防止相同欄位值組合的重複資料寫入。
Ubuntu 使用 update-rc.d 指令設定服務開機自動啟動或停用，以 apache2 為例示範 enable/disable 的用法。
Tips for deploying CodeIgniter to AWS: disable pconnect when using RDS to avoid exceeding connection limits, note that RDS timezone defaults to UTC, and considerations when using a Load Balancer.
MySQL 三個實用語句：GROUP_CONCAT 將多行結果合併成一個欄位、DATE_FORMAT 格式化日期顯示，以及 IFNULL 為空值欄位設定預設值。
Two ways to manually update OpenSSL on Ubuntu: a quick one-liner with curl and make, or a full bash script with GPG signature verification. Useful for patching vulnerabilities like Heartbleed.
PHP json_decode fails when the JSON string from $_POST has added backslashes. The root cause is the magic_quotes setting in php.ini — disable it to fix the issue.