The Curious Engineer

All blogs / Databases

Blog @ RustProof Labs

blog.rustprooflabs.com

DatabasesPerformance / optimizationDev tools / editors / IDEs

’15’20’25
Posts
148 from 1 Jul 2013 to 18 Mar 2026
Posting
now and then (2 in the last year)
Kind
company blog

2026 1

  1. Local LLM with OpenWeb UI and Ollama

2025 2

  1. Improved Quality in OpenStreetMap Road Network for pgRouting
  2. Revisiting Decisions: Improving Systems and Processes

2024 2

  1. Can you use ltree for Nested Place Data?
  2. Hosting a set of Postgres Demo databases

2023 2

  1. full-day pre-conference at PASS 2023
  2. also knew

2022 1

  1. Mastering PostGIS and OpenStreetMap

2021 2

  1. Improved OpenStreetMap data structure in PostGIS - Blog @ RustProof Labs
  2. Better OpenStreetMap places in PostGIS - Blog @ RustProof Labs

2020 17

  1. Hands on with osm2pgsql's new Flex output - Blog @ RustProof Labs
  2. PostGIS Trajectory: Space plus Time - Blog @ RustProof Labs
  3. Find your local SRID in PostGIS - Blog @ RustProof Labs
  4. Postgres 13 Performance with OpenStreetMap data - Blog @ RustProof Labs
  5. PostgreSQL 13Beta3: B-Tree index deduplication - Blog @ RustProof Labs
  6. PostgreSQL: Integers, on-disk order, and performance - Blog @ RustProof Labs
  7. Large Text in PostgreSQL: Performance and Storage - Blog @ RustProof Labs
  8. Pi 4 Performance: PostgreSQL and PostGIS - Blog @ RustProof Labs
  9. Use PostgreSQL file_fdw to Access External Data - Blog @ RustProof Labs
  10. Webinar: Postgres 12 and PostGIS 3 (5/6) - Blog @ RustProof Labs
  11. Webinar: PostGIS Queries and Performance (4/6) - Blog @ RustProof Labs
  12. qgis2web to export and share interactive maps - Blog @ RustProof Labs
  13. Webinar: PostGIS Advanced Features (6/6) - Blog @ RustProof Labs
  14. Webinar: Exploring OpenStreetMap from PostGIS: Tools and Queries (3/6) - Blog @ RustProof Labs
  15. Webinar: Intro to PostGIS and OpenStreetMap (1/6) - Blog @ RustProof Labs
  16. Webinar: Load PostGIS with osm2pgsql (2/6) - Blog @ RustProof Labs
  17. Updated for 2020: Load OpenStreetMap data to PostGIS - Blog @ RustProof Labs

2019 24

  1. Upgrading to Postgres 12 and PostGIS 3 - Blog @ RustProof Labs
  2. Postgres 12 Generated Columns and PostGIS - Blog @ RustProof Labs
  3. PostgreSQL at RustProof Labs: 2019 in Review - Blog @ RustProof Labs
  4. Exploring PgConfig comparison tool - Blog @ RustProof Labs
  5. PgDD - PostgreSQL Data Dictionary Extension - Blog @ RustProof Labs
  6. PostgreSQL 12 and PostGIS 3 Initial Review - Blog @ RustProof Labs
  7. Scaling osm2pgsql: Process and costs - Blog @ RustProof Labs
  8. Prepare for Postgres 12: Configuration Changes - Blog @ RustProof Labs
  9. PostgreSQL on Raspberry Pi 4: Initial Testing - Blog @ RustProof Labs
  10. Create vector layers using PostGIS and QGIS - Blog @ RustProof Labs
  11. PostgreSQL deployments using Ansible and Sqitch - Blog @ RustProof Labs
  12. Postgres and Pi: Use the right SD card - Blog @ RustProof Labs
  13. Installing PostgreSQL and PostGIS from source - Blog @ RustProof Labs
  14. Geometry viewer added to DBeaver - Blog @ RustProof Labs
  15. Contributing to PostgreSQL - Blog @ RustProof Labs
  16. Fixed: XML data and pg_dump - Blog @ RustProof Labs
  17. PostgreSQL performance on Raspberry Pi - Blog @ RustProof Labs
  18. PostgreSQL performance on Raspberry Pi, Reporting edition - Blog @ RustProof Labs
  19. What version of PostgreSQL? - Blog @ RustProof Labs
  20. Low Power Computing with Raspberry Pi - Blog @ RustProof Labs
  21. PgOSM transformations explained - Blog @ RustProof Labs
  22. PgOSM: Transform OpenStreetMap data in PostGIS - Blog @ RustProof Labs
  23. osm2pgsql on a Raspberry Pi - Blog @ RustProof Labs
  24. Load OpenStreetMap data to PostGIS - Blog @ RustProof Labs

2018 19

  1. PostgreSQL at RustProof Labs: 2018 in Review - Blog @ RustProof Labs
  2. PostGIS: Tame your spatial data (Part 2) - Blog @ RustProof Labs
  3. Enhance your PostgreSQL Data Dictionary - Blog @ RustProof Labs
  4. Data Analytics and Software: It still isn't easy - Blog @ RustProof Labs
  5. From Idea to Database: Define, Design, Repeat - Blog @ RustProof Labs
  6. Geometry viewer added to pgAdmin 4 - Blog @ RustProof Labs
  7. Build your Data Dictionary in PostgreSQL - Blog @ RustProof Labs
  8. Invalid `pg_dump` file with XML data - Blog @ RustProof Labs
  9. PostGIS: Tame your spatial data (Part 1) - Blog @ RustProof Labs
  10. Security is a feature. Choose it! - Blog @ RustProof Labs
  11. PostgreSQL Crash Course - Blog @ RustProof Labs
  12. PostgreSQL: From Idea to Database - Table of Contents - Blog @ RustProof Labs
  13. PostgreSQL: From Idea to Database - Introduction - Blog @ RustProof Labs
  14. Introducing the PiWS (Pi Weather Station) - Blog @ RustProof Labs
  15. GDPR Preparation: Google Analytics - Blog @ RustProof Labs
  16. Visualizing Colorado's Growing Population: 2010 to 2016 - Blog @ RustProof Labs
  17. Security Incident - DNS Hijacking - Blog @ RustProof Labs
  18. PostgreSQL 10 Parallel Queries and Performance - Blog @ RustProof Labs
  19. Database Anti-patterns: Performance Killers - Blog @ RustProof Labs

2017 4

  1. PostgreSQL Load Testing - Blog @ RustProof Labs
  2. Goodbye, NewRelic - Blog @ RustProof Labs
  3. Thoughts on Data Security - Blog @ RustProof Labs
  4. South Table Mountain Fire - Blog @ RustProof Labs

2016 8

  1. PostgreSQL vs. MySQL: Why we use PostgreSQL - Blog @ RustProof Labs
  2. My Journey Begins - Blog @ RustProof Labs
  3. Testing PostgreSQL Unlogged Tables for Performance - Blog @ RustProof Labs
  4. Revisting my Tool Set - Blog @ RustProof Labs
  5. Small Community, Big Changes -- The Impact of a Mapping Party - Blog @ RustProof Labs
  6. Stop Using SSL, Use TLS Instead - Blog @ RustProof Labs
  7. Introduction to the Go Map!! App - Blog @ RustProof Labs
  8. New to GIS Software? - Blog @ RustProof Labs

2015 14

  1. Contributing to OpenStreetMap is "Maptastic!" - Blog @ RustProof Labs
  2. "Dockerizing" PostgreSQL - Blog @ RustProof Labs
  3. Docker in Production at RustProof Labs - Blog @ RustProof Labs
  4. SQL for Institutional Research (IR) - Blog @ RustProof Labs
  5. Performance Testing RustProof Content - Blog @ RustProof Labs
  6. PostgreSQL Case Sensitivity Pitfall - Blog @ RustProof Labs
  7. Garden Tracking Database using PostgreSQL - Blog @ RustProof Labs
  8. New Blog Platform: RustProof Content - Blog @ RustProof Labs
  9. Excel and VBA for SQL Server Reporting - Blog @ RustProof Labs
  10. GIS - It's All About the Data - Blog @ RustProof Labs
  11. Installing Scipy? You Need Swap! - Blog @ RustProof Labs
  12. Ode to "The Database" - Blog @ RustProof Labs
  13. Colorado Unemployment: Making the Maps - Blog @ RustProof Labs
  14. Maps! ArcGIS, QGIS, and TileMill - Blog @ RustProof Labs

