I'm a junior Python backend developer and a fourth-year Computer Science student at PJATK in Warsaw. I mostly write Python: REST APIs and backend systems, data pipelines and some applied AI. I like clean architecture and tests, and I prefer projects that solve a real problem.
Looking for a junior backend / Python developer role or internship in Warsaw or remote.
| Project | What it is | Links |
|---|---|---|
| Undercut | Formula 1 stats since 1950, race analysis and replay, and a podium prediction game. Django modular monolith with a PostgreSQL transactional outbox, Next.js frontend, self-hosted. | Try it live · Source |
| pytest-queryguard | pytest plugin that fails a test when it sends N+1 queries (a lazy load or the same statement once per row) and points to the line and the fix. SQLAlchemy 2 (sync, async, FastAPI, Flask, Litestar), Django experimental, query budgets, a missing-index check for PostgreSQL. Stable 1.0.0 since November 2026, 20 releases, 270 merged pull requests, external contributors. | Source · PyPI · Docs |
| Contrail | Self-hosted real-time flight tracker with a WebGL map, a photo per aircraft, the full track and the route ahead. | Try it live · Source |
| Reroute | Live Warsaw transit map with delays, plus a LightGBM model that predicts arrival delays (about 9% lower error than a persistence baseline on held-out data). | Try it live · Source |
| clip_to_text | Local video-to-text transcription with queued jobs, live progress and SRT export. | Source |
| pgqueue | Background job queue on PostgreSQL (SKIP LOCKED, leases, retries, dashboard). |
Source |
| Gravity Studio | Interactive Solar System viewer: a Pygame desktop app and a Three.js browser version, with orbital elements from JPL and textures from Solar System Scope. | Try it live · Source |
| plan-bot | Telegram and Discord bot for university timetables from ICS feeds. | Source |
Self-hosted demos: System status
Work that came out of building and testing pytest-queryguard.
Merged:
- litestar-org/awesome-litestar #23: added pytest-queryguard to Developer Tools.
- cleder/awesome-python-testing #135: added pytest-queryguard to the Tools list.
- sqlalchemy-utils #838: fixed the Read the Docs build so autodoc can import the package.
Open:
- SQLAdmin #1173: eager-load relationships on dotted list columns; fixes a per-row lazy load (N+1) on the list page and in exports, found by running pytest-queryguard on SQLAdmin's test suite.
- pytest #15164: make
Pytester.syspathinsert()affect subprocesses. - pytest-xdist #1397: reported the
is_xdist_controller()problem and proposed the fix; the maintainer's PR #1398 follows it. - openFEC #6782: showed that the project's test-time nplusone check reports nothing on SQLAlchemy 2.0.
- awesome-sqlalchemy #85, mjhea0/awesome-flask #59, humiaozuzu/awesome-flask #274: list submissions.
N+1 analyses in other projects' issues: Galaxy, Calibre-Web-Automated, open-wearables, AutoBot-AI, Automatos.
Also a Stack Overflow answer on mapping a PostgreSQL view without a primary key in the SQLAlchemy ORM.



