Reading PostgreSQL Files with Go
21 Dec 2020
I thought it would be a fun learning exercise to try to parse a PostgreSQL table file with Go. I definitely learned a lot. :-)
This blog is updated more than the home page might imply, but only the most intersting stuff gets posted on the home page.
21 Dec 2020
I thought it would be a fun learning exercise to try to parse a PostgreSQL table file with Go. I definitely learned a lot. :-)
aws
13 Dec 2020
Everybody's using AWS these days. I've started keeping notes on the more intersting
bits. In particular, the aws
command-line utility is
very handy for us command-line junkies.
Here's a look at extracting secrets into AWS Fargate containers from Systems Manager / Parameter Store.
Here's a look at using SQL to query parquet files in S3 from the command-line.
26 Apr 2020
Want to know where your Linux process's command-line args and env vars live on process starup? And how to get them from an assembler program?
Details here.
25 Aug 2019
The book Hacker's Delight has a pretty neat way of counting the 1-bits in an integer. But my exploration shows that modern Intel CPUs have an instruction that do that for you, and that Go's math/bits library takes advantage of that instruction. Nonetheless, I leave notes that spell out the Hacker's Delight solution as obvoiusly as I can.
Details here.
1 Aug 2018
I've been reading parts of Katherine Cox-Buday's Concurrency in Go, and I think this incomplete list of facts about channels and select statements is useful. A full table of channel operation/state/result is on page 75; these notes are just for me and whoever else may find them useful
20 Aug 2017
I have completely re-worked my
writeup on tuning PostgreSQL for heavily-updated tables
to take into account the usefulness of autovacuum_vacuum_cost_limit
.