PostgreSQL Case Sensitivity Pitfall
A little while back I was working on Dockerizing my PostgreSQL instances, and I ran into a headache caused by the case sensitiveness of PostgreSQL. This isn't the first time that PostgreSQL has caught me off guard with being case sensitive where I didn't expect so I wanted to document this before I forget what happened. It was a bit more difficult to troubleshoot this time since I was erroneously blaming the issue on being related to running inside a Docker container, which turned out to not be a problem at all.
Performance Testing RustProof Content
In June I made the change to using my own custom-built blog platform: RustProof Content. Before going live I did enough performance testing to at least know that in terms of performance, RustProof Content would blow WordPress away. Now that it's been live for about a month and I had a bit of free time, I decided it was time to start benchmarking RustProof Content's performance a bit more thoroughly.
Setting Up for Testing
When deciding if I should leave WordPress or not, I used New Relic to help identify the issues I was experiencing with performance. Now that the switch has been made, I'm back using New Relic to ensure this site continues to perform as expected. I'm taking advantage of their Application (APM), Browser and Server monitoring tools to keep everything in check.
Garden Tracking Database using PostgreSQL
This year my wife and I have taken our gardening to a whole new level. We tore down a nasty old, wasp-infested shed in the sunniest part of our yard and built a raised garden bed in its place. We also setup an area inside with some crazy (awesome) LED grow lights that allow us to start plants from seed and produce healthy transplants, all in our house with zero south facing windows.
If you're not interested in the database I'm building, feel free to just look at the pictures of our garden scattered throughout this post!
This post is not about our gardens. It's about the database I am building to track our gardening endeavors though there are a bunch of pictures of our garden throughout.
New Blog Platform: RustProof Content
The RustProof Labs blog is now being served by our own, custom built system called RustProof Content. What is RustProof Content? Well, for starters... you're looking at it now!
Meet RustProof Content!
RustProof Content is a dynamic site built on the Flask micro-framework and Python 3.3+. Content is served from almost-static HTML files that include Jinja2 tags to fit into the layouts. Being mostly HTML, it is blazingly fast especially when compared to WordPress. The HTML files (including Jinja tags) are generated from content written and stored in Markdown format, while the source code and Markdown content are tracked and distributed using Git.
GIS - It's All About the Data
When you’re working with GIS, it’s all about the data. Once you have the spatial data to work with, you need to clean and manage it in order to effectively use it, and that has been my biggest challenge when working with spatial data. This post attempts to share some of my experiences with a couple systems for storing and managing spatial data.
If you are using PostGIS, see my PostGIS: Table Your Spatial data posts. Part 1 shows how to improve performance with large polygons, part 2 shows how to reduce many small objects.
Mastodon