Last entries
-
vscode|ai > Visual Studio Code with Ollama - [s]
-
mac|macos|osx > /proc/pid/environ equivalent (environment for a given PID) - [s]
ps -Eww $PID
-
bash|regex - regextype with find command (regular expression) - [s]
bash-5.1$ find -regextype help find: Unknown regular expression type ‘help’; valid types are ‘findutils-default’, ‘ed’, ‘emacs’, ‘gnu-awk’, ‘grep’, ‘posix-awk’, ‘awk’, ‘posix-basic’, ‘posix-egrep’, ‘egrep’, ‘posix-extended’, ‘posix-minimal-basic’, ‘sed’. find -L /nexus-data/log -regextype posix-egrep -regex '.+/(nexus|request|audit)-2025-08-1[45].log.gz'
-
postgres|postgresql > WITH Queries (CTE recursive) for lineage/tree - [s]
WITH RECURSIVE included_parts(sub_part, part, quantity) AS ( SELECT sub_part, part, quantity FROM parts WHERE part = 'our_product' UNION ALL SELECT p.sub_part, p.part, p.quantity * pr.quantity FROM included_parts pr, parts p WHERE p.part = pr.sub_part ) SELECT sub_part, SUM(quantity) as total_quantity FROM included_parts GROUP BY sub_part