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.

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

HyperShift

Set environment variables

CLUSTER_NAME="rosa-hcp-rcs"
PREFIX_NAME="hcp-rcs"
REGION="us-east-1"
VERSION="4.14.9"
USER=rcarrata

How to install MS Core fonts on Fedora

install dependencies

$ sudo dnf install -y rpm-build ttmkfdir

prep the work space

	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")))

	#!/usr/bin/env python3
	"""
	Antigravity to Antigravity IDE Migration Tool
	==============================================
	A self-contained script to automatically migrate extensions, custom settings, keybindings,
	snippets, workspace states, and entire conversation histories from Antigravity v1
	to the new Antigravity IDE.

	Author: Antigravity AI Coding Assistant (pair-programmed with USER)
	License: MIT