Blog Engine — Python · Postgres

FastAPI + asyncpg: the blog engine with the shortest path from zero to endpoint.

The Python + Postgres take on the series: FastAPI for the surface, asyncpg with raw SQL underneath — no ORM, no session juggling. Argon2 local auth issuing JWTs, uv-friendly pyproject, and the same Clerk/Auth0 swap examples as every sibling.

What's inside

• Full CRUD + publish flow for markdown posts
• Local auth: users table, argon2, HS256 JWT
• Drop-in Clerk & Auth0 JWT verifier examples
• Raw SQL via asyncpg — no ORM
• schema.sql applied on startup
• docker-compose with healthchecked Postgres

Quickstart

$ curl -LO https://devai.io/downloads/blog-python-postgres.zip$ unzip blog-python-postgres.zip && cd blog-python-postgres$ cp .env.example .env$ docker compose up --build

Browse the code

The full source, exactly as the zip ships it.