Software Development
-
Signing Digital Certificates with OpenSSL Library
While working on the pgopenssltypes extension I realized that I haven’t discussed how to sign digital certificates using the OpenSSL…
Read More » -
The Awesome PostgreSQL 9.4 / SQL:2003 FILTER Clause for Aggregate Functions
Sometimes when aggregating data with SQL, we’d love to add some additional filters. For instance, consider the following world bank…
Read More » -
Adding OpenSSL User-Defined Types to PostgreSQL
PostgreSQL supports user-defined types (UDT). These types can be used to provide type-safety on user-defined functions when we would otherwise…
Read More » -
R: Featuring engineering for a linear model
I previously wrote about a linear model I created to predict how many people would RSVP ‘yes’ to a meetup…
Read More » -
R: Vectorising all the things
After my last post about finding the distance a date/time is from the weekend Hadley Wickham suggested I could improve…
Read More » -
Database Threat Models
I finally have a breather and can start working through my backlog of ideas. I start with some background that…
Read More » -
Are You Binding Your Oracle DATEs Correctly? I Bet You Aren’t
Oracle database has its ways. In my SQL talks at conferences, I love to confuse people with the following Oracle…
Read More » -
Two Years of Pair Programming
For the last two years, I’ve built software using pair programming. I recently switched jobs; during this process, I talked…
Read More » -
You Do Need Independent Technical Reviews!
Do you have a team of brilliant and enthusiastic programmers? Of course! You’ve carefully chosen them from a hundred candidates!…
Read More »
