Using SELECT Inside INSERT in PostgreSQL


Learn how to insert data dynamically using a SELECT statement in PostgreSQL.
Read more ⟶

Clearing Cached Plans in PostgreSQL


Learn how to clear cached query plans in PostgreSQL using simple commands.
Read more ⟶

Fixing Unsigned Repository Error in Docker Builds


Resolve the 'InRelease is not signed' error in Docker by freeing up disk space.
Read more ⟶

Print Lines Above and Below a grep Match


Use grep with -C to display surrounding lines for better context.
Read more ⟶

Handling Unique Constraints in Ecto with on_conflict


Use on_conflict and conflict_target in Ecto to manage unique constraints in PostgreSQL.
Read more ⟶

INNER JOIN vs. EXISTS for Existence Checks in MySQL


Learn when to use EXISTS instead of INNER JOIN for better performance in MySQL.
Read more ⟶

Understanding LIKE Wildcards in MySQL


Learn how to use _ and % wildcards with the LIKE operator in MySQL.
Read more ⟶

Unraid Increase Docker Image Disk Size


Instructions for how to increase the Docker Image disk size in Unraid.…
Read more ⟶

Fresh Start


Starting fresh in 2020 with little notes and articles.…
Read more ⟶

Mount Disk Permanently on Linux


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