PostgreSQL infrastructure, database internals, and geospatial engineering.
I work on the layer underneath applications — replication and failover, protocol-level proxies, storage extensions, build pipelines — and occasionally on something that has no business working at all.
| LazyLora · Python / C | Out-of-core LoRA fine-tuning engine for 2.78T parameter MoE models (Kimi K3) on an 8 GB RAM laptop. Streams 1.56 TB of weights layer-by-layer from disk; forward pass verified numerically against an independent C implementation across all 93 layers. |
| flysoul · Python | A 2,328-neuron circuit built from the 2026 Google Research / HHMI Janelia whole-CNS Drosophila connectome, driving a closed-loop agent against Dark Souls 3 boss encounters with spiking plasticity and reinforcement learning. |
| pg-prism · Rust | A per-host sidecar proxy that restores the real client address PostgreSQL loses behind a TCP load balancer. Speaks the HAProxy PROXY protocol on one side and the Postgres wire protocol on the other. CI against PG 16 and 18; limitations documented honestly in AUDIT.md. |
| dbcenter-extensions · Shell | Reproducible build system for prebuilt PostgreSQL extensions — PostGIS, pgvector, pgsql-http — with checksums and per-version output trees. |
| claude-code-server · Python | Keeps Claude Code sessions alive on a Linux box and lets you drive them from a phone. A tmux + systemd session pool with self-naming sessions and survival across reboots. |
| sqlite.pdf · C / JS | A PDF document that contains a working SQLite shell. SQLite compiled to asm.js — not WASM, because a PDF viewer's JavaScript engine has none — and embedded as document-level script. You type a query into a form field and rows appear. |
| python.pdf · C / JS | The same trick with MicroPython: a real Python 3 interpreter running inside a PDF, state persisting across executions, output never leaving the document. |
| Açık Kilit · OpenSCAD / Python | A keyhole-less motorised mortise lock that drops into the existing pocket of a Turkish steel door without cutting it. Parametric CAD, MuJoCo mechanism simulation, gmsh + scikit-fem stress analysis, and a certificate-based challenge-response unlock protocol with a 19-scenario test suite. |
| EasyGnss · Python | Position computation straight from a RINEX observation file — the awkward parts of GNSS processing reduced to a single run. |
| AutoKmeansforQgis · Python | Automatic detection and classification of water bodies from satellite imagery using K-Means over the Orfeo ToolBox, scheduled and driven from QGIS. |
| PDFPaper · React / FastAPI | A PDF processing platform: convert, merge, split, compress, encrypt and unlock. Dockerised end to end. |
Notes and articles are staged in yazilar before they go out.
ipolat2001@gmail.com