Software Development
-
Top Three Challenges in Enterprise Mobile App Development in 2015
Enterprises are adopting mobile technologies at an unprecedented rate. As Business News Daily recently reported, 1.3 billion workers will go…
Read More » -
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 »
