# Konstantinos Papadopoulos

> Building beautiful things. Tech + quant finance. Developer, Chainlink Labs, based in London, UK.

I like building beautiful things and believe in small teams, relentless speed of execution & maximum decluttering. I pathologically despise the “idea people” — I’d rather ship.

## About

- Name: Konstantinos Papadopoulos
- Role: Developer, Chainlink Labs
- Location: London, UK
- Website: https://knspap.com
- Email: kostaspapadopoulos369@gmail.com
- LinkedIn: https://linkedin.com/in/knspap
- GitHub: https://github.com/KonstantinosPapadopoulos

## Essays

- [The Cost of a Clever Abstraction](https://knspap.com/essays/the-cost-of-a-clever-abstraction) — I once replaced four hundred lines of repetitive code with forty lines nobody could read. Here is the arithmetic I now do before doing that again. (August 22, 2026, 2 min, Practice/Architecture; Markdown: https://knspap.com/essays/the-cost-of-a-clever-abstraction/index.md)
- [Half a Million Points on a Phone](https://knspap.com/essays/half-a-million-points-on-a-phone) — Velvynote renders a world map of user notes on hardware that is mostly a battery with a screen. The map was never the hard part — the transitions between zoom levels were. (July 18, 2026, 3 min, Geospatial/Performance; Markdown: https://knspap.com/essays/half-a-million-points-on-a-phone/index.md)
- [Reading the Query Plan](https://knspap.com/essays/reading-the-query-plan) — Postgres will tell you exactly why your query is slow, in a format designed to be ignored. Four things to look at, in order. (June 9, 2026, 3 min, Postgres/Performance; Markdown: https://knspap.com/essays/reading-the-query-plan/index.md)
- [Migrations That Survive Production](https://knspap.com/essays/migrations-that-survive-production) — Every project I have shipped eventually developed two sources of truth for its schema. Here is the discipline that finally stopped it happening. (May 2, 2026, 2 min, Postgres/Practice; Markdown: https://knspap.com/essays/migrations-that-survive-production/index.md)
- [Motion With Intent](https://knspap.com/essays/motion-with-intent) — Most animation on the web is decoration wearing a costume. The test I use to decide whether a transition earns its milliseconds. (February 11, 2026, 2 min, Interface/Motion; Markdown: https://knspap.com/essays/motion-with-intent/index.md)

## Work

- [Valion](https://valion.dev) — Security operations platform for the AI age. Catch them before they catch you. (Defence & Security, Live, 2025; built with FastAPI, PostgreSQL, Alembic, React, TypeScript)
- [Velvynote](https://velvynote.app) — An online world you play by leaving something behind — notes dropped at real coordinates, found by strangers who stand in the same place. (Side project - online game, Live, 2025; built with React 19, MapLibre GL, PostGIS, Supabase)
- [WhaleCreep](https://whalecreep.com) — Institutional holdings from 13F filings, parsed and compared quarter over quarter and fund against fund. (Side project - finance, In development, 2026)

## Everything else

- [Every essay as one Markdown file](https://knspap.com/llms-full.txt)
- [About](https://knspap.com/about)
- [RSS feed](https://knspap.com/feed.xml)
- [Sitemap](https://knspap.com/sitemap.xml)