About Frank
Husband. Father. Internet Plumber. Tech Author. Amateur Photographer. Decent Cook.
Internet and efficiency expert by day, father and husband by night.
Spend my days working on complex software development, operations, and business problem consulting. Usually web based and often using Python, Django, ReactJS, PostgreSQL, and Kubernetes based infrastructure.
In the evenings, I focus on my amazing family and friends. Between the two I'm constantly busy, but never bored.
Posts
Random thoughts on tech and life.
Installing a specific version of PostgreSQL in your Dockerfile
It's common to need a specific version of PostgreSQL installed for things like pg_dump in a Python docker project (which is often based on Debian). It's not hard, but it's easy to forget the exact steps, so I wanted to walk you through how to do it step by step.
Your pytest fixtures can return containers
It's easy to have your pytest function's argument signatures explode with a bunch of fixture references. And sometimes you need things that depend on each other, both separately and together which can be hard to keep straight. I suggest using an object to contain them.
Ergonomic React Queries
Small tip on making Tanstack Query (aka react-query) a little bit easier to use.
Creating a PostgreSQL database using psycopg
Quotes around your tables got you down? Yeah me too. Creating, dropping or altering PostgreSQL objects with Python and psycopg is a bit tricky when it comes to identifiers like the names of databases, tables, and indexes.