PostgreSQL has a feature called UNLOGGED tables. I became intrigued by UNLOGGED tables after reading this post. According to the docs:

"Data written to unlogged tables is not written to the write-ahead log (see Chapter 29), which makes them considerably faster than ordinary tables. However, they are not crash-safe: an unlogged table is automatically truncated after a crash or unclean shutdown."

It's important to note that unlogged tables shouldn't be used for storing critical data. My use case for them is to quickly load data to staging tables before cleaning and reorganizing. I end up importing large amounts of data on a regular basis, so this is of interest to me. I decided to test regular tables vs unlogged tables by importing 6 months of NOAA's hourly weather data. You can read about my previous tests with this data here.

Continue Reading

It's been over two years since I first wrote about the tools I use regularly as a programmer. Some things have changed, others have persisted. In this post I go through my current tool set with some explanations of why things have either changed or stayed they same.

Some tools haven't changed a bit. Git, SourceTree, VirtualBox and Jenkins are four tools that I still can't live without. Also, my MacBook is now even older, but with a new SSD it seems to have new life.

Continue Reading

RustProof Labs just completed another Maptastic mapping party! The event was held on April 9, 2016 in Golden, Colorado. Our home base for the event was with the fantastic folks at Pangea Coffee Roasters. Matt, Amanda, and the rest of their friendly staff couldn't have been better hosts for this event! We had 14 total volunteers with 5 of them being "mini-mappers" under the age of 15. My favorite part of the event was seeing the sheer excitement, thrill and enthusiasm of our mini-mappers (and adults) who participated.

Our Volunteers and Pangea Coffee Roasters all deserve a huge Thank You! Without you, events like this are not possible.

The main goal of this post is to visualize the incredible impact our team of volunteers had on the data for our local community. I also want to discuss a few reasons why I think OpenStreetMap is such a valuable project. Before I go on, check out the first time lapse showing how the data in Golden has improved. Feel free to take your time and really watch how the map has improved in various areas.

All data used throughout this post is © OpenStreetMap Contributors.

Continue Reading

Security matters. One of the bigger security issues I see in our online security that too many people are supporting outdated, insecure technologies. One of the big offenders is "SSL" (Secure Socket Layer). Recently, a new attack against SSL v2 was discovered, dubbed the "DROWN" attack. Part of what makes me wonder about this, is why do systems in 2016 still support protocols that have been known to be insecure for more than 5 years? Further, even the most recent version of the SSL protocol (v3) has been insecure since 2014 when the POODLE vulnerability was discovered.

In reality, SSL has been antiquated for quite some time being superseded by "TLS" (Transport Layer Security).

SSL Is Insecure; use TLS instead. I want to make clear that there is no secure SSL protocol remaining.

Continue Reading

Do you want to contribute to OpenStreetMap on the go from your iOS device but don't know where to begin? This post discusses using the Go Map!! app available for free from the App store to do just that. This post assumes you have already created your OpenStreetMap account and have installed the Go Map!! app from the App store.

If you're using an Android smartphone you may want to check out Vespucci, though being an Apple user I have no way to try that out.

First Steps

The first thing to do when you open the Go Map!! app is to get acquainted with the toolbar options at the bottom of the screen.

The left-most option is the GPS icon that enables and disables use of GPS on your device. It has three states:

Continue Reading