Note to Self
Posts helping me remember how to do something I don't do often enough to remember. Or, that have enough steps in a particular order that I need to remember. Hopefully, they may help you, too.
February 4, 2024
How to do an SQL Delete based on a Join
I'm mostly used to simple deletes using where clauses, but I know a DBA who prefers to use joins. To get more familiar, I've been doing simple stuff like that. The syntax between MS-SQL and MySQL is...
ReadFebruary 1, 2024
A Simple PHP Benchmarking function
I recently needed to find where some performance issues were and didn't have the time to download and figure out any real-life tools, but this basic system helped. I could just sprinkle...
ReadJanuary 31, 2024
MySQL - Find What Tables Have a Column Name
How to find out what tables in a MySQL database have a specific column, by name.
ReadJanuary 17, 2024
How to Generate a Laravel API Token using Artisan Tinker
Generate a basic Laravel users.api_token:
ReadDecember 23, 2023
How to disable warning that MacOSX switched to zsh
To avoid this message: Add this to ~/.bashrc: From Stackoverflow
ReadJune 18, 2023
Reminder about PHP TS vs NTS
From PHP Documentation: Thread Safety means that binary can work in a multithreaded webserver context, such as Apache 2 on Windows. Thread Safety works by creating a local storage copy in each...
ReadMay 7, 2023
Useful Git Snippets
Bring back a deleted file, after it's been committed and pushed: git checkout <deletion commit hash>~1 -- <filename>
Pull without going thru all the SSL self-signed BS but...
March 17, 2023
Find, based on Time
GAME. CHANGER. newerBt is “birth time” where newerCt is “change time” which doesn’t find things being copied around. WOOHOO!!! (newermt!)...
ReadDecember 8, 2022
Basic but Useful SSL Expiration Date checker
At an old job, every now and then we'd have a fire drill because, despite it being a large, capable organization, no one seems to track when an SSL cert expires. So, I created this little script to...
ReadFebruary 27, 2022
Update Internet Information Server (IIS) Fast CGI Timeout
When debugging on Windows using Internet Information Server, if I took too long to step through what I was debugging, it would time out and I'd have to start over. Talk about anxiety! Lol. This...
ReadJanuary 2, 2022
Quick and Dirty API endpoint testing using devtools console.
Sometimes I'd be on a client network, without access to tools like Postman. But, I'd want to test and endpoint to see what's what. So, a little hackery with the devtools console and I'm good:...
ReadAugust 17, 2021
Fix Git/Apache/Curl Self-Signed Cert issue
This is mainly a reminder to myself about how to do this, and the link to Matt Ferderer's website with the real instructions: Real Instructions Notes: Apache curl:...
ReadFebruary 8, 2021
Install an SSL Cert in Apache
openssl pkcs12 -in domain.com.pfx -out domain.com.pem -nodes openssl rsa -in domain.com.pem -out domain.com.cert.key openssl x509 -in domain.com.pem -out domain.com.cert.crt Assuming copy those...
ReadFebruary 8, 2021
SQL Snippets to Remember
Row Number Over: Find Duplicates: To determine if there is a duplicate:
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...
December 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...
Read