Common Table Expressions in Postgres
PostgresSQL WITH Queries, also known as Common Table Expressions (CTEs), allows us to write complex queries by defining temporary tables for use in a larger query. In other words, we can create in-memory temporary tables and query against them. Here is an (trivial) example where we want the email addresses of all the users who […]
Evernote to Blog Post
Today I learned how to publish our TIL posts directly to our blog, straight from my favorite text tool, Evernote . We are simply making the connection with one of our go-to’s, Zapier . The concern with this integration is that our zap is searching for new notes every 15 minutes, so you would need […]
Recursion in Elixir
Coming from an object oriented language with data mutability, learning looping in Elixir required that I let go of my current understanding about iterating over a collection. In fact, just forget looping and think recursion. So, what’s recursion? Recursion is solving a problem whereby one applies the same solution to smaller instances of that problem. […]
Angular 1.x Dropdown Menus
(Removing The Blank Option)
Over the past week I kept running into the issue of iterating over an array or an object in a <select> field with ng-repeat, only to find that I had a blank option as the first item in the dropdown. After trying several strategies, I finally found one that worked. Let’s say you want to […]
Animating height with only CSS
CSS transitions allows smooth animation of containers using max-height. Using height will not work.
Example: