---
title: "Joshua Rubio (@spectreworks) | Hashnode"
description: "Joshua Rubio (@spectreworks) writes on Hashnode. Read their latest articles and follow their work."
url: "https://hashnode.com/@spectreworks"
---

@spectreworks

# Joshua Rubio

@spectreworks · Phoenix, USA · Joined May 2026

### ["localhost" Means Two Different Things, and Docker Compose Doesn't Warn You](https://blog.spectreworks.ai/localhost-means-two-different-things-and-docker-compose-doesn-t-warn-you?utm_source=hashnode&utm_medium=feed)

Containerized the CVE ingestion service today. Ran perfectly on the VPS directly, the way it had for weeks. Put it in Docker, ran it again, and it broke immediately. psycopg2.OperationalError: connect

2 min read · [blog.spectreworks.ai](https://blog.spectreworks.ai/localhost-means-two-different-things-and-docker-compose-doesn-t-warn-you?utm_source=hashnode&utm_medium=feed)

[Oct 1](https://hashnode.com/posts/localhost-means-two-different-things-and-docker-compose-doesn-t-warn-you/6abe42a5a598755c8ec38f75)

### [Rotating a Live Credential Without Losing Any Data](https://blog.spectreworks.ai/rotating-a-live-credential-without-losing-any-data?utm_source=hashnode&utm_medium=feed)

Pasted a live database password into a screenshot today. Not great. No dramatic reveal here - no breach, no attacker, nothing clever. Just a screenshot taken mid-session that had a real credential sit

3 min read · [blog.spectreworks.ai](https://blog.spectreworks.ai/rotating-a-live-credential-without-losing-any-data?utm_source=hashnode&utm_medium=feed)

[2](https://hashnode.com/posts/rotating-a-live-credential-without-losing-any-data/6abca8e5f87d59f11e72407e) [Sep 30](https://hashnode.com/posts/rotating-a-live-credential-without-losing-any-data/6abca8e5f87d59f11e72407e)

### [Store the Fact: Why Alerts Get Real Foreign Keys](https://blog.spectreworks.ai/store-the-fact-why-alerts-get-real-foreign-keys?utm_source=hashnode&utm_medium=feed)

The system I reviewed for reference computes CVE-to-CVE relationships on the fly, at query time. Nothing stored, everything derived when someone asks. For that use case it works fine. For the alert la

3 min read · [blog.spectreworks.ai](https://blog.spectreworks.ai/store-the-fact-why-alerts-get-real-foreign-keys?utm_source=hashnode&utm_medium=feed)

[Sep 28](https://hashnode.com/posts/store-the-fact-why-alerts-get-real-foreign-keys/6ab9db062f191c6288b1f915)

### [Natural Key or Surrogate Key? The First Real Fork in the CVEs Table](https://blog.spectreworks.ai/natural-key-or-surrogate-key-the-first-real-fork-in-the-cves-table?utm_source=hashnode&utm_medium=feed)

Designing the cves table, I hit the first real decision that wasn't obvious: what's the primary key? CVE IDs look like a gift. They're unique, human-readable, and already assigned by someone else. CVE

2 min read · [blog.spectreworks.ai](https://blog.spectreworks.ai/natural-key-or-surrogate-key-the-first-real-fork-in-the-cves-table?utm_source=hashnode&utm_medium=feed)

[Sep 28](https://hashnode.com/posts/natural-key-or-surrogate-key-the-first-real-fork-in-the-cves-table/6ab9b11468a0465a0dd0accc)

### [The venv Trap: Why "I Already Installed It" Doesn't Mean What You Think](https://blog.spectreworks.ai/the-venv-trap-why-i-already-installed-it-doesn-t-mean-what-you-think?utm_source=hashnode&utm_medium=feed)

Two sessions, same error, both times I was sure I was wrong to be confused: ModuleNotFoundError: No module named 'psycopg2' I'd installed psycopg2-binary already. I knew I had. First session, I chalke

3 min read · [blog.spectreworks.ai](https://blog.spectreworks.ai/the-venv-trap-why-i-already-installed-it-doesn-t-mean-what-you-think?utm_source=hashnode&utm_medium=feed)

[Sep 27](https://hashnode.com/posts/the-venv-trap-why-i-already-installed-it-doesn-t-mean-what-you-think/6ab9593de19f5ffb498ac059)
