A Case for Learning J

There are few things as humbling as learning a programming language of a radically different paradigm from any you’ve used before. Recently, I’ve been feeling a need to learn a language with which I could easily manipulate data – usually collections of numbers. I thought about learning R or Julia, but while I’m sure those […]

Using ActiveRecord to Abstract “Greatest N Per Group” Queries

Some database-related projects require access to information based around maximum and minimum values. Recently, I was trying to figure out the best way to perform a “greatest N per group” query in an ActiveRecord model with a SQL database backend. Eventually, I settled on the SQL proposed by Bill Karwin on StackOverflow. Once I had […]