Upgrading a Heroku PostgreSQL database with pg:copy
2024-12-06
Figured this out in https://github.com/simonw/simonwillisonblog/issues/132 - I was running PostgreSQL 9.x and I wanted 11.x in order to use the new...
367 words
|
2 minutes
Complete Wazuh Deployment Guide on AWS ECS Fargate - Production Ready
2024-12-05
A complete production-ready deployment guide for Wazuh SIEM on AWS ECS Fargate with full configurations, SSL/TLS setup, load balancing, service discovery, and troubleshooting steps.
5222 words
|
26 minutes
Running a scheduled function on Val Town to import Atom feeds into Datasette Cloud
2024-12-04
[Val Town](https://www.val.town/) is a neat service for hosting short server-side JavaScript programs online - reminiscent of a combination of Glit...
418 words
|
2 minutes
Only run GitHub Action on push to master / main
2024-12-04
Spotted in [this Cloud Run example](https://github.com/GoogleCloudPlatform/github-actions/blob/20c294aabd5331f9f7b8a26e6075d41c31ce5e0d/example-wor...
118 words
|
1 minute
Wildcard DNS and SSL on Fly
2024-12-04
[Fly](https://fly.io/) makes it surprisingly easy to configure wildcard DNS, such that `anything.your-new-domain.dev` is served by a single Fly app...
552 words
|
3 minutes
Running OpenAI's large context models using llm
2024-12-03
OpenAI [announced new models](https://openai.com/blog/function-calling-and-other-api-updates) today. Of particular interest to me is the new `gpt-3...
560 words
|
3 minutes
Complete Guide to AWS IAM Roles: Secure Access Management
2024-12-03
Complete guide to AWS IAM Roles - understanding trust policies, permissions, and common use cases for secure AWS resource access management.
409 words
|
2 minutes
Guessing Amazon image URLs using GitHub Copilot
2024-12-02
I was experimenting with the new [Readwise export API](https://readwise.io/api_deets#export) and it gave me back the following JSON:
248 words
|
1 minute
Expanding ChatGPT Code Interpreter with Python packages, Deno and Lua
2024-12-02
The ChatGPT Code Interpreter alpha remains incredibly interesting. I wrote about how I was using it [for Python and SQLite benchmarking](https://si...
1221 words
|
6 minutes
Wider tooltip areas for Observable Plot
2024-11-26
In [this Observable notebook](https://observablehq.com/@simonw/mastodon-users-and-statuses-over-time) I'm plotting a line on a chart, but I want to...
255 words
|
1 minute
Testing against Python 3.11 preview using GitHub Actions
2024-11-24
I decided to run my CI tests against the Python 3.11 preview, to avoid the problem I had when Python 3.10 came out with [a bug that affected Datase...
133 words
|
1 minute
Integrating HashiCorp Vault with CoreDNS: Secure DNS and Secrets Management
2024-11-23
A comprehensive guide to integrating HashiCorp Vault with CoreDNS for secure DNS resolution, dynamic secrets management, and certificate automation in modern infrastructure.
4366 words
|
22 minutes
Building a DNS Sinkhole: Complete Implementation Guide for Network Security
2024-11-23
A comprehensive guide to implementing a DNS sinkhole for blocking malicious domains, advertisements, and tracking at the network level using various technologies and approaches.
4271 words
|
21 minutes
Creating a Comprehensive API Inventory: Discovery, Documentation, and Management
2024-11-23
A complete guide to building an automated API inventory system that discovers, documents, and manages all APIs across your organization's infrastructure.
4371 words
|
22 minutes
Building a Comprehensive API Monitoring Script: Complete Implementation Guide
2024-11-23
A complete guide to building a robust API monitoring script with health checks, performance metrics, alerting, and comprehensive logging capabilities.
2563 words
|
13 minutes
Securing SSH with Google Authenticator: Two-Factor Authentication Setup
2024-11-23
A comprehensive guide to implementing two-factor authentication for SSH using Google Authenticator, enhancing server security with time-based one-time passwords (TOTP).
1863 words
|
9 minutes
Mastering Container Management with Podman Quadlet: Complete Guide
2024-11-23
A comprehensive guide to using Podman Quadlet for container management, enabling systemd-native container deployment with automatic updates, dependencies, and lifecycle management.
1402 words
|
7 minutes
Managing Multiple GitHub Accounts: SSH Keys and Git Configuration
2024-11-23
A comprehensive guide to managing multiple GitHub accounts on a single machine using SSH keys, Git configuration, and URL rewriting for seamless account switching.
1554 words
|
8 minutes
Complete CoreDNS and StepCA Setup on CoreOS with Quadlet
2024-11-23
A comprehensive, production-ready guide for deploying CoreDNS and Smallstep CA on Fedora CoreOS using Podman Quadlet, providing secure DNS and certificate management without Kubernetes.
1264 words
|
6 minutes
CoreDNS and StepCA with Kubernetes Using Quadlet
2024-11-23
A comprehensive guide to deploying CoreDNS and Smallstep CA on Kubernetes using Podman Quadlet, providing secure DNS and certificate management for your Kubernetes infrastructure.
1424 words
|
7 minutes
Installing kubectl on Fedora CoreOS: Complete Guide
2024-11-23
A comprehensive guide to installing kubectl on Fedora CoreOS (FCOS), covering both RPM-based installation and binary installation methods with best practices.
1075 words
|
5 minutes
Complete Guide to Managing CA Certificates in Podman
2024-11-23
A comprehensive guide on adding and managing Certificate Authority (CA) certificates in Podman environments, including integration with custom PKI infrastructure and automated workflows.
1216 words
|
6 minutes
Comprehensive Guide to Using Podman with Kubernetes
2024-11-23
A complete guide explaining how to use Podman as a Docker alternative with Kubernetes, including manifest generation, image management, and development workflows.
1124 words
|
6 minutes
Creating a Complete Certificate Authority Infrastructure with Shell Scripting
2024-11-23
A comprehensive shell script for creating and managing a complete Certificate Authority infrastructure including Root CA, Intermediate CA, and server certificates with automated certificate chain generation.
1378 words
|
7 minutes