Once a design of a system meets all the business constraints necessary, my next priority is to make the system as simple as possible. By simple, I mean a system that is both easy to understand and easy to change. … Read the rest The post Simple Rules for Building Simple Systems appeared first on malisper.me.| malisper.me
Over the past few years, I’ve interviewed with a dozen or so companies and have completed ~50 or so individual algorithm problems. I’m frequently given feedback that I did a great job at the algorithms problem. In this post, I’m … Read the rest The post An Algorithm for Passing Programming Interviews appeared first on malisper.me.| malisper.me
One of the most important skills I believe programmers need is to understand when to use certain tools. My typical process for solving a problem is to go through each tool in my toolbox and see which one would solve … Read the rest The post Tools in My Toolbox appeared first on malisper.me.| malisper.me
Day 3’s problem was an interesting one. We are given two wires and have to find the point where the two wires intersect that’s closest to the origin. As usual, we’ll approach this problem in two steps. First we’ll parse … Read the rest The post Advent of Code: Day 3 appeared first on malisper.me.| malisper.me
Day 2 of the Advent of Code is a classic – implement a virtual machine for a simple assembly like. Eric Wastl, the creator of the AoC, has been writing challenges like this for years before the AoC even existed! … Read the rest The post Advent of Code: Day 2 appeared first on malisper.me.| malisper.me
The Advent of Code is back! In past iterations of the Advent of Code, a bunch of my friends and I would share all our solutions. This year, I thought why not go the extra step and publicly write up … Read the rest The post Advent of Code: Day 1 appeared first on malisper.me.| malisper.me
In my last post, I showed you how you could use a number of SQL tricks to generate a class of fractals known as the “escape-time fractals”. In this post I’ll show you how you can use the same … Read the rest The post Generating Fractals with Postgres: Self-Similar Fractals appeared first on malisper.me.| malisper.me
This post is based on half of a talk I gave at !!con. If you want to watch the talk, you can find it here. One not too well known aspect of SQL is that it’s Turing complete. This … Read the rest The post Generating Fractals with Postgres: Escape-Time Fractals appeared first on malisper.me.| malisper.me
I recently gave a talk at !!Con West about how you can use some of the dark corners of SQL to generate fractals. You can watch the recording here: --- To summarize the video, I write SQL queries that generate two … Read the rest The post Generating Fractals with SQL Queries appeared first on malisper.me.| malisper.me
After being in beta for several months, Perfalytics is now generally available. Perfalytics is my attempt to bring a new approach to database performance. Perfalytics integrates directly with your database to collect detailed performance information about your queries. Based on this information, Perfalytics then makes recommendations on how to optimize your queries. I built the […]| malisper.me