Geeky Tidbits

When you write a SQL query that joins two or more tables, PostgreSQL has to decide how to execute that join.

Zapier recently added a Bluesky app but unfortunately it is designated as Premium.

I recently started a little side project for my wife and decided to use SvelteKit to build it and Cloudflare to host it.

If you need to delete many, many rows in a Postgres table, issuing a single DELETE statement can be problematic for a few reasons: It can take a very long time to complete It can lock rows for the duration of the delete leading to blocked queries It can c…

Recommended extensions in VS Code are a useful way to keep a development team on the same page.

This year marks 20 years since I graduated from university and entered the real world as a software developer.

In the past few days I have been working on a tool to fetch new entries from RSS and Atom feeds and send them to myself via an email.

SvelteKit is a web framework I’ve been keeping my eye on.

I have been itching to build something recently.

For the past 10 years I’ve been an Android user.