2014 31

  1. PostgreSQL Setup on Debian - Blog @ RustProof Labs
  2. Fun With Python - Blog @ RustProof Labs
  3. Python and Databases - Blog @ RustProof Labs
  4. Data Processing in Python: PyTables vs PostgreSQL - Blog @ RustProof Labs
  5. Jenkins CI on Debian: Install and Setup - Blog @ RustProof Labs
  6. Watch out for Shellshock - Blog @ RustProof Labs
  7. Install Oracle Database on CentOS 7 - Blog @ RustProof Labs
  8. Checking for Valid Integers in SQL Server 2008 R2 - Blog @ RustProof Labs
  9. Budget Jira Still Going! - Blog @ RustProof Labs
  10. Specialist vs. Generalist - Blog @ RustProof Labs
  11. Creating a Dev CentOS 7 Virtual Machine - Blog @ RustProof Labs
  12. The Cost of Automation - Blog @ RustProof Labs
  13. Improved RustProof Labs -- Coming Soon - Blog @ RustProof Labs
  14. How to Ask IT For Something - Blog @ RustProof Labs
  15. Retrospective Blogging for New Bloggers - Blog @ RustProof Labs
  16. The Server Migration Continues - Blog @ RustProof Labs
  17. Take a Vacation, You Deserve It - Blog @ RustProof Labs
  18. Learning: Music and the Mind - Blog @ RustProof Labs
  19. Security Matters and is Taught Poorly - Blog @ RustProof Labs
  20. Jira On a Budget - Blog @ RustProof Labs
  21. Patience with Communication - Blog @ RustProof Labs
  22. Bring Excel to its Knees! - Blog @ RustProof Labs
  23. Creating a Web Interface for SQL Server Powered Application - Blog @ RustProof Labs
  24. Connecting SQL and MS Access - Part 2 - Blog @ RustProof Labs
  25. Slow Down and Think - Blog @ RustProof Labs
  26. Intro to the Site Maintenance project - Blog @ RustProof Labs
  27. Connecting SQL and MS Access - Part 1 - Blog @ RustProof Labs
  28. Connecting SQL and MS Access - Part 3 - Blog @ RustProof Labs
  29. Why I Don't Like Infographics - Blog @ RustProof Labs
  30. Love Your Career as a Nerd - Blog @ RustProof Labs
  31. Building Reliable Data Solutions - Blog @ RustProof Labs

2013 21

  1. Long Road - My Site Backup Process - Blog @ RustProof Labs
  2. 2013 - Year In Review - Blog @ RustProof Labs
  3. Distractions At Work - Blog @ RustProof Labs
  4. Using SYSTEM_USER to Filter Data - Blog @ RustProof Labs
  5. Long Road - Setup Your Dev Virtual Machine (Part 2) - Blog @ RustProof Labs
  6. Long Road - Setup Your Dev VM (Part 3) - Blog @ RustProof Labs
  7. Using SUM and CASE together - Blog @ RustProof Labs
  8. Long Road to the Right Solution - Blog @ RustProof Labs
  9. Long Road - Setup Your Dev VM (Part 1) - Blog @ RustProof Labs
  10. New Blog Site! - Blog @ RustProof Labs
  11. "How" is Temporary - Blog @ RustProof Labs
  12. Getting Organized and Low Maintenance - Blog @ RustProof Labs
  13. Talk Carefully At Home - Blog @ RustProof Labs
  14. How Will I Know When it Works? - Blog @ RustProof Labs
  15. Right Tool for the Right Job - Blog @ RustProof Labs
  16. My "FIXME:" Challenge - Blog @ RustProof Labs
  17. No NoSQL For Me... Yet - Blog @ RustProof Labs
  18. Lots of Mistakes - Blog @ RustProof Labs
  19. Building a Maintenance Script Repository - Blog @ RustProof Labs
  20. Where is that email... Use a bug tracker! - Blog @ RustProof Labs
  21. Do Something Different - Blog @ RustProof Labs