TIL how to improve the build time on my Jekyll site. Here is what I did to cut my build time in half.
Category Archives: TIL
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
Using d3.nest to transform stacked data.
Switching IDEs after 10 years.
Gulp and Sketch first use notes
Here is how to get rid of a pesky Jekyll undefined method downcase error.
How to compare data columns of data from different sheets in Excel.
This tutorial shows how to make smooth transitions in a pie chart using d3.interpolate.
This tutorial builds on previous work and updates a pie chart in realtime.
Here I learn the basics of making a pie chart with D3.js
This tutorial is a way to apply what I learned about data joins, click events, and selections in D3.js. Along the way I learned about building arrays.
Learning D3 by playing with circles
Notes from the D3js.org Introduction and Thinking With Joins
Emmet is a tool that expands your HTML and CSS workflow.
How I'm relearning D3.js.
TIL how to forward error pages to real pages with .htaccess.
Here is how to load scripts on specific pages in Wordpress with wp_enqueue_scripts
TIL how to quickly replace elements with jQuery
TIL how to implement search on a Jekyll site.
TIL how to copy files from a Microsoft Remote Desktop connection to my local machine.
It is super easy to power your blog with a custom domain through Medium. Here is what you need to do.
Did you know that you can pre-fill Google Forms based on a URL? Did you also know that automate it with a database and send personalized forms via services like Mailchimp?
TIL that the best time to learn how to handle crises is right after you just had one.
TIL about jQuery's greater and less than selectors
TIL how to schedule tasks with Cron.
Today I took another stab at automating my blog posts.
Today I learned about Many-to-Many relationships in relational data models
TIL how awesome Trifacta Wrangler is for transforming and digging through data.
TIL where to find certain things on Linux servers
Today I learned how to clean up my Mac with Hazel
You can use word count charts to complement word clouds for better understanding.
TIL the basics of Ember.js.
TIL how to make link posts a la Daring Fireball and Marco.org with Jekyll.
TIL how to count and make JSON output in Jekyll
TIL how to kill rogue background Python processes
TIL how to make a simple HTTP server with Python
TIL how to do lookarounds in Regex
TIL how to make
Safari on iOS and Safari on Mac OS X are not created equal.
Having trouble accessing your website from Google's public DNS? Check your DNSSEC.
TIL about some resources for making web work easier.
I used ProgressBar.js to build a date counter that counts up from a particular point in time visually.
Converting Aperture photo libraries to Lightroom
Today I collected the things I learned in the past week.
Today I reminded myself how to toggle divs with buttons.
TIL how to run other scripts with AppleScript
TIL how to read CSVs, count, order via lambda expressions, and plot with Python.
TIL how to deal with files in AppleScript and how to do conditional counts in Excel.
TIL how to concatenate columns and convert time in Excel and some more SQL functions.
TIL how to make aliases for tables in SQL and how to sort tables with jQuery
TIL there are multiple paths to every end goal and sometimes you need to try another one instead of spinning your wheels.
TIL how to sum in Excel with filters and a trick for bringing myself back in perspective.
TIL how to hide my TIL posts from the front page of my site, the Unless tag, and inserting mysql with PHP.
TIL the basics of connecting to a MySQL database and creating tables in PHP.
TIL a new-to-me development philosophy and the basic parts of creating a Wordpress plugin.
TIL about easier syntax highlighting and how to download Wordpress.com email subscribers in a CSV.
Today I learned about best practices in development infrastructure and git.
TIL how to check for keys and look up values in arrays, as well as how to restrict files via .htaccess.
TIL how to do basic logging to CSV in PHP and how to highlight syntax in Jekyll.
I didn’t do much technical work today besides some front-end debugging. Instead I did a lot of administrative and project management work and ended up thinking a lot about how I work.
TIL how to convert unicode characters in PHP and I released my first personal project on Github.
TIL about date/time conversions in PHP and a lesson about automatic inheritance in CSS.
TIL how to sort tags alphabetically in Liquid and I did some reflection on work and the status quo.
TIL how to keep track of files and requests in Slack.
Today I learned how to tackle my RSI issues and I thought about useful analytics and product scalability.
TIL the basics of Meteor, how to tell Apache where to find your 404 page, and all about secure hash algorithms.
TIL how to make code snippets pretty, which VPN client to use, and common misconceptions about privacy.
TIL two ways to tile patterns in Photoshop. One is manual and time consuming, the other is fast, easy, and less prone to error. I also re-learned some stuff about Homestead and Composer.
TIL about what to consider when architecting and planning out a software development project, how to automate the tedious parts of my TIL posts, how to tackle the lack of parent selectors in CSS, and project-wide find and replace in Coda.
TIL about upgrading Jekyll from 2 to 3 and how to make a TIL index template in Liquid.
TIL about creating pull requests on Github, accessing Reddit's APIs with Python and storing that data in MySQL, and quirks with CSS's flexbox module