noort notes

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 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 When sensitive data accidentally gets committed to Git, removing it from history requires careful handling.

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 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 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 In SQL, you can use a SELECT statement inside an INSERT to insert data dynamically from another table.

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 If you encounter the error The repository 'http://xxx yyy InRelease' is not signed.

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 When inserting data in Ecto, you may encounter unique constraint violations that clutter your logs.

INNER JOIN vs.

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

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

Starting fresh in 2020 with little notes and articles.

Hi, my name is Pieter Michels.

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