TIL how to improve the build time on my Jekyll site. Here is what I did to cut my build time in half.
TIL that PHP 7.2 doesn’t support mcrypt and MySQL 5.7.5+ changed GROUP BY behavior. Both break Craft CMS. Here is how to solve those issues.
TIL that you can’t change the CSV delimiter or enclosure characters on Excel for Mac or Apple Numbers. You have to use Open Office.
TIL how to build JSON strings in Excel with concatenate.
I never remember the keyboard shortcut for Fill Down in Excel on macOS, so I’m posting it here where I’ll have it. Control + D.
Today I upgraded from Homestead 4.0.0 to 5.0.1 so I could test my sites in PHP 7. That was a major upgrade and a number of things changed, so I decided that I needed to back up my databases before I did the upgrade. I’d only ever dumped specific databases before, but TIL how to dump them all at once. Here is how to do that in Laravel Homestead.
TIL how to use the viewbox attribute on an SVG to make it responsive and preserve the aspect ratio.
TIL that you can save changes you make with Chrome Dev Tools directly to your disk.
TIL a ton about the WordPress template hierarchy and the conditionals that select them.
TIL about Genesis hooks and filters.
TIL about CSS Grid
TIL that all forms of communication can be described by the same process, no matter the sender, receiver, or medium.
I don’t know all the answers, even if I think I do. Sometimes I need to ask for help.
How to structure responsive breakpoints in Sass, with examples.
At Praxis we use Restrict Content Pro as the membership system for our curriculum portal. We decided that all grads get access for life, not just during the program. So, I needed a way to clear over 200 member expiration dates. Here is how I accomplished that task with SQL.
Adding dates is tricky. Months have different numbers of days, so you can’t rely on just adding 30 days to get an extra month. You also can’t just add a certain number of months because formulas in Salesforce don’t auto increment the year. The solution is modular arithmetic and conditionals.
No more forgetting to export the database regularly.
s3_website doesn’t work with Java 9. Use jEnv to define an earlier version.
Line height doesn’t work on spans by default