Systems Engineering & Performance Notes

Personal notebook on asynchronous Python, Go services, Linux kernel tuning, time-series storage, and deterministic benchmarking.

Python / asyncio Go Linux / eBPF SQLite / WAL WebSockets

Selected Projects

2026 · Go / WebSockets

Orderbook Stream Aggregator

Lock-free ring-buffer pipeline normalizing L2 orderbook deltas from multiple WebSocket feeds with sub-millisecond fan-out over Unix domain sockets.

2026 · Python / SQLite

WAL Batch Writer

Single-writer async queue batching telemetry inserts into SQLite WAL mode with bounded backpressure and zero lock contention for concurrent readers.

2025 · Linux / Networking

TCP BBR & Socket Pacing Lab

Reproducible benchmarks comparing cubic vs. BBRv1/v3 under simulated packet loss, jitter, and micro-burst workloads using netem.

Engineering Notes

November 2026 · Storage

Avoiding SQLite Lock Contention Under High Write Rates

When multiple worker processes write to a single SQLite database concurrently, even WAL mode will eventually surface SQLITE_BUSY spikes under fsync pressure. Moving writes into a dedicated writer loop that groups transactions into 50ms windows cuts fsync overhead by an order of magnitude while keeping p99 read latency predictable.

PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
PRAGMA busy_timeout = 5000;
PRAGMA cache_size = -64000;
October 2026 · Runtime

Measuring Tail Latency Without Observer Bias

Average latency hides queue buildup. Capturing monotonic timestamps at ingress and egress and storing HDR histograms in memory avoids allocation jitter during measurement. Always separate network serialization cost from scheduling delay in asyncio event loops.

September 2026 · Go

Unix Domain Sockets vs. Localhost TCP for IPC

Switching high-frequency local RPC from loopback TCP to Unix domain sockets eliminates TCP handshake overhead, TIME_WAIT port exhaustion, and unnecessary checksum passes, shaving ~35% off median round-trip time on Linux 6.x kernels.

Tools & Environment

Languages

Python 3.12, Go 1.24+, C++20, Bash, SQL.

Observability

pprof, perf, flamegraphs, ss/tcpdump, journald.

Infrastructure

Ubuntu LTS, systemd resource slices, Nginx, Let’s Encrypt.

Contact

For technical correspondence or collaboration: admin@profyver.xyz