Posts

Another Good Reason for Open Source

#open source #simon willison

Being able to share code performed at work.

January 25, 2025

Setting up OpenWeather Report GitHub Actions

#python #openweather_report #github actions #uv #astral

Adding GitHub workflows to help with linting, testing and publishing.

January 6, 2025

Attempt to Create a Link Blog

#Simon Willison #blog #Trey Hunner

I read Simon’s post earlier this week and it helped me form my own thoughts. Initially I wasn’t going to add any posts to my website that basically would either be a copy and paste with very little to add. For example, in Trey Hunner’s newsletter (which he did expand in a longer article): The main use case I have for uv involves this scenario: I’ve written a standalone Python script that I want to be globally accessible on my machine, but it requires a third-party dependency.

December 26, 2024

Upgrade from PostgreSQL 15 to 17 on Windows using pg_upgrade

#pg_upgrade #postgresql #windows 10 #pg_dump #pg_dumpall

Overview At work I needed to upgrade from PostgreSQL from 15 to 17. The process is not that different than upgrading in Ubuntu but there were a couple of items that threw me off. Perform Backup This should be done prior to the update in case something goes wrong: CTyler@CTYLER_NB  C:\Program Files\PostgreSQL\17\bin  [08:22] ❯ & 'C:\Program Files\PostgreSQL\17\bin\pg_dumpall.exe' -p 5432 -U postgres -f D:\Backups\postgresql-ctyler_nb-20241107-1.out This was based on the documentation PostgreSQL: Documentation: 17: pg_dumpall.

November 10, 2024