Postgresql 10 to 12 Upgrade

I just finished a gnarly postgresql migration @ home for my personal stuff. Started Thursday night, was slowly chipping away at it all weekend.

Main lessons learned:

Do not try to cross-upgrade extensions. If you're upgrading postgres from e.g. 10 to 12, keep extensions (for me postgis and timescaleb) the same version.

This can be hard with strictly apt packages on one version of Ubuntu, making intermediate versions of your database that run in docker and are able to install old versions of things is nice.

It was much easier to upgrade extensions on v10 to match the installable ...


Cabin Fever Student Letters

Hi! I’m Issac. I try hard to learn new things but I’ve always been kind of a non-traditional student. I dropped out of high school and then dropped out of college.

Getting kicked out of school for two months and being told to learn by myself on the internet would have been a dream for me.

I know that schools are closing and that other in-person events like Black Girls Code are being canceled and delayed and I want to help out.

I also am dealing with my own cabin fever from a surprise work-from-home situation and my ...


Dear Jesse, Version Zero

To: My Website Visitors

Jesse and I are writing back and forth about a project he’s working on to build a screenless qwerty note-taking device.
Jesse is a very capable software hacker with some hardware tinkering behind him. If you’re following along, your mileage may vary, but feel free to write with your own questions and ideas.
You can find me below or at

To: Jesse Andrews

Dear Jesse,

You mentioned that you’re into an iterative approach. I am too! One of the things that I like to do early-on ...


Dear Jesse, What's up?

To: Jesse Andrews

You sent me a note some time time ago about wanting to build a hardware project and not quite knowing what the next steps were.

The project you listed was a note taking device with the following capabilities

  • You wanted to type with a qwerty keyboard
  • You wanted it to be able to sync to another device eventually
  • You don’t need a screen

There’s an important question from me to you: What’s your goal?

  • What do you want to learn?
    • Do you want to learn about batteries? processing logic signals?
    • Do ...


Issac Kelly