fullstack://hans.anderson
Posts about full stack web development.
June 12, 2025
Why Change to AWS Amplify?
I had been running this blog on AWS S3. You can do some weird gyrations when you set up a bucket a specific way and it will let you serve a static website really easily. I used a WP static plugin for...
ReadFebruary 3, 2025
Why You Need to Lock Read Rows Inside an SQL Transaction
This is hard for me to remember. I feel like START TRANSACTION should be enough to prevent anything going wrong while that transaction is active for my session. Whatever value I...
January 12, 2025
Wireshark
Here's some notes on Wireshark, especially filtering results. You need to set an environment variable in a terminal, AND open the browser from that terminal: Then, you need to tell Wireshark...
ReadJanuary 12, 2025
Accessing the Docker Linux Virtual Machine
Docker runs on linux natively, but Docker Desktop works on a Mac by creating a virtual machine, installing Linux, and then running on top of that. So, to do some things, like intercepting network...
ReadJanuary 11, 2025
Why You Can't Group on Column Aliases
When SQLing, I sometimes run across this -- I do
and it won't work and I wonder why. Here's why: The GROUP BY clause is processed before the SELECT. Usually, the order...
January 5, 2025
SQL Window Functions (`OVER`)
So, I found this confusing at first: OVER is how you define a window, and you can use a list of functions, window-specific and aggregate, to populate the...
January 3, 2025
SQL Deadlocks and How They Happen
We had quite a few deadlock issues with some old code at a job I had a few years ago. I feel that occasional deadlocks aren't catastrophic, though a pain, especially if you don't have retry logic in...
ReadNovember 29, 2023
Fix Links in Devtools Console
So, I'm right now working on moving hansanderson.com from a Wordpress-to-static S3 site to a Laravel Jigsaw-to-static S3 site. During this, I found that while my WP docker setup had my test lcl site...
ReadFebruary 21, 2021
Taking Screenshots of a Web Page in Every Breakpoint in Three Browsers
Part of my "beyond the full-stack" process includes sending my clients screen shots of several top-level pages at every breakpoint. Sometimes, I'll include a few more pages if there are distinct...
ReadFebruary 11, 2021
Modifying VIM emulation in Visual Studio Code to Work Better
I just started using Visual Studio Code. I’ve been using vim for a long time. I liked some of the features of VS Code, but I can’t go back to a mouse. So, of course VSC has vim emulation, but...
ReadFebruary 11, 2021
Moving Around in Visual Studio with VIM emulation mods
I just started using VS Code/Visual Studio Code. I’ve been a vim guy for years, and have tried Atom, which was pretty good. Then I started seeing all these youtube videos where people used VS Code,...
ReadDecember 23, 2020
Setting up DNS for your AWS S3 static web site
Target Audience This post is aimed at relatively capable web/devops. People like me. I’m not going to remember everything, so I’ll probably re-read this myself in a few months or a year when I...
ReadDecember 23, 2020
Setting up an AWS S3 bucket for your static web site
Target Audience This post is aimed at relatively capable web/dev ops. People like me. I’ll probably re-read this myself in a few months or a year when I forget how to go about this. “Static...
ReadDecember 23, 2020
WordPress-to-static using wget mirror functionality and AWS S3
I like using WordPress. I’ve used it, AEM, Jekyll, a version of Laravel-as-CMS (currently Jigsaw and a lot of custom built code (in the early days). I don’t like how WordPress seems to be a main...
ReadDecember 23, 2020
Note to Self - Using AWS Client’s S3 Sync
This is pretty easy to do. If you use homebrew on a mac, open a terminal and type:
brew install awscli
I’m assuming that you can to apt-get install awscli on Linux, as...