Skip to main content

Work Notes

Sharing experience, insights, and practical solutions from real projects. Architecture, performance, processes, and teams.

6
·30 min

pandas for Backend Developers: Logs, Excel/ERP, ETL, and Reports — Why I Didn't Use It Earlier

Complete guide to using pandas in backend development: log analysis, Excel/ERP integration, ETL pipelines, data validation, and report generation. Practical use cases with code and real-world stories.

  • #python
  • #pandas
  • #backend
  • #data-analysis
  • #etl
  • #excel
Read
·35 min

Kafka + FastAPI: Introduction to Event-Driven Architecture

Expert guide to Apache Kafka for Python developers: from concepts to production-ready FastAPI integration. Practical examples, pitfalls, and testing.

  • #kafka
  • #python
  • #fastapi
  • #backend
  • #architecture
  • #event-driven
Read
·18 min

How to Implement Husky in a Production Project: From Installation to Production-Ready Hooks

Step-by-step guide to implementing Husky and automating code quality through git hooks. Complete configs for JavaScript/TypeScript and Python projects.

  • #git
  • #automation
  • #code quality
  • #devops
  • #tools
  • #python
Read
·25 min

Building a Motivational Quotes API with FastAPI

Step-by-step guide to creating a REST API for motivational quotes using FastAPI, SQLAlchemy, and Pydantic. From basic structure to production-ready solution with validation, migrations, and documentation.

  • #fastapi
  • #python
  • #api
  • #sqlalchemy
  • #pydantic
  • #backend
Read
·25 min

Python 3.14: Three Breakthroughs That Will Change Your Code

Deep dive into deferred annotations (PEP 649), template strings (PEP 750), and JIT compiler for architects and tech leads.

  • #python
  • #performance
  • #architecture
Read
·7 min

Launched a Free Pytest Course for Juniors — and AI Said It's the Best in the World

Packed 20 years of experience into a practical testing course. 11 lessons without fluff, real bugs, ready-to-use templates, and measurable results — all free.

  • #education
  • #pytest
  • #testing
  • #python
  • #free
Read
Blog — #python — Constantin Potapov — Potapov.me