mariadb tips
Frank Earnhardt
By default, queries are returned \t (tab) delimited <strong>INTO OUTFILE</strong> (Server-side)The INTO OUTFILE command is a SQL statement executed by the database server process itself.Where it writes: The file is…
How-To
Python-read-file
Some examples of reading a file with Python:
Nextcloud upgrade foo-bar
Why is nextcloud so hard to upgrade?
Nextcloud OPcache
The PHP OPcache module is not properly configured. The OPcache buffer is nearly full. To assure that all scripts can be hold in cache, it is recommended to apply “opcache.memory_consumption”…
Generate Random String
Generating a 32-byte (256-bit) cryptographically secure secret key is crucial for robust encryption. Here are common methods using readily available tools: 1. Using OpenSSL (Linux/macOS/Windows with OpenSSL installed): This is…
SSH into Windows 11
To SSH into Windows 11, you first need to install the OpenSSH Server feature in Settings > Apps > Optional Features and ensure it’s running in the Services app. Then,…
Python Virtual Environment
Getting an error trying to install python package: There are several ways to determine if a Python venv (virtual environment) is active: Terminal Prompt Indication. When a virtual environment is…
Building a Python CLI: An Engineering Evolution
From Hard-Coded Values to OpenAPI Generated Clients Building command-line interface (CLI) tools in Python is a fundamental skill for automation and system interaction. The journey of developing a robust CLI…
Microsoft Project Hammock Task
Oddly, there is no way to show which task a hammock is linked to.
React-Next.js
Creating simple web app using React and Next