Torben's Wiki - Recent changes [en]

Biome

Torben — Mon, 13 Jul 2026 08:55:24 GMT

Created page with "== Biome Formatter == https://biomejs.dev global HOME/biome.js { "json": { "formatter": { "enabled": true, "indentStyle": "space", "indentWidth": 2, "lineEnding": "lf", "expand": "auto" } } }"

New page

== Biome Formatter ==
https://biomejs.dev

global HOME/biome.js
{
"json": {
"formatter": {
"enabled": true,
"indentStyle": "space",
"indentWidth": 2,
"lineEnding": "lf",
"expand": "auto"
}
}
}

Python

Torben — Wed, 08 Jul 2026 08:18:36 GMT

Check host:port is reachable

← Older revision		Revision as of 10:18, 8 July 2026
(One intermediate revision by the same user not shown)
Line 2,947:		Line 2,947:
	uv add --dev vulture		uv add --dev vulture
	uv run vulture src/		uv run vulture src/

			==Check host:port is reachable==
			import socket
			def check_port_is_reachable(host: str, port: int = 1433, timeout: int = 5) -> bool:
			"""Check if a TCP port on a given host is reachable."""
			try:
			with socket.create_connection((host, port), timeout=timeout):
			return True
			except Exception as e: # noqa: BLE001
			return False

Npm

Torben — Sat, 04 Jul 2026 09:33:10 GMT

← Older revision		Revision as of 11:33, 4 July 2026
Line 2:		Line 2:
	# better and faster than npm		# better and faster than npm
	brew install pnpm		brew install pnpm
			brew upgrade pnpm

	# or		# or
	npm install -g pnpm		npm install -g pnpm

	# update single package		# update single package
	pnpm up vite		pnpm up vite

AI LLM for Coding

Torben — Thu, 02 Jul 2026 21:44:21 GMT

OpenCode

← Older revision		Revision as of 23:44, 2 July 2026
(2 intermediate revisions by the same user not shown)
Line 56:		Line 56:
	# add context7 MCP		# add context7 MCP
	npx ctx7 setup --opencode		npx ctx7 setup --opencode

	~~# add Ruff Token Killer~~
	~~rtk init --global --opencode~~

	~~# add Caveman instructions to global~~
	~~# ~/.config/opencode/AGENTS.md~~
	~~# see below~~

	# initialize Opencode and create/update/improve/compress AGENTS.md file		# initialize Opencode and create/update/improve/compress AGENTS.md file
	/init		/init
Line 70:		Line 63:
	brew update		brew update
	brew upgrade anomalyco/tap/opencode		brew upgrade anomalyco/tap/opencode

			# update models
			opencode models --refresh

	Config ~/.config/opencode/opencode.json		Config ~/.config/opencode/opencode.json
Line 77:		Line 73:
	"formatter": true		"formatter": true
	}		}

			Addons
			# add Caveman and Ponytail instructions to global
			# ~/.config/opencode/AGENTS.md
			# see below

			# add Ruff Token Killer
			rtk init --global --opencode

	===Mistral Devstral===		===Mistral Devstral===

Python

Torben — Mon, 22 Jun 2026 11:30:43 GMT

Simple Connect

@@ Line 1,932: / Line 1,932: @@
 ===InfluxDB===
 see [[InfluxDB]]
 ==Internet Access==

PostgreSQL

Torben — Mon, 22 Jun 2026 11:22:41 GMT

Cron Jobs

