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
784 posts since June 22, 2008.
- Listening notes
- Primal Challenge
- Reading notes
- June 2019
- March 2019
- February 2019
- December 2018
- October 2018
- September 2018
- August 2018
- July 2018
- June 2018
- May 2018
- April 2018
- March 2018
- February 2018
- January 2018
- December 2017
- November 2017
- October 2017
- September 2017
- August 2017
- July 2017
- June 2017
- May 2017
- April 2017
- February 2017
- December 2016
- November 2016
- October 2016
- September 2016
- August 2016
- July 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- December 2015
- September 2015
- June 2015
- January 2015
- November 2014
- August 2013
- August 2012
- July 2012
- June 2012
- January 2012
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- February 2011
- January 2011
- December 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- September 2008
- August 2008
- July 2008
- June 2008