-
Software Development
Why You Should Encrypt ALL Personally Identifiable Information (PII)
Many critics have pointed out that Ashley Madison should have encrypted all personally identifiable information (PII). The database contained sensitive…
Read More » -
Core Java
Adding Database Logging to JUnit3
We have written many thousands of JUnit3 tests over the last decade and are now trying to consolidate the results…
Read More » -
Enterprise Java
Installing PostgreSQL PL/Java as a PostgreSQL Extension
In 2011 I wrote a series of articles on PostgreSQL PL/Java. The basic information is still solid but there is…
Read More » -
Software Development
Extending PostgreSQL: Complex Number Data Type
A few years ago I discussed creating user-defined types using PL/java. (Introduction to PostgreSQL PL/Java, part 4: User Defined Types)…
Read More » -
Core Java
Auto-encrypting Serializable Classes
A crazy idea came up during the post-mortem discussions in the Coursera security capstone project. Can a class encrypt itself…
Read More » -
Software Development
Tips for Importing Data
I’m currently importing a large amount of spatial data into a PostgreSQL/PostGIS database and realized others could learn from my…
Read More » -
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 » -
Software Development
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 » -
Software Development
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 »
