A modern Python web application template built with FastAPI, demonstrating sync vs async operations using SQLAlchemy 2.0, psycopg2, and asyncpg. Features comprehensive testing with pytest-asyncio and pytest-cov, includes Docker support with multi-stage builds, Poetry for dependency management, and production-ready rate limiting with Redis support.
Features
FastAPI Framework Integration
Provides a modern Python web framework with automatic OpenAPI documentation and built-in Swagger UI and ReDoc interfaces for API documentation.
Database Layer
Offers dual database access patterns with psycopg2 for synchronous and asyncpg for asynchronous operations along with SQLAlchemy 2.0+ ORM.
Testing Infrastructure
Includes a comprehensive test suite using pytest, async endpoint testing with pytest-asyncio, and HTML test reports via pytest-html.
Production Features
Includes Docker support with multi-stage builds, CORS middleware configuration, type validation with Pydantic, and rate limiting using Redis.