Latest Posts
SQL Join Strategies and Performance in PostgreSQL
When you write a SQL query that joins two or more tables, PostgreSQL has to decide how to execute that join. The strategy it chooses can have a big impact on performance. Understanding the different join strategies can help you write more efficient queries and optimize your database.
Posting to Bluesky from Zapier (for free)
Zapier recently added a Bluesky app but unfortunately it is designated as Premium. This means that you need to pay for a Zapier subscription to use it. However, you can still post to Bluesky using the Code by Zapier app, which is free to use.
SvelteKit with Drizzle and Cloudflare D1
I recently started a little side project for my wife and decided to use SvelteKit to build it and Cloudflare to host it. Along the way I decided to use Drizzle ORM along with Cloudflare D1 to store the data. I was really happy with how everything worked but I did run into a few issues: using a local SQLite database for development and applying migrations to both dev and production environments. After some fiddling I got things working nicely and wanted to document my setup here.
Batch Deletes in Postgres
If you need to delete many, many rows in a Postgres table, issuing a single DELETE statement can be problematic for a few reasons:
Automatic installation of recommended VS Code Extensions
Recommended extensions in VS Code are a useful way to keep a development team on the same page. You can recommend extensions that perform formatting when saving files, show lint warning, and many other things that are useful when collaborating together on a codebase.
More Posts