Own Work
Projects
Threads Analyzer
(MySQL / GCP CloudSQL)
(MySQL / GCP CloudSQL)
MySQL performance analysis from the command line. Polls
performance_schema.events_statements_history_long in real time and generates a self-contained HTML timeline — no server, no build step, just open the file.- Single-connection polling — one persistent MySQL connection queries the statement history buffer on a fixed interval, sized dynamically to the server's actual ring buffer capacity
- Zero-copy internment — repeated string values (users, hosts, query digests) are interned on first encounter and shared by reference, keeping memory flat even on long captures with thousands of unique queries
- Atomic, deferred persistence — events accumulate in-memory; indexes are built only after capture ends; the final on-disk file is written in a single atomic operation
- Stateful deduplication — each poll computes only the delta since the last one, per connection thread, with recycling detection for short-lived connections
- Lazy digest resolution — query text is resolved separately from the hot poll path, in batches, with a retry budget per digest before marking it permanently unresolvable
- Timer math, not wall clock — timestamps derived from MySQL's internal nanosecond timer, calibrated once at startup, so event times are accurate regardless of poll jitter
- Self-contained output — single HTML file with everything embedded; no build step, no server, no dependencies
↗
Schema Analyzer
(MySQL 8.0 / GCP CloudSQL)
(MySQL 8.0 / GCP CloudSQL)
Zero-dependency MySQL 8.0 schema analysis toolkit for GCP Cloud SQL. Audits via read replicas — no writes, no risk — and compiles findings into a single interactive HTML report.
- Secure connection — a
cloud-sql-proxytunnel is opened to the target instance; no database port is ever exposed to the network - Read-only collection — ~25 SQL queries pull metadata from
information_schemaandperformance_schema; nothing is written, results land as plain TSV files - Rules engine — 3,200-line Python analyzer runs 99+ detection rules across 38 categories; every hit recorded with pattern ID, severity, affected object, description, and recommendation
- Report generation — single self-contained HTML file; no server, no dependencies; findings are deep-linkable, severity-sorted, annotated with fix-time estimates
- Fleet mode — point at multiple Cloud SQL instances at once; collects and analyzes all schemas in one pass, one report per schema
- Instance comparison — two instances diffed side-by-side, surfacing divergence between environments (e.g. staging vs. production)
- Capacity forecasting — given a traffic increase %, projects which schemas and queries will hit bottlenecks first — before they become incidents
↗
PGN Player
tuxie.eu/pgnp
tuxie.eu/pgnp
Full-featured browser chess PGN viewer — import, analyse, train, annotate. Local Stockfish WASM, no server.
- PGN import — paste, drag-drop, file, URL, ZIP
- Multi-game database with virtual scroll
- Stockfish WASM + cloud fallback; MultiPV, eval bar & graph
- Training mode, annotations, full variation tree
- Tournament crosstable — FIDE ratings, TPR, Buchholz, S-B
- Board editor (E), figurine notation, multiple themes
↗
RPG Idle Crafter
Desktop idle RPG built solo — Electron/React, deep crafting, 50-floor dungeon, living economy. Production-grade, zero data loss.
- Specialist crafters with skill trees & async queues
- 30+ locations · 50-floor dungeon · elemental combat
- Five rarity tiers · procedural affixes · gem & rune slots
- SQLite atomic state — crash-safe
- 15,000+ icons via CSS sprites — 14 HTTP requests
- 23 stores, 5 engines, Web Audio SFX, PixiJS particles
↗