Adam Kaminski thimslugga

You can scale a SQLite database to multiple GByte in size and many concurrent readers by applying the below optimizations.

Run these every time you connect to the db

(some are applied permanently, but others are reset on new connection)

pragma journal_mode = WAL;

Instead of writing directly to the db file, write to a write-ahead-log instead and regularily commit the changes. Allows multiple concurrent readers, and can significantly improve performance.

Installing Perfetto on Fedora and Amazon Linux 2023

On Fedora, the simplest path is sudo dnf install perfetto (official RPM, currently perfetto-49.0-1.fc42 and perfetto-49.0-5.fc45 in Rawhide), which installs traced, traced_probes, the perfetto CLI, and ready-made systemd units.
On Amazon Linux 2023, there is no perfetto package in the core repos or SPAL, so download the prebuilt tracebox from get.perfetto.dev (a single statically linked binary) or build from source.
For trace analysis on either distro, download the trace_processor wrapper from get.perfetto.dev or python3 -m pip install perfetto; the AL2023 glibc (exactly glibc-2.34-52.amzn2023) meets the prebuilt trace_processor_shell requirement (GLIBC_2.34) with zero headroom.
Trace visualization uses ui.perfetto.dev, which processes the trace entirely in your browser (nothing is uploaded unless you click "Share", which only works for Googlers); you can self-host the same UI on any static web server.

Instructions

The first file is the script to be run, which you can store in your home directory. The second file is the systemd unit file which goes in /etc/systemd/system. Make sure on line 6 it references the location of the first file, and that you run systemctl daemon-reload after editing the unit file.

To run the service automatically on boot, run sudo systemctl enable avahi-alias@[domain], followed by sudo systemctl start avahi-alias@[domain] to start it immediately.

Random wolfi and tools.

get-archive-info - get a tar tvf output and the .APKINFO for every file in the archive.
build-stage - throw a bunch of files and see which build. they do not depend on each other (each only builds with the wolfi repo)

I used this to help create batches of things when changing lots of files.
test-installable - its like the c-i test that checks that all packages

Flutter CI/CD & Code Signing — Complete Reference Guide

Purpose: Reusable reference for setting up automated builds, code signing, and deployment for Flutter apps across iOS and Android.

Last Updated: July 2025

Audience: Solo developers & small teams

Linux Distro GCC GLIBC C++-Standard versions

GLIBC versions: https://launchpad.net/ubuntu/+source/glibc https://code.launchpad.net/ubuntu/+source/glibc

Build from source

apt-get install gawk bison gcc make wget tar -y

	#!/usr/bin/env -S uv run --script

	# /// script
	# requires-python = ">=3.14"
	# dependencies = [
	# "packaging",
	# ]
	# ///
	"""Query and download packages from a PEP 503/691 simple index.

	#!/bin/bash
	set -euo pipefail

	# =====================================
	# Setup Ubuntu WSL
	# Installs development environment + dotfiles configuration
	# Platform: Windows Subsystem for Linux (WSL 2)
	# Tested on: Ubuntu 26.04/24.04
	# =====================================

	bind-key C-b send-prefix
	bind-key C-o rotate-window
	bind-key C-z suspend-client
	bind-key Space next-layout
	bind-key ! break-pane
	bind-key " split-window
	bind-key # list-buffers
	bind-key $ command-prompt -I #S "rename-session '%%'"
	bind-key % split-window -h
	bind-key & confirm-before -p "kill-window #W? (y/n)" kill-window

	#!/usr/bin/python

	import argparse
	import os
	import shlex
	import sys
	import tempfile
	import yaml

	config = yaml.full_load(open(os.path.expanduser("~/.config/sandbox.yml")))