---
title: "Blog"
description: "Posts about databases, developer tools, smart homes, and the things I build."
url: https://www.joekarlsson.com/blog/
---

[My Homelab Two Years Later, Every Upgrade and What It Cost Mar 5, 2026 | 24 min read](https://www.joekarlsson.com/blog/homelab-two-years-later/)

159 posts since 2015

# Blog

[New](https://www.joekarlsson.com/blog/sentence-length-semicolons-punctuation/): Are English sentences getting shorter? About 40% of the drop is punctuation Nov 10, 2026

-   Nov 10, 2026 | 22 min read | Web Dev [Are English sentences getting shorter? About 40% of the drop is punctuation](https://www.joekarlsson.com/blog/sentence-length-semicolons-punctuation/)
    
    Are English sentences getting shorter? In 1,959 Project Gutenberg books, about 40% of the drop in sentence length is periods doing the semicolon's job.
    
-   Nov 10, 2026 | 9 min read | AI, Career [Rereading Hackers and Painters as a painter who codes with AI agents](https://www.joekarlsson.com/blog/hackers-and-painters-ai-agents/)
    
    I reread Paul Graham's Hackers and Painters as a painter who codes with AI agents. The sketching idea held up. Beautiful code nobody reads is what I miss.
    
-   Nov 9, 2026 | 10 min read | Life, Homelab [A tour of my recording setup in 2026, all on one standing desk that rolls](https://www.joekarlsson.com/blog/recording-setup-tour/)
    
    A tour of my home recording setup: Sony ZV-E10, teleprompter and mic on one rolling desk, a Home Assistant recording mode, and lighting I got wrong twice.
    
-   Nov 9, 2026 | 11 min read | Homelab [Homelab gift ideas 2026: gear from my rack and desk, sorted by price](https://www.joekarlsson.com/blog/homelab-gift-ideas-2026/)
    
    Homelab gift ideas for 2026 from gear I run every day, sorted by price, with one question to ask before you buy and a list of what not to buy.
    
-   Nov 5, 2026 | 16 min read | AI | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [I Wired Doom to Two MCP Servers and Let Claude Play It](https://www.joekarlsson.com/blog/doom-mcp-server/)
    
    A Doom MCP server lets Claude Code play a level built from live MCP data. See what AI agents did when the MCP server refused a request.
    
-   Oct 30, 2026 | 9 min read | AI, Homelab [Can Open Knowledge Format make Claude Code more accurate and cheaper? I tested it](https://www.joekarlsson.com/blog/claude-md-open-knowledge-format/)
    
    I moved the CLAUDE.md files and memory Claude Code reads into Open Knowledge Format and tested three versions. Restructuring halved startup context.
    
-   Oct 26, 2026 | 13 min read | AI | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [Best MCP Servers for ChatGPT, Dots, and Meta Muse](https://www.joekarlsson.com/blog/best-mcp-servers-chatgpt-meta-muse/)
    
    Best MCP servers for ChatGPT, dots, and Meta Muse in 2026, compared by use case, with the criteria business and IT teams use to approve one.
    
-   Oct 16, 2026 | 8 min read | AI, Career [I put an MCP server inside DOOM](https://www.joekarlsson.com/blog/why-i-use-doom-to-visualize-mcp-data/)
    
    An MCP server inside DOOM: an AI agent pulls live records over MCP and each becomes a monster. The first level built from MCP data, shown at MCPCon 2026.
    
-   Oct 16, 2026 | 6 min read | AI [First impressions of Claude Code mods](https://www.joekarlsson.com/blog/claude-code-mods-first-impressions/)
    
    Claude Code mods, new in October 2026, enforce rules that hooks and CLAUDE.md only hope Claude remembers. What I built in two days and what worries me.
    
-   Oct 15, 2026 | 13 min read | AI | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [How to Use ChatGPT Dots with Salesforce, Jira, and More](https://www.joekarlsson.com/blog/how-to-use-chatgpt-dots/)
    
    How to use ChatGPT dots with Salesforce, Jira, QuickBooks, and more: connect your business apps in minutes, then ask across them and schedule checks.
    
-   Oct 13, 2026 | 6 min read | Newsletter [Why I Self-Host My Newsletter](https://www.joekarlsson.com/newsletter/why-i-self-host-my-newsletter/)
    
    Why my newsletter runs in my homelab, why I picked listmonk over Ghost, and what I haven't figured out about outgrowing a free email plan.
    
-   Oct 12, 2026 | 7 min read | Newsletter [Taste Matters More with AI](https://www.joekarlsson.com/newsletter/taste-matters-more-with-ai/)
    
    The newsletter is back after almost three years, it runs in my homelab now, and it's going to be about what I actually think about. First up, taste.
    
-   Oct 12, 2026 | 6 min read | Web Dev, Career [I hate editing video, so I built a screen recorder that edits for me](https://www.joekarlsson.com/blog/screencast-director-screen-recorder/)
    
    Screencast Director is an open source macOS screen recorder that drafts the edit. It cuts dead air, speeds up typing and takes edits from your AI model.
    
-   Oct 12, 2026 | 8 min read | Homelab [I built a 32x32 pixel art frame that shows what my house is doing](https://www.joekarlsson.com/blog/pixelpane-pixel-art-home-assistant/)
    
    PixelPane is my open source 32x32 LED pixel art frame. Its art changes with the seasons, and Home Assistant turns it into an ON AIR sign and a doorbell alert.
    
-   Oct 6, 2026 | 10 min read | AI, Homelab [Breaking up with Claude Code](https://www.joekarlsson.com/blog/breaking-up-with-claude-code/)
    
    OpenCode with open models isn't a one-to-one swap for Claude Code. What broke, what fixed it, and which models I use.
    
-   Sep 30, 2026 | 21 min read | Homelab [My Development Setup in 2026](https://www.joekarlsson.com/blog/my-development-setup-2026/)
    
    My development setup in 2026: Ghostty, plain zsh, Handy voice input, git worktrees for concurrent Claude Code agents, and chezmoi. What I switched and why.
    
-   Sep 29, 2026 | 23 min read | Homelab [The Best Home Assistant Automations of 2027 (10 Years In)](https://www.joekarlsson.com/blog/best-home-assistant-automations/)
    
    The best Home Assistant automations after 10 years and 134 running: start with the basics, layer on context, go advanced, and keep them working.
    
-   Sep 28, 2026 | 14 min read | AI | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [Enterprise Data Access for AI Agents: What Model Routing Doesn't Cover](https://www.joekarlsson.com/blog/ai-gateway-data-access-layer/)
    
    Enterprise data access for AI agents is the part of the AI gateway stack most teams haven't built yet. Here's what it handles and why it matters now.
    
-   Sep 28, 2026 | 8 min read | AI | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [AI Gateway for Developers: What Teams Are Building on Live Enterprise Data](https://www.joekarlsson.com/blog/ai-gateway-for-developers/)
    
    Building internal AI agents on enterprise data without a custom permission system. Here's what teams are shipping on CData Connect AI in 2026.
    
-   Sep 28, 2026 | 15 min read | AI | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [LiteLLM or CData Connect AI? Choosing the Right Enterprise AI Gateway in 2026](https://www.joekarlsson.com/blog/litellm-vs-cdata-connect-ai/)
    
    LiteLLM vs enterprise AI gateway, 2026 comparison: MCP governance, data connectivity, and when to use each. For IT admins and AI engineers.
    
-   Sep 25, 2026 | 6 min read | Web Dev, Career [I Can't Memorize Lines, So I Built a Teleprompter That Listens](https://www.joekarlsson.com/blog/followspot-local-whisper-teleprompter/)
    
    FollowSpot is a voice-following browser teleprompter that runs Whisper locally. Why I built it, plus benchmarks of five Whisper models on an M5 Max.
    
-   Sep 25, 2026 | 3 min read | Homelab [I Made Adult Swim Bumpers for My Plex Server](https://www.joekarlsson.com/blog/adult-swim-bumpers-plex-pre-rolls/)
    
    I grew up on Toonami and Adult Swim, so I built a little CLI that makes Adult Swim-style bumpers and now every movie on my Plex server opens with one.
    
-   Sep 22, 2026 | 8 min read | AI | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [How to Connect Your Business Apps to Meta Muse](https://www.joekarlsson.com/blog/connect-business-apps-meta-muse/)
    
    Connect enterprise data to Meta Muse with CData Connect AI. Add Salesforce, NetSuite, or HubSpot as a custom connector in about 10 minutes.
    
-   Sep 14, 2026 | 13 min read | AI | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [The Official MCP Roadmap: What Enterprise Teams Need to Plan for](https://www.joekarlsson.com/blog/official-mcp-roadmap-explained/)
    
    The official MCP roadmap (Aug 22, 2026) maps five priorities. Here's what each means if you operate MCP servers, and what the spec still won't fix for you.
    
-   Sep 11, 2026 | 9 min read | Career [Ship the Ugly Pot](https://www.joekarlsson.com/blog/ship-the-ugly-pot/)
    
    Quantity beats quality as a learning strategy: the Art & Fear pottery story, DORA deploy data, and how to tell a kiln from a gate in your org.
    
-   Aug 31, 2026 | 9 min read | Career [The Cognitive Case for Play in Technical Work](https://www.joekarlsson.com/blog/cognitive-case-for-play-in-technical-work/)
    
    What research on creativity, flow and psychological safety says about the conditions behind your best iterative technical work, and how to build them.
    
-   Aug 4, 2026 | 4 min read | Cloud, Career | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [What I Learned When I Could Finally Prove My Work Mattered](https://www.joekarlsson.com/blog/proving-my-work-mattered/)
    
    For most of my last job I couldn't say whether my work mattered. What the data taught me once I had it, and what it did to my influence.
    
-   Jul 28, 2026 | 3 min read | AI | [Written for CData](https://www.joekarlsson.com/blog/written-for/cdata/) [The 2026-07-28 MCP Release Explained: What It Means for Enterprise Teams](https://www.joekarlsson.com/blog/mcp-2026-07-28-release-explained/)
    
    The MCP 2026-07-28 release makes the protocol stateless, adds an extensions framework and hardens authorization. What each change means in production.
    
-   May 27, 2026 | 15 min read | Homelab [I Finally Stopped Managing My Homelab by Hand (Everything Just Kept Breaking)](https://www.joekarlsson.com/blog/opentofu-proxmox-immutable-homelab/)
    
    How I moved 62 Proxmox containers to OpenTofu with a self-hosted state backend (MinIO, now its fork Silo), and whether immutable infrastructure was worth it.
    
-   Apr 21, 2026 | 17 min read | Career [Running DevRel in 2027 Means Owning Three Discovery Surfaces](https://www.joekarlsson.com/blog/running-devrel/)
    
    Running DevRel in 2027: developers find you through people, search, and LLMs. What breaks on each surface, how I measure it, and my first 90 days.
    
-   Apr 13, 2026 | 12 min read | Homelab | One of my 10 most-read posts [How I Share Two Used GPUs Across Seven Services in My Proxmox Homelab](https://www.joekarlsson.com/blog/proxmox-gpu-passthrough-multi-service/)
    
    Proxmox GPU passthrough for LXC: how I share an 8GB Quadro RTX 4000 and a 16GB RTX A4000 across seven services, with local LLM speed and accuracy tests.
    
-   Apr 13, 2026 | 19 min read | Homelab | One of my 10 most-read posts [I Built a Fully Local Voice Assistant for Home Assistant (With GPU, No Cloud Required)](https://www.joekarlsson.com/blog/local-voice-ai-home-assistant-gpu/)
    
    How I run a fully local voice assistant for Home Assistant on a GPU with faster-whisper, Piper and Ollama, and what failed on the way there.
    
-   Apr 7, 2026 | 26 min read | Career | One of my 10 most-read posts [Reversing SEO Traffic Decline From AI Overviews: A Weekly Audit (2026)](https://www.joekarlsson.com/blog/reversing-seo-traffic-decline-ai-overviews/)
    
    How I reversed an SEO traffic decline caused partly by AI Overviews: two failure modes, a weekly Claude Code audit, and real numbers from four weeks.
    
-   Apr 7, 2026 | 21 min read | AI, Career [My Personal Claude Code Skills Repo Accidentally Became Internal Tooling](https://www.joekarlsson.com/blog/my-personal-claude-code-skills-repo-accidentally-became-internal-tooling/)
    
    I built Claude Code skills to stop copy-pasting the same prompts. Then coworkers started asking about them, and my repo became team infrastructure.
    
-   Apr 6, 2026 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [AWS IAM Identity Center (Formerly AWS SSO): The Complete 2026 Guide](https://www.joekarlsson.com/blog/aws-identity-center-guide/)
    
    AWS IAM Identity Center replaced AWS SSO in 2022. Learn how to set it up, configure permission sets, use the AWS CLI, and audit access with CloudQuery.
    
-   Apr 6, 2026 | 8 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [CWPP vs CNAPP: What Cloud Security Teams Need to Know in 2026](https://www.joekarlsson.com/blog/cwpp-vs-cnapp/)
    
    CWPP protects cloud workloads at runtime. CNAPP unifies CWPP, CSPM, and CIEM into one platform. Learn when each makes sense and how they compare.
    
-   Apr 6, 2026 | 9 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [What Is Attack Surface Management? A Technical Guide for Cloud Teams](https://www.joekarlsson.com/blog/what-is-attack-surface-management/)
    
    Attack surface management finds exposed cloud assets before attackers do. Learn how ASM differs from CSPM and vulnerability management, with SQL examples.
    
-   Apr 6, 2026 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [What Is Cloud Governance? The Complete Guide for Platform Engineering Teams](https://www.joekarlsson.com/blog/what-is-cloud-governance/)
    
    Cloud governance is the policies and controls that keep cloud infrastructure secure, compliant and cost-efficient. The 6 pillars and how to implement them.
    
-   Mar 24, 2026 | 11 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [AWS Pinpoint Is Being Deprecated: How to Assess Your Migration Scope](https://www.joekarlsson.com/blog/aws-pinpoint-deprecation-assessment/)
    
    AWS Pinpoint reaches end of support October 2026. Query your Pinpoint usage across all accounts to find what needs migrating before the deadline.
    
-   Mar 22, 2026 | 7 min read | Homelab | One of my 10 most-read posts [How to get started with Home Assistant in 2027](https://www.joekarlsson.com/blog/how-to-get-started-with-home-assistant/)
    
    How I got started with Home Assistant, what changed for 2027 (the Marketplace, Apps, new triggers), what to install it on, and the first automations to try.
    
-   Mar 22, 2026 | 12 min read | Homelab | One of my 10 most-read posts [Self-Hosted Music Still Sucks in 2026](https://www.joekarlsson.com/blog/self-hosted-music-still-sucks-in-2026/)
    
    The \*arr stack perfected video automation, but self-hosted music is stuck on albums. Lidarr makes you grab a whole album when you want one track.
    
-   Mar 6, 2026 | 13 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [CloudQuery Sync Performance: A Practical Troubleshooting Guide](https://www.joekarlsson.com/blog/cloudquery-sync-performance-guide/)
    
    Why CloudQuery syncs slow down after a plugin upgrade, how to spot expensive tables, and the CLI command that replaces the tables wildcard with a list.
    
-   Mar 6, 2026 | 8 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Did Gemini Just Make Your Google API Keys a Security Risk?](https://www.joekarlsson.com/blog/gcp-gemini-api-key-audit/)
    
    Google API keys safe to embed publicly now authenticate to Gemini. Here's how to audit your GCP projects with CloudQuery to find the exposure.
    
-   Mar 5, 2026 | 5 min read | Homelab | One of my 10 most-read posts [Implementing MikroTik's Binary API Protocol in Python from Scratch](https://www.joekarlsson.com/blog/implementing-mikrotik-binary-api-protocol-in-python/)
    
    How I implemented MikroTik's RouterOS binary API protocol in Python from scratch, with variable-length encoding and sentence-based messages, in 137 lines.
    
-   Mar 4, 2026 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Cloud Operations Metrics and ROI for Leadership](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-12-cloud-operations-metrics-scorecard/)
    
    Track the five metric categories that prove cloud operations ROI to leadership. Includes a one-page scorecard template with before-and-after targets.
    
-   Mar 3, 2026 | 11 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [A 90-Day Roadmap to Cloud Operations Maturity](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-11-90-day-cloud-operations-roadmap/)
    
    A week-by-week plan from first inventory sync to automated governance. Three phases, clear milestones, and metrics to prove ROI to leadership.
    
-   Feb 28, 2026 | 11 min read | AI | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [What Makes a Cloud Data Layer AI-Ready](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-10-ai-ready-cloud-data-layer/)
    
    AI for cloud operations is only as good as the data behind it. Learn what makes a cloud data layer AI-ready and which use cases it enables first.
    
-   Feb 27, 2026 | 13 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Mapping SOC 2 and CIS Controls to SQL for Continuous Compliance](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-09-continuous-compliance-sql/)
    
    Map SOC 2 and CIS controls to SQL queries that run daily. Replace quarterly audit scrambles with continuous compliance evidence generation.
    
-   Feb 26, 2026 | 12 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Writing Cloud Security Posture Checks in SQL](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-08-cloud-security-posture-sql/)
    
    Write cloud security checks in SQL instead of proprietary policy languages. See practical queries for public buckets, MFA, encryption, and more.
    
-   Feb 25, 2026 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Beyond Deploy-Time Checks: Continuous Cloud Governance](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-07-continuous-cloud-governance/)
    
    Deploy-time policy checks miss console changes, configuration drift, and external changes. Continuous governance catches what CI/CD pipelines cannot.
    
-   Feb 24, 2026 | 11 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Visibility-First Cloud Governance: Why You Should Start with Data](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-06-visibility-first-governance-model/)
    
    Most governance models fail because they enforce rules about infrastructure they cannot see. The Visibility-First model starts with a queryable foundation.
    
-   Feb 21, 2026 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Calculating the True Cost of Cloud Operations Toil](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-05-cloud-waste-calculator/)
    
    Engineering toil from fragmented cloud visibility costs $47K-$90K per engineer yearly. Use our calculator to measure the real cost at your organization.
    
-   Feb 20, 2026 | 9 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Why Cloud Compliance Audit Prep Still Takes Weeks](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-04-cost-of-compliance-scrambles/)
    
    Most teams spend weeks preparing for audits that should take hours. Learn why compliance scrambles persist and how queryable data eliminates them.
    
-   Feb 19, 2026 | 11 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [The Hidden Cost of Cloud Security Alert Investigation](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-03-hidden-security-tax/)
    
    Security teams spend more time correlating information than fixing problems. See how a single alert costs 45 minutes of manual investigation.
    
-   Feb 17, 2026 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [The Cloud Operations Gap in Multi-Cloud Environments](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-01-cloud-operations-gap/)
    
    89% of organizations use multiple clouds but only 8% are cloud-mature. Learn what the Cloud Operations Gap is and why it costs teams hours every week.
    
-   Feb 17, 2026 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Cloud Operations Maturity Model: A Six-Dimension Self-Assessment](https://www.joekarlsson.com/blog/cloud-operations-playbook-part-02-cloud-operations-maturity-model/)
    
    Score your cloud operations maturity across six dimensions. Only 8% of orgs qualify as highly cloud-mature - here is where most teams actually fall.
    
-   Feb 12, 2026 | 13 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How to Detect Public Databases Across AWS, Azure, and GCP with CloudQuery Policies](https://www.joekarlsson.com/blog/detect-public-databases-across-aws-azure-gcp/)
    
    Detect publicly accessible databases across AWS RDS, Azure, and GCP Cloud SQL. Step-by-step CloudQuery Policies tutorial with copy-paste ClickHouse SQL.
    
-   Feb 10, 2026 | 13 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [AWS Lambda Python 3.9 End-of-Support: Find and Upgrade Every Affected Function](https://www.joekarlsson.com/blog/python-39-lambda-deprecation/)
    
    AWS Lambda Python 3.9 security patches stopped Dec 15, 2025. Find every affected function across all accounts with SQL queries and upgrade to 3.12 or 3.13.
    
-   Feb 5, 2026 | 6 min read | Homelab, AI [Building a GPU-Accelerated Subtitle Generator for My Video Library](https://www.joekarlsson.com/blog/building-a-gpu-accelerated-subtitle-generator/)
    
    How I built a GPU-accelerated subtitle generator for my video library with faster-whisper on my homelab, with parallel workers and a hallucination filter.
    
-   Feb 5, 2026 | 5 min read | Homelab, Web Dev [Building a Real-Time Digital Graffiti Wall with MongoDB Realm and RGB LEDs](https://www.joekarlsson.com/blog/building-a-real-time-digital-graffiti-wall/)
    
    How I built a real-time digital graffiti wall - a shared drawing canvas that shows up live on an RGB LED grid, synced with MongoDB Realm.
    
-   Feb 1, 2026 | 5 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Steampipe vs CloudQuery: Architecture and Trade-offs](https://www.joekarlsson.com/blog/steampipe-vs-cloudquery/)
    
    Steampipe queries cloud APIs live from the terminal. CloudQuery syncs cloud configuration into a persistent inventory. Here is when to use each.
    
-   Jan 26, 2026 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [One Year Into DORA: What Actually Worked for ICT Asset Registers](https://www.joekarlsson.com/blog/dora-ict-asset-register/)
    
    One year into DORA, 46% of institutions still struggle with ICT asset registers. What worked, common pitfalls, and prep for stricter 2026 enforcement.
    
-   Jan 21, 2026 | 6 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [CodeBreach Vulnerability: How to Detect If Your AWS CodeBuild Projects Are Affected](https://www.joekarlsson.com/blog/codebreach-vulnerability-detection/)
    
    Check your AWS CodeBuild webhook filters for the CodeBreach vulnerability, with SQL queries that find unanchored ACTOR\_ACCOUNT\_ID patterns.
    
-   Jan 20, 2026 | 6 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [AWS + Google Cloud Networking Partnership: Connectivity Solved, Visibility Still Broken](https://www.joekarlsson.com/blog/aws-google-cloud-networking-partnership/)
    
    AWS and Google Cloud partnered on multicloud networking, with connections in minutes. The pipes were the easy part. Unified visibility is still broken.
    
-   Jan 4, 2026 | 4 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Audit CODEOWNERS Against Okta to Find Orphaned Code Ownership with SQL](https://www.joekarlsson.com/blog/audit-codeowners-against-okta-with-sql/)
    
    Find CODEOWNERS entries for employees who left the company by joining Git file content with your identity provider data. No scripts, just SQL.
    
-   Jan 4, 2026 | 4 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Find Commits by Departed Employees Across All Repos with SQL](https://www.joekarlsson.com/blog/find-commits-by-departed-employees-with-sql/)
    
    Find code changes by employees who left your organization by matching git commit authors against your identity provider with SQL.
    
-   Jan 4, 2026 | 3 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Find Every repo Missing a LICENSE File with One SQL Query](https://www.joekarlsson.com/blog/find-repos-missing-license-files-with-sql/)
    
    Find every repository missing a LICENSE file across your organization with one SQL query over your git file data. No cloning, no scripts to maintain.
    
-   Jan 4, 2026 | 7 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Find EOL Docker Images, Missing Licenses, and Stale CODEOWNERS Across Thousands of repos with SQL](https://www.joekarlsson.com/blog/introducing-the-git-source-plugin/)
    
    Query Dockerfiles, CODEOWNERS and package.json across all your repos with SQL to find EOL Docker images, missing licenses and stale CODEOWNERS, no cloning.
    
-   Jan 4, 2026 | 3 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Query Your Dockerfiles with SQL: Find EOL Node 18 Images Across All repos](https://www.joekarlsson.com/blog/query-dockerfiles-for-eol-base-images-with-sql/)
    
    Node 18 reached end-of-life. Find every Dockerfile using Node 18 base images across your organization with a single SQL query - no cloning repos required.
    
-   Jan 4, 2026 | 4 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Track React Dependencies Across Your Organization with SQL](https://www.joekarlsson.com/blog/track-react-dependencies-across-repos-with-sql/)
    
    Find every package.json using React across all repositories. Query dependency versions, track upgrades, identify outdated packages - all with SQL.
    
-   Jan 1, 2026 | 2 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How Unicorne Increased Well-Architected Review Capacity by 60% with CloudQuery](https://www.joekarlsson.com/blog/unicorne-cloudquery-case-study/)
    
    How Unicorne used CloudQuery to automate AWS Well-Architected Reviews and build its FinOps product Stable, cutting engagements from 50 to 20 hours.
    
-   Nov 24, 2025 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [AWS Lambda Node.js 20 End of Life: Upgrade to Node.js 22 Before April 2026](https://www.joekarlsson.com/blog/aws-lambda-nodejs-20-eol/)
    
    AWS Lambda Node.js 20 hits end of life April 30, 2026. How to find every affected function across accounts, fix breaking changes and upgrade to Node.js 22.
    
-   Oct 29, 2025 | 14 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [6 Cloud CMDB Best Practices for Platform Engineers (2026 Guide)](https://www.joekarlsson.com/blog/cloud-cmdb-best-practices-platform-engineers/)
    
    Cloud CMDB best practices for multi-account environments - automated discovery, tiered sync, SQL queries, and historical retention for compliance.
    
-   Oct 24, 2025 | 5 min read | AI | One of my 10 most-read posts [Building a Claude Code Blog Skill: What I Learned Systematizing Content Creation](https://www.joekarlsson.com/blog/building-a-claude-code-blog-skill-what-i-learned-systematizing-content-creation/)
    
    Building a Claude Code blog skill - how I turned my own blog workflow, from banned words to Vale linting and PRs, into a skill our marketing team can run.
    
-   Oct 24, 2025 | 12 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [The Death of Agent-Based CMDB Discovery](https://www.joekarlsson.com/blog/death-of-agent-based-discovery/)
    
    Agent-based CMDB discovery breaks down with containers, serverless and managed services. API-driven discovery costs 90% less and works everywhere.
    
-   Oct 24, 2025 | 12 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [The Real-Time Cloud CMDB - Why Ephemeral Infrastructure Killed Traditional Discovery](https://www.joekarlsson.com/blog/real-time-cloud-cmdb-ephemeral-infrastructure/)
    
    Traditional CMDBs miss ephemeral resources because containers live minutes. How cloud CMDBs use tiered sync, from 15 minutes to daily, and what it costs.
    
-   Oct 20, 2025 | 12 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Cloud CMDB vs Traditional CMDB: A 2026 Comparison](https://www.joekarlsson.com/blog/cloud-cmdb-vs-traditional-cmdb-2026/)
    
    Cloud CMDB vs traditional CMDB in 2026 - Gartner says 70-80% of traditional CMDB projects fail. How agent-based scans compare to API-based discovery.
    
-   Oct 3, 2025 | 16 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Five Tips for Getting Maximum Value from a Cloud Asset Inventory](https://www.joekarlsson.com/blog/five-tips-maximum-value-cloud-asset-inventory/)
    
    Five ways to get more value from a cloud asset inventory: tie it to business outcomes, involve stakeholders, start with high-impact use cases.
    
-   Oct 3, 2025 | 16 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How to Design a Cloud Asset Inventory for AWS](https://www.joekarlsson.com/blog/how-to-design-cloud-asset-inventory-aws/)
    
    Five design principles for a cloud asset inventory on AWS: freshness, completeness, normalization, queryability and extensibility, plus maturity stages.
    
-   Oct 3, 2025 | 12 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Introduction to CloudQuery for AWS](https://www.joekarlsson.com/blog/introduction-to-cloudquery-aws/)
    
    An introduction to CloudQuery for AWS. How it syncs your AWS resources into unified SQL tables you can use for security monitoring, cost and compliance.
    
-   Oct 3, 2025 | 18 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Why and When Do You Need a Cloud Asset Inventory?](https://www.joekarlsson.com/blog/what-is-cloud-asset-inventory/)
    
    Why and when you need a cloud asset inventory for AWS, and how it helps with security governance, cost optimization and day-to-day operations.
    
-   Sep 17, 2025 | 23 min read | AI | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Building Secure AI-Powered Cloud Security: From Data Pipeline to Risk Detection](https://www.joekarlsson.com/blog/building-secure-ai-powered-cloud-security-data-pipeline-risk-detection/)
    
    Learn how AI-powered cloud security reduces investigation time by 55% across AWS, GCP, Azure with our open-source demo.
    
-   Sep 15, 2025 | 9 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [CloudQuery Performance Benchmark Analysis: 581 GB/Hour Throughput and the Reality of Cloud API Constraints](https://www.joekarlsson.com/blog/cloudquery-performance-benchmark-analysis-581gb-throughput-reality-cloud-api-constraints/)
    
    CloudQuery performance benchmark - 581 GB/hour on consumer hardware with local data, and how cloud provider API rate limits change the real numbers.
    
-   Sep 1, 2025 | 2 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Introducing CloudQuery Insights: Cloud Intelligence That Connects the Dots](https://www.joekarlsson.com/blog/introducing-cloudquery-insights/)
    
    CloudQuery Insights monitors your complete asset inventory and surfaces interconnected signals across security, cost, policy, and audit data automatically.
    
-   Sep 1, 2025 | 6 min read | AI | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Production AI Data Pipeline Architectures](https://www.joekarlsson.com/blog/production-ai-data-pipeline-architectures/)
    
    AI data pipeline architectures with CloudQuery, moving data from 50+ sources into vector databases and training pipelines on your own infrastructure.
    
-   Aug 27, 2025 | 7 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [We benchmarked our ETL tool and synced 1 million rows in 2 seconds on a MacBook](https://www.joekarlsson.com/blog/etl-benchmark-1-million-rows-2-seconds-macbook/)
    
    We benchmarked our ETL tool and synced 1 million rows in 2 seconds on a MacBook, 68% faster than enterprise platforms. Methodology and code included.
    
-   Aug 21, 2025 | 6 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [What is an AWS Cloud Asset Inventory?](https://www.joekarlsson.com/blog/what-is-an-aws-cloud-asset-inventory/)
    
    What is AWS Cloud Asset Inventory? Learn why it's essential for security and cost optimization, and compare AWS Config, Systems Manager, and CloudQuery.
    
-   Jul 29, 2025 | 6 min read | AI | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How We Made Our IDEs Data-Aware with a Go MCP Server](https://www.joekarlsson.com/blog/how-we-made-our-ides-data-aware-with-a-go-mcp-server/)
    
    How we built a Go-based MCP server to make AI Assistants data-aware, bridging code and database, which ended up transforming the way we code.
    
-   Jul 29, 2025 | 9 min read | AI | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [We Built an MCP Server and These Are the Gotchas Nobody Talks About](https://www.joekarlsson.com/blog/mcp-server-gotchas-we-learned-the-hard-way/)
    
    What we learned building an MCP server for cloud infrastructure data, from tool descriptions and naming to context limits, and how we fixed each problem.
    
-   Jul 1, 2025 | 5 min read | AI | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [AI for Analyzing Your Cloud Asset Inventory](https://www.joekarlsson.com/blog/ai-for-analyzing-your-cloud-asset-inventory/)
    
    CloudQuery's MCP server lets AI agents query your cloud asset inventory in plain English, with dashboards and reports built from AWS, GCP and Azure data.
    
-   Jun 18, 2025 | 10 min read | Homelab | One of my 10 most-read posts [I Replaced Alexa with a Dumber Voice Assistant (But at Least It’s Private)](https://www.joekarlsson.com/blog/i-replaced-my-smart-home-with-a-dumber-home-but-at-least-its-private/)
    
    After five years of Home Assistant automations, I replaced Amazon Alexa with Home Assistant Voice Preview Edition for privacy. Here's where it falls short.
    
-   Jun 8, 2025 | 14 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How to Make Your Internal Developer Portal Actually Useful](https://www.joekarlsson.com/blog/how-to-make-your-internal-developer-portal-actually-useful/)
    
    An internal developer portal is only as useful as its asset inventory. Backstage case studies from Spotify, Toyota and finance teams, with ROI numbers.
    
-   Jun 3, 2025 | 8 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Cloud Centers of Excellence (Part 1): Building Effective Cloud Governance Through Strategic Organization](https://www.joekarlsson.com/blog/cloud-centers-of-excellence-part-1-building-effective-cloud-governance/)
    
    How to build a Cloud Center of Excellence (CCOE) for cloud governance - structure, roles and strategy, in part 1 of a 5-part implementation series.
    
-   Jun 3, 2025 | 7 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Cloud Centers of Excellence (Part 2): Governance, Security, and Compliance in CCOEs](https://www.joekarlsson.com/blog/cloud-centers-of-excellence-part-2-governance-security-compliance/)
    
    Who owns cloud policy? How real Cloud Centers of Excellence handle governance, enforce security without slowing teams down, and keep regulators happy.
    
-   Jun 3, 2025 | 8 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Cloud Centers of Excellence (Part 3): FinOps, Cost Management, and Real-World Case Studies](https://www.joekarlsson.com/blog/cloud-centers-of-excellence-part-3-finops-cost-management-case-studies/)
    
    How mature Cloud Centers of Excellence use FinOps to track cloud costs, cut waste by up to 40% and share accountability, with case studies from banks.
    
-   Jun 3, 2025 | 20 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Cloud Centers of Excellence (Part 4): Implementation Best Practices and Common Pitfalls](https://www.joekarlsson.com/blog/cloud-centers-of-excellence-part-4-implementation-best-practices-pitfalls/)
    
    Cloud Center of Excellence implementation, part 4 - what to build first, what to skip, the ivory tower trap and keeping your CoE alive past year one.
    
-   Jun 3, 2025 | 9 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Cloud Centers of Excellence (Part 5): The Future of CCOEs and Getting Started](https://www.joekarlsson.com/blog/cloud-centers-of-excellence-part-5-future-of-ccoes-getting-started/)
    
    Cloud Centers of Excellence aren't going away, they're changing. Part 5 covers where CCOEs are headed, what to build next and how to get started.
    
-   May 15, 2025 | 15 min read | Cloud, Web Dev | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Why (and How) We Built Our Own Full Text Search Engine with ClickHouse](https://www.joekarlsson.com/blog/why-and-how-we-built-our-own-full-text-search-engine-with-clickhouse/)
    
    How we built a full-text search for CloudQuery using ClickHouse, achieving 10x faster queries without dedicated search engines.
    
-   May 14, 2025 | 6 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How We Accidentally Invented a Cloud Search Language](https://www.joekarlsson.com/blog/how-we-accidentally-invented-a-cloud-search-language/)
    
    How we turned our search bar into a domain-specific language using Peggy instead of regex, solving complex parsing challenges for cloud resource queries.
    
-   May 1, 2025 | 8 min read | Cloud, Web Dev | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How We Handle Billion-Row ClickHouse Inserts With UUID Range Bucketing](https://www.joekarlsson.com/blog/how-we-handle-billion-row-clickhouse-inserts-with-uuid-range-bucketing/)
    
    How we stopped ClickHouse memory blowups on billion-row inserts of cloud config data with an Insert-Splitter that buckets rows by UUID range.
    
-   May 1, 2025 | 3 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Integrate AbuseIPDB Threat Intelligence with CloudQuery](https://www.joekarlsson.com/blog/integrate-abuseipdb-with-cloudquery/)
    
    Check your cloud public IPs against AbuseIPDB abuse scores using CloudQuery inventory data and SQL joins. Includes working query examples.
    
-   May 1, 2025 | 14 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Kubernetes Asset Tracking: Why 70% of Enterprises are Struggling (And How to Fix It)](https://www.joekarlsson.com/blog/kubernetes-asset-tracking-at-scale/)
    
    Track Kubernetes assets across clouds with a central configuration store, using CloudQuery to query them with SQL for security and compliance.
    
-   May 1, 2025 | 3 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How to Query ipinfo.io Data with CloudQuery](https://www.joekarlsson.com/blog/query-ipinfo-with-cloudquery/)
    
    Enrich your CloudQuery cloud asset inventory with ipinfo.io geolocation, ASN, and privacy detection data using SQL joins. Includes working query examples.
    
-   Apr 18, 2025 | 3 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Visualize & Govern Your Cloud Stack with CloudQuery Reports](https://www.joekarlsson.com/blog/visualize-govern-cloud-stack-cloudquery-reports/)
    
    CloudQuery Reports delivers actionable insights for multi-cloud security, compliance, and cost optimization with ready-to-use dashboards and SQL queries.
    
-   Apr 8, 2025 | 18 min read | Cloud, Web Dev | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Six Months with ClickHouse at CloudQuery: The Good, The Bad, and the Unexpected](https://www.joekarlsson.com/blog/six-months-with-clickhouse-at-cloudquery/)
    
    What six months of ClickHouse as CloudQuery's default backend taught us about performance, JOIN limits, sorting keys, materialized views and benchmarking.
    
-   Mar 20, 2025 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [What We Learned Querying Cloud Infra for Expired Dependencies](https://www.joekarlsson.com/blog/what-we-learned-querying-cloud-infra-for-expired-dependencies/)
    
    Learn how to easily track and fix end-of-life cloud services across AWS, Azure, and GCP with CloudQuery new End-of-Life (EOL) integration.
    
-   Mar 13, 2025 | 4 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [The Best Way to Keep Your Cloud Inventory Up to Date](https://www.joekarlsson.com/blog/best-way-keep-cloud-inventory-up-to-date/)
    
    How to keep your cloud inventory up to date across AWS, GCP, Azure and Kubernetes with CloudQuery pipelines that sync and normalize the data.
    
-   Mar 12, 2025 | 10 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Building an AWS Cloud Asset Inventory](https://www.joekarlsson.com/blog/building-cloud-asset-inventory-with-aws/)
    
    How to build an AWS cloud asset inventory with CloudQuery, PostgreSQL and Grafana, using dbt to shape the data for security and compliance views.
    
-   Mar 12, 2025 | 4 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Stop Wasting Time on Cloud UIs and Scripts, and Query Your Cloud Like a Database](https://www.joekarlsson.com/blog/query-cloud-like-database-stop-wasting-time/)
    
    CloudQuery SQL Console lets you query your cloud like a database. Skip the endless dashboards and brittle scripts and get answers with SQL.
    
-   Mar 11, 2025 | 5 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How to Eliminate Blind Spots in Your Cloud Environment](https://www.joekarlsson.com/blog/eliminate-blind-spots-cloud-environment/)
    
    Stop guessing what in your multi-cloud environment. Use CloudQuery asset inventory to see everything, secure everything, and save money doing it.
    
-   Dec 19, 2024 | 3 min read | AI | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [AI, Without Exposing Your Data](https://www.joekarlsson.com/blog/ai-without-exposing-your-data/)
    
    Learn how to build AI-powered applications while keeping your sensitive data secure and private on your own infrastructure.
    
-   Nov 25, 2024 | 7 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How to Build a Cloud Asset Inventory for Azure](https://www.joekarlsson.com/blog/how-to-build-a-cloud-asset-inventory-for-azure/)
    
    Build an Azure cloud asset inventory with CloudQuery and PostgreSQL. Covers setup, dbt transformations, and visualizing assets for security and compliance.
    
-   Nov 21, 2024 | 8 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Getting Started with Cloud Asset Inventory](https://www.joekarlsson.com/blog/getting-started-with-cloud-asset-inventory/)
    
    How to build and maintain a cloud asset inventory: set the scope, pick tools, automate collection, audit regularly, and track new cloud services.
    
-   Nov 5, 2024 | 3 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [What is SOC2 Compliance?](https://www.joekarlsson.com/blog/soc2/)
    
    SOC2 compliance is the AICPA audit standard for how a company protects customer data across security, availability, integrity, confidentiality and privacy.
    
-   Nov 1, 2024 | 1 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Tempus: Multi-Cloud Asset Inventory Across 80+ AWS Accounts and 1000+ GCP Projects](https://www.joekarlsson.com/blog/tempus-multi-cloud-asset-inventory/)
    
    How Tempus runs nightly CloudQuery syncs across 80+ AWS accounts and 1000+ GCP projects, built on GCP with Terraform, GKE, Cloud SQL and Grafana.
    
-   Oct 25, 2024 | 7 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Building a Multi-Cloud Asset Inventory for Google Cloud Platform (GCP) and AWS with CloudQuery](https://www.joekarlsson.com/blog/complete-guide-building-multi-cloud-asset-inventory/)
    
    Build a multi-cloud asset inventory for AWS and GCP with CloudQuery. Sync both clouds into PostgreSQL and query every cloud asset with SQL.
    
-   Aug 29, 2024 | 11 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [How to Build a Multi-Cloud Asset Inventory](https://www.joekarlsson.com/blog/how-to-build-a-multi-cloud-asset-inventory/)
    
    A step-by-step guide to a multi-cloud asset inventory for AWS, GCP and Azure: collect, transform and store cloud data for security, compliance and cost.
    
-   Jun 13, 2024 | 9 min read | Cloud | [Written for CloudQuery](https://www.joekarlsson.com/blog/written-for/cloudquery/) [Step-by-Step Guide to Building a Cloud Asset Inventory for GCP](https://www.joekarlsson.com/blog/building-cloud-asset-inventory-with-gcp/)
    
    How to build a GCP cloud asset inventory with CloudQuery, PostgreSQL and dbt - setup, dbt models to transform the data, and querying your resources.
    
-   Apr 5, 2024 | 8 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [Data Warehouses Are Terrible Application Backends](https://www.joekarlsson.com/blog/data-warehouses-are-terrible-application-backends/)
    
    Data warehouses can't handle the freshness, latency and concurrency user-facing apps need. Why real-time data platforms make better application backends.
    
-   Apr 5, 2024 | 7 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [How to Build Applications over Streaming Data the Right Way](https://www.joekarlsson.com/blog/how-to-build-applications-over-streaming-data-the-right-way/)
    
    In modern data ecosystems, streaming data flows like traffic on a busy highway. Each packet of data has a specific destination,...
    
-   Apr 5, 2024 | 5 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [The Engineer’s Guide to Enriching Streams and Dimensions](https://www.joekarlsson.com/blog/the-engineers-guide-to-enriching-streams-and-dimensions/)
    
    How to enrich real-time Kafka streams with Snowflake dimension tables, with use cases for fraud detection, e-commerce personalization and log analytics.
    
-   Apr 5, 2024 | 7 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [Why ClickHouse Should Be Your Next Database](https://www.joekarlsson.com/blog/why-clickhouse-should-be-your-next-database/)
    
    “Today, we’re jumping into databases. Another database to learn? But before you sprint for the hills, allow me to introduce you to ClickHouse.”
    
-   Mar 30, 2024 | 24 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [A step-by-step guide to build a real-time dashboard](https://www.joekarlsson.com/blog/a-step-by-step-guide-to-build-a-real-time-dashboard/)
    
    A step-by-step guide to build a real-time dashboard with Tinybird, Tremor and Next.js, from a mock data stream to SQL metrics published as APIs.
    
-   Mar 30, 2024 | 14 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [How to build a real-time fraud detection system](https://www.joekarlsson.com/blog/how-to-build-a-real-time-fraud-detection-system/)
    
    How to build a real-time fraud detection system: ingest transaction streams, flag fraud with SQL, and publish the results as APIs with Tinybird and Retool.
    
-   Mar 30, 2024 | 13 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [Modern data management with real-time Change Data Capture](https://www.joekarlsson.com/blog/modern-data-management-with-real-time-change-data-capture/)
    
    Real-time Change Data Capture (CDC) tracks database changes as they happen and sends them downstream. Why it matters for event-driven data architectures.
    
-   Mar 30, 2024 | 14 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [Real-time Databases: What developers need to know](https://www.joekarlsson.com/blog/real-time-databases-what-developers-need-to-know/)
    
    What developers need to know about real-time databases, with pros and cons of MongoDB, PostgreSQL, ClickHouse, Tinybird, Snowflake, Pinot and Druid.
    
-   Mar 30, 2024 | 18 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [Using Bloom filter indexes for real-time text search in ClickHouse](https://www.joekarlsson.com/blog/using-bloom-filter-indexes-for-real-time-text-search-in-clickhouse/)
    
    How Bloom filter indexes speed up real-time text search in ClickHouse, covering tokenization vs n-grams, ngrambf\_v1 settings and benchmark results.
    
-   Mar 30, 2024 | 12 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [What it takes to build a real-time recommendation system](https://www.joekarlsson.com/blog/what-it-takes-to-build-a-real-time-recommendation-system/)
    
    What goes into a real-time recommendation system: content-based and collaborative filtering, data storage, and starting with SQL before reaching for ML.
    
-   Mar 29, 2024 | 14 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [Event sourcing with Kafka: A practical example](https://www.joekarlsson.com/blog/event-sourcing-with-kafka-a-practical-example/)
    
    Event sourcing with Kafka through a banking example: calculate each customer's balance from account events with Kafka topics and Tinybird snapshots.
    
-   Mar 29, 2024 | 9 min read | Web Dev | [Written for Tinybird](https://www.joekarlsson.com/blog/written-for/tinybird/) [How to query Google Sheets with SQL in real time](https://www.joekarlsson.com/blog/how-to-query-google-sheets-with-sql-in-real-time/)
    
    How to query even large Google Sheets with SQL in real time using Tinybird, then publish the metrics as secure APIs. The demo code is on GitHub.
    
-   Jan 17, 2024 | 4 min read | Homelab | One of my 10 most-read posts [Adding Custom Domain Names on Your Internal Network Using Nginx Proxy Manager and Pi-Hole](https://www.joekarlsson.com/blog/adding-custom-domain-names-on-your-internal-network-using-nginx-proxy-manager-and-pi-hole/)
    
    How I set up custom domain names on my internal network with Pi-Hole for DNS and Nginx Proxy Manager, plus what works for SSL on local-only domains.
    
-   Sep 27, 2023 | 18 min read | Homelab | One of my 10 most-read posts [How to get started building a Homelab server in 2027](https://www.joekarlsson.com/blog/how-to-get-started-building-a-homelab-server/)
    
    A beginner's homelab setup: pick a used office PC or mini PC, install Proxmox for free, and run your first four services, with 2027 prices and power costs.
    
-   Feb 27, 2023 | 3 min read | Homelab [I turned a used postcard rack into a 3D-printed planter tower](https://www.joekarlsson.com/blog/from-digital-design-to-real-world-object-creating-a-3d-printed-postcard-planter-rack/)
    
    I bought a wire postcard rack secondhand and designed 3D-printed pots that hang in its pockets and drain into each other. Here it is three-plus years later.
    
-   Jun 22, 2022 | 5 min read | Web Dev [Databases and DevOps: How to Use SingleStore With GitHub Actions](https://www.joekarlsson.com/blog/databases-and-devops-how-to-usesinglestore-with-github-actions/)
    
    How to bring databases into DevOps: schema in source control, production-like testing, monitoring, and a demo running SingleStore in GitHub Actions.
    
-   Jun 22, 2022 | 7 min read | Web Dev | [Written for SingleStore](https://www.joekarlsson.com/blog/written-for/singlestore/) [How to Use SingleStore as a Key-Value Store](https://www.joekarlsson.com/blog/how-to-use-singlestore-as-a-key-value-store/)
    
    How to use SingleStore as a key-value store with plain SQL, so you get fast key-value lookups without running a separate database just for that.
    
-   Dec 29, 2021 | 7 min read | Web Dev [Four Questions You Need To Ask When Choosing a Database](https://www.joekarlsson.com/blog/four-questions-you-need-to-ask-when-choosing-a-database/)
    
    Four questions to ask when choosing a database: does it solve your problem, does it fit your tech stack, is it easy to learn, and what will it cost?
    
-   Nov 4, 2021 | 6 min read | Web Dev | [Written for SingleStore](https://www.joekarlsson.com/blog/written-for/singlestore/) [Database Sharding vs. Partitioning: What’s the Difference?](https://www.joekarlsson.com/blog/database-sharding-vs-partitioning-whats-the-difference/)
    
    The difference between database sharding and partitioning, when to use each, and when to combine them for data-intensive applications.
    
-   Nov 4, 2021 | 7 min read | Web Dev | [Written for SingleStore](https://www.joekarlsson.com/blog/written-for/singlestore/) [How to Add Machine Learning Predictions with SingleStore and MindsDB](https://www.joekarlsson.com/blog/how-to-add-machine-learning-predictions-with-singlestore-and-mindsdb/)
    
    Have you ever needed to set a machine learning model on your data before?
    
-   Nov 4, 2021 | 7 min read | Web Dev | [Written for SingleStore](https://www.joekarlsson.com/blog/written-for/singlestore/) [How to Get Started with SingleStore](https://www.joekarlsson.com/blog/how-to-get-started-with-singlestore/)
    
    Are you looking for the fastest possible way to get a new SingleStore Cluster up and running while testing out sample datasets to experiment with and use?
    
-   Nov 4, 2021 | 6 min read | Web Dev | [Written for SingleStore](https://www.joekarlsson.com/blog/written-for/singlestore/) [How to Use SingleStore and Node.js](https://www.joekarlsson.com/blog/how-to-use-singlestore-and-node-js/)
    
    Do you need to get a basic SingleStore application setup quickly using Node.js?
    
-   Jun 30, 2021 | 7 min read | Web Dev | [Written for MongoDB](https://www.joekarlsson.com/blog/written-for/mongodb/) [How to Manage MongoDB Data at Scale](https://www.joekarlsson.com/blog/how-to-manage-mongodb-data-at-scale/)
    
    How to manage MongoDB data at scale with Atlas Online Archive, moving aging data like IoT readings to cheaper storage while you can still query it.
    
-   Jun 30, 2021 | 8 min read | Web Dev | [Written for MongoDB](https://www.joekarlsson.com/blog/written-for/mongodb/) [How to Query from Multiple MongoDB Databases](https://www.joekarlsson.com/blog/how-to-query-from-multiple-mongodb-databases/)
    
    How to query from multiple MongoDB databases, clusters and even AWS S3 buckets at once using federated queries on MongoDB Atlas Data Lake.
    
-   Jun 30, 2021 | 3 min read | Web Dev | [Written for MongoDB](https://www.joekarlsson.com/blog/written-for/mongodb/) [How to Seed a MongoDB Database with Fake Data](https://www.joekarlsson.com/blog/how-to-seed-a-mongodb-database-with-fake-data/)
    
    How to seed a MongoDB database with fake data using a Node.js seed script and faker.js, for demos, lookup values and proofs of concept.
    
-   Jun 30, 2021 | 5 min read | Web Dev | [Written for MongoDB](https://www.joekarlsson.com/blog/written-for/mongodb/) [How to Use Custom Archival Rules and Partitioning on MongoDB Atlas Online Archive](https://www.joekarlsson.com/blog/how-to-use-custom-archival-rules-and-partitioning-on-mongodb-atlas-online-archive/)
    
    How to set up custom archival rules on MongoDB Atlas Online Archive and partition your archived data to speed up queries against it.
    
-   May 28, 2021 | 14 min read | Web Dev | [Written for MongoDB](https://www.joekarlsson.com/blog/written-for/mongodb/) [How to use MongoDB Client-Side Field Level Encryption (CSFLE) with Node.js](https://www.joekarlsson.com/blog/how-to-use-mongodb-client-side-field-level-encryption-csfle-with-node-js/)
    
    How to use MongoDB Client-Side Field Level Encryption (CSFLE) with Node.js to encrypt sensitive fields like credit card and social security numbers.
    
-   May 28, 2021 | 8 min read | Web Dev | [Written for MongoDB](https://www.joekarlsson.com/blog/written-for/mongodb/) [MongoDB Aggregation Pipeline Queries vs SQL Queries](https://www.joekarlsson.com/blog/mongodb-aggregation-pipeline-queries-vs-sql-queries/)
    
    MongoDB aggregation pipeline queries vs SQL queries, side by side. I came to MongoDB from SQL, so I map pipeline stages to SQL clauses you already know.
    
-   Nov 3, 2020 | 11 min read | Web Dev [How To Use The MongoDB Visual Studio Code Plugin](https://www.joekarlsson.com/blog/how-to-use-the-mongodb-visual-studio-code-plugin/)
    
    How to use the MongoDB Visual Studio Code plugin to connect to Atlas, browse your collections and prototype queries in Playgrounds inside your editor.
    
-   Nov 3, 2020 | 14 min read | Web Dev | [Written for MongoDB](https://www.joekarlsson.com/blog/written-for/mongodb/) [Linked Lists and MongoDB: A Gentle Introduction](https://www.joekarlsson.com/blog/linked-lists-and-mongodb-a-gentle-introduction/)
    
    New to data structures? Learn how linked lists work, how they differ from arrays and when to use one, with a MongoDB twist in Node.js.
    
-   May 13, 2020 | 2 min read | Career [How to Pass A Coding Interview](https://www.joekarlsson.com/blog/how-to-pass-coding-interview/)
    
    Developers ask me how to pass a coding interview more than anything else, so I wrote down what I think it takes to walk in well prepared.
    
-   Jun 11, 2019 | 2 min read | Life [My Top 50 All-Time Favorite Records](https://www.joekarlsson.com/blog/my-top-50-records/)
    
    My top 50 all-time favorite records, the ones I play most or that hit me hardest, from Loveless to Kind of Blue. I redo the list every couple of years.
    
-   Apr 2, 2019 | 7 min read | Web Dev [How to Build A Spotify Player with React in 15 Minutes](https://www.joekarlsson.com/blog/how-to-build-a-spotify-player-with-react-in-15-minutes/)
    
    Build a Spotify player in React in 15 minutes. Register an app, authenticate a user, and show the track they're playing with the Spotify Web API.
    
-   Jan 8, 2019 | 5 min read | Career [The Tech Talks That Have Had The Biggest Impact On My Career](https://www.joekarlsson.com/blog/the-tech-talks-that-have-had-the-biggest-impact-on-my-career/)
    
    The tech talks that changed how I think about programming, most of them language-agnostic, starting with The Myth of the Genius Programmer.
    
-   Nov 14, 2018 | 6 min read | Career [An Engineers Guide to Knowing if You Are Done With a Project](https://www.joekarlsson.com/blog/an-engineers-guide-to-knowing-if-you-are-done-with-a-project/)
    
    An engineer's checklist for knowing when a project is done - the list I give my team, from working code and tests to QA, accessibility and performance.
    
-   Jan 26, 2018 | 9 min read | Career [So, You Want To Learn How To Code? Here’s What You Need To Know.](https://www.joekarlsson.com/blog/my-top-resources-for-learning-how-to-code/)
    
    Want to learn how to code? These are my favorite programming books, talks, podcasts, newsletters and websites, plus general tips for getting started.
    
-   Jan 30, 2017 | 20 min read | Career [I Ran My First Hackathon, and So Can You!](https://www.joekarlsson.com/blog/i-ran-my-first-hackathon-and-so-can-you/)
    
    Lessons I learned planning and running my first hackathon, the Stupid Shit and Terrible Ideas Hackathon in Honolulu, and how you can run one too.
    
-   Jul 23, 2016 | 7 min read | Web Dev [Complete Guide To Node Client-Server Communication](https://www.joekarlsson.com/blog/complete-guide-node-client-server-communication/)
    
    Node client-server communication based on Ilya Grigorik's High-Performance Browser Networking, with examples of XHR, SSE, WebSockets and HTTP/2.
    
-   Dec 19, 2015 | 5 min read | Web Dev [Bechdel Test Script Parser - How It Works](https://www.joekarlsson.com/blog/bechdel-test-script-parser-works/)
    
    How the Bechdel Test Script Parser works - the digital humanities tool my sister Laurel and I built to check whether film scripts pass the Bechdel Test.
    
-   May 16, 2015 | 3 min read | Web Dev [How to pixelate images with HTML5 and JavaScript](https://www.joekarlsson.com/blog/how-to-pixelate-images-with-html5-and-javascript/)
    
    How to pixelate images with HTML5 canvas and JavaScript, step by step through the code I wrote for Pixelate.js, a spin-off of my Instagram mosaic app.