← Older revision		Revision as of 13:22, 22 June 2026
(3 intermediate revisions by the same user not shown)
Line 649:		Line 649:
	-v ON_ERROR_STOP=1		-v ON_ERROR_STOP=1
	--command="TRUNCATE TABLE myTable; COPY myTable FROM STDIN DELIMITER '\|' CSV HEADER;" < myTable.csv		--command="TRUNCATE TABLE myTable; COPY myTable FROM STDIN DELIMITER '\|' CSV HEADER;" < myTable.csv

			==Cron Jobs==
			1. prepare DB as postgresadmin on postgres DB
			CREATE EXTENSION IF NOT EXISTS pg_cron;

			GRANT USAGE ON SCHEMA cron TO myuser;
			GRANT SELECT ON cron.job TO myuser;
			GRANT SELECT ON cron.job_run_details TO myuser;
			GRANT EXECUTE ON FUNCTION cron.schedule_in_database(text, text, text, text, text, boolean) TO myuser;

			2. connect as user 'myuser' to DB 'postgres', schema 'cron'
			-- create job my_db_cron_job
			SELECT cron.schedule_in_database(
			'my_db_cron_job', -- job name
			'0 4 * * 0', -- every Sunday 4:00 UTC
			$$DELETE FROM my_table WHERE my_date < now() - interval '30 days'$$,
			'mydb' -- target database
			);

			-- list all jobs
			SELECT jobid, jobname, schedule, command, database, username, active
			FROM cron.job
			ORDER BY jobname;

			-- delete a job:
			SELECT cron.unschedule('my_db_cron_job');

			-- check recent run history:
			SELECT jobid, start_time, end_time, status, return_message
			FROM cron.job_run_details
			ORDER BY start_time DESC
			LIMIT 20;

AI LLM for Coding

Torben — Mon, 22 Jun 2026 07:08:56 GMT

Ponytail, lazy senior dev mode

← Older revision		Revision as of 09:08, 22 June 2026
(3 intermediate revisions by the same user not shown)
Line 8:		Line 8:
	* For Refactoring/renaming: better do it manually, via VSCode, that is a lot faster		* For Refactoring/renaming: better do it manually, via VSCode, that is a lot faster

	===~~Cavemen style~~===		===Caveman speech===
	~~According~~ to [https://medium.com/@KubaGuzik/i-benchmarked-the-viral-caveman-prompt-to-save-llm-tokens-then-my-6-line-version-beat-it-d8e565f95e15]		Accoring to [https://medium.com/@KubaGuzik/i-benchmarked-the-viral-caveman-prompt-to-save-llm-tokens-then-my-6-line-version-beat-it-d8e565f95e15]
	It can be reduced to 6 hard coded lines in (global) AGENTS.md:		Caveman speech can be can be reduced to 6 hard coded lines in (global) AGENTS.md:
	Respond like smart caveman. Cut all filler, keep technical substance.		Respond like smart caveman. Cut all filler, keep technical substance.
	- Drop articles (a, an, the), filler (just, really, basically, actually).		- Drop articles (a, an, the), filler (just, really, basically, actually).
Line 21:		Line 21:
	npx skills add JuliusBrussee/caveman -a github-copilot		npx skills add JuliusBrussee/caveman -a github-copilot
	It has an option to install to local home dir instead of to project repo.		It has an option to install to local home dir instead of to project repo.

			===Ponytail, lazy senior dev mode===
			add contents of [https://github.com/DietrichGebert/ponytail/blob/main/.agents/rules/ponytail.md] to (global) AGENTS.md

			===llmfit: Right-sizes LLM models to your system's RAM, CPU, and GPU===
			https://www.llmfit.org offers a tool that suggests local LLMs that run on your hardware.

	===Context7===		===Context7===

Python

Torben — Fri, 19 Jun 2026 02:56:09 GMT

Secrets/Credentials

← Older revision		Revision as of 04:56, 19 June 2026
(2 intermediate revisions by the same user not shown)
Line 694:		Line 694:
	...		...
	case _: # default case		case _: # default case

			==Secrets/Credentials==
			use python-dotenv instead of dotenv
			uv add (--dev) python-dotenv / pip install python-dotenv

			from os import getenv
			from pathlib import Path
			from dotenv import load_dotenv
			load_dotenv(Path(".env"))
			DB_PASSWORD = getenv("PASSWORD", "")

	==File Access==		==File Access==