Andrew DavisLocal development setup docs should not provide optionsOptions require a choice. A choice requires knowledge and thinking.2 min read·Mar 28, 2024----
Andrew DavisAn ‘order by’ tweak for instantly worse query performanceImagine this if the query used to retrieve a listing of books for your website.2 min read·Feb 1, 2024----
Andrew DavisRestore a database backup into a Postgres Docker containerLets say you have a Postgres database running in a Docker container and you want to restore an sql database backup into it.1 min read·Feb 1, 2024----
Andrew DavisPostgres Performance CheatsheetSimple steps to improve performance in a Postgres database.2 min read·Feb 1, 2024----
Andrew DavisUsing EC2 health checks to take down your own siteA loader balancer sits in front of a pool of servers, often web servers. It receives requests and routes those requests to one of the…3 min read·Feb 1, 2024----
Andrew DavisSuper Simple Load TestingSometimes you need a quick, simple way to throw a lot of traffic at a URL. Doesn’t have to be anything fancy. You just need to hammer a URL…1 min read·Feb 1, 2024----
Andrew DavisinPixel and InkMake sense of your logs with Sumologic and Cloudwatch InsightsLogs are a crucial part of monitoring the performance of your production environment when it’s running normally and figuring out what went…5 min read·Dec 6, 2020----
Andrew DavisinPixel and InkThe worst way to get the first row from a tableThere are a lot of ways to retrieve a specific row from a table in a database. During an incident I recently discovered one of the worst.2 min read·Apr 1, 2020----
Andrew DavisinPixel and InkRate Limiting in ExpressWhile a growing audience is a wonderful thing more requests isn’t always more better. There are some API end points that should only ever…4 min read·Mar 13, 2020----