New paste
No registration requiredPublic pastes
Newest firstA Few Design Issues I Noticed on Your stirkbin.comHello stirkbin.com,
I noticed a few design-related issues on your stirkbin.com that could im
pythonUntitled pasteweb-1 | Listening on 0.0.0.0:3000
db-1 | 2026-09-08 01:14:02.331 UTC [1] LOG: database syst
plainpython venv reminderpython3 -m venv .venv
. .venv/bin/activate
pip install -r requirements.txt
# if pip is old ins
shellwhich commit broke the testsgit bisect start
git bisect bad HEAD
git bisect good v0.4.2
git bisect run npm test -- --silent
shellreadings export, first rowstimestamp,sensor,temp_c,humidity
2026-09-07T00:00:12Z,porch,14.2,81
2026-09-07T00:05:12Z,porch,
plainfetch with timeoutasync function getJson(url, ms = 5000) {
const controller = new AbortController();
const ti
javascriptbackup.sh - excludes#!/bin/sh
# run from the project directory
rsync -av --dry-run --exclude=node_modules/ --exclud
shellold .env, delete me# copied off the old box before wiping it, most of this is probably dead
APP_ENV=production
DB_
plainimport fails on line 418Traceback (most recent call last):
File "import_readings.py", line 27, in <module>
readin
plainslow query before/after indexEXPLAIN QUERY PLAN SELECT * FROM readings WHERE sensor = 'porch' AND ts > 1757000000;
-- SCAN r
sqlduplicate album namesSELECT artist_id, title, COUNT(*) AS n
FROM albums
GROUP BY artist_id, title
HAVING COUNT(*) >
sql