shipped_at TIMESTAMP in a migration and the column that ends up in the database are not the same column. MySQL applies two implicit rules to the first TIMESTAMP…
A daily report scanning 1.2 million rows to return two hundred. Why neither obvious index helped, what the composite one costs, and the two answers I turned down.
CodeIgniter 2’s Active Record escapes values for you, which is why it gets recommended as the safe alternative to writing SQL by hand. It escapes the arguments it…