Andrew Lindner     Blog     Archive     Reading     About

Can You SQL Inject a Jukebox?

Recently, I was grabbing drinks with a former colleague of mine and placed an overconfident wager. While sipping on a round of vodka tonics at a local Chicago bar, I bet her that I could hack into the establishment’s digital jukebox and force it to play her favorite song, Jarvis...

Rails - Handling Record Insertion Race Conditions

Classic Technique

New Rails programmers typically learn the .find_or_create_by method to avoid inserting duplicate records in the database. When invoking this method, Rails will search the database for a record with the specified attributes, and if it does not return one, it will create a new record.

...

Adventures in PostgreSQL - Extract Epoch

Recently I needed to create a database query that compares the timestamps of several rows of data. It took me substantial detective work and googling, so I figured I’d document the solution in a blog post.

PostgreSQL provides various functions for working with date and timestamp...

FinTech 2021

Perspectives on banking in the coming year

In its annual prediction-focused magazine issue, The Economist reviews the current state of the world and attempts to forecast the trends of 2021. Within the finance section of the publication, Matthieu Favas argues that in the next year, “banks will regain ground against...

Brett King on the Future of Financial Advisors

“Alexa, buy 100 shares of Apple!”

“Alexa, can I afford this house?”

“Alexa, how much money have I saved for retirement?”

Whether it’s Siri, Google, Cortana, or Alexa, voice assistants have become ubiquitous companions in our lives. Today...