noort notes

Postgres: The cost of functions in WHERE clauses

Postgres: The cost of functions in WHERE clauses A common mistake in SQL is applying a calculation to a column inside a WHERE or JOIN clause.

PostgreSQL Batch Delete with Progress Tracking

PostgreSQL Batch Delete with Progress Tracking When deleting large amounts of data from PostgreSQL tables, batch processing prevents lock contention and provides visibility into the operation’s progress.

Removing Secrets from Git History with BFG Repo-Cleaner

Removing Secrets from Git History with BFG Repo-Cleaner When sensitive data accidentally gets committed to Git, removing it from history requires careful handling.

Filtering Docker Images by Repository with Docker CLI

Filtering Docker Images by Repository with Docker CLI When managing multiple Docker images from different registries, finding specific images quickly becomes essential.

Fixing Docker GitLab CI Errors with System Cleanup

Fixing Docker GitLab CI Errors with System Cleanup Running GitLab CI on Unraid with Docker can occasionally result in filesystem corruption errors that break your builds.

Finding Updated Records Across All PostgreSQL Tables

Finding Updated Records Across All PostgreSQL Tables When troubleshooting data changes or auditing database activity, you often need to find recently updated records across your entire schema.

Using SELECT Inside INSERT in PostgreSQL

Using SELECT Inside INSERT in PostgreSQL In SQL, you can use a SELECT statement inside an INSERT to insert data dynamically from another table.

Clearing Cached Plans in PostgreSQL

Clearing Cached Plans in PostgreSQL PostgreSQL caches execution plans for prepared statements to improve performance, but sometimes you may need to clear them manually.

Fixing Unsigned Repository Error in Docker Builds

Fixing Unsigned Repository Error in Docker Builds If you encounter the error The repository 'http://xxx yyy InRelease' is not signed.

Print Lines Above and Below a grep Match

Print Lines Above and Below a grep Match When searching for text in a file using grep, you may want to see the surrounding lines for context.

Handling Unique Constraints in Ecto with on_conflict

Handling Unique Constraints in Ecto with on_conflict When inserting data in Ecto, you may encounter unique constraint violations that clutter your logs.

INNER JOIN vs. EXISTS for Existence Checks in MySQL

INNER JOIN vs. EXISTS for Existence Checks in MySQL When checking if a relation exists in MySQL, you might use an INNER JOIN, but sometimes EXISTS (SELECT .

Understanding LIKE Wildcards in MySQL

Understanding LIKE Wildcards in MySQL In MySQL, the LIKE operator supports two wildcard characters for pattern matching.

Unraid Increase Docker Image Disk Size

Instructions for how to increase the Docker Image disk size in Unraid.

About

Hi, my name is Pieter Michels. These notes are thoughts or small snippets as a reminder for me or anyone looking.

Fresh Start

Starting fresh in 2020 with little notes and articles.

Mount Disk Permanently on Linux

In case you want to permanently mount an (Amazon EBS for instance) volume on a machine.

(untitled)