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...
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.
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...
Apart from his heavy drinking, Roger Sterling appears to have little in common with the outdoorsmen and adventurers often featured in Hemingway novels. Sterling’s coddled upbringing and prominent position atop an advertising agency starkly contrast the rough and dangerous existence of Robert Jordan in For Whom the Bell Tolls. During...
In 2017, the FDIC estimated that 6.5 percent of households in the United States were unbanked and 18.7 percent of households were underbanked. What do these terms mean, and why is this significant?
The FDIC defines “unbanked” as: “no one...