For my own reference (and so whoever might find them useful). Sometimes just MySQL and sometimes in Laravel-esican. Nullable integer column: Order numerically, except with NULL last Source: http://stackoverflow.com/questions/2051602/mysql-orderby-a-number-nulls-last MySQL SELECT * FROM table ORDER BY ISNULL(field), field ASC; Laravel … Continued
In GMail Settings: Untick Labels->All Mail->”Show in IMAP”. That is all.
Quick one-liner to read in Redshift’s current transition period value and assign it to a variable. (Redshift adjusts the color temperature of your screen when it gets dark.) Or assign to a variable:
When working on a Laravel project, I needed a quick way to seed in some random (but still coherent) sentences. The ultimate for PHP/Laravel projects is fzaninotto’s Faker, which can generate everything, from addresses to credit cards. If you’re in … Continued
I’ve been looking for this one FOREVER. Love how easy it is to migrate home dirs and config files to a new Mint installation, but one of the things that I could never get right was moving the custom keyboard … Continued
Wanted to listen to past episodes of Laurie Brown’s CBC The Signal, but unfortunately they don’t have (many) past episodes available for download or stream. Here’s how I got around it.. September 2016 Update at bottom. Found a listing of … Continued
Here are some useful easystroke commands (especially for when the built-in ones don’t work). This is really for my own reference.
We were having a problem with web fonts (Google Web Font’s Open Sans and some icon fonts, specifically) not showing up when a page loads. They were only showing after hovering over an item or a resize — in other … Continued
Here’s a bit of code running on my Raspberry Pi that detects if the current Squeezelite player is playing or is paused. Replace 192.168.1.10:9000 with the IP address of the server and replace 62:74:01:10:10:40 with your player ID. Note, you … Continued
Centre window (with a bit of randomness, so it doesn’t perfectly overlap) centre-window.sh Two monitor setup. I have a laptop screen (1600×900) left of my main monitor (1920×1280). Change accordingly! move-to-left-monitor.sh move-to-right-monitor.sh