Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn how to create a dynamic REST API interface for database stored procedures in this 38-minute conference talk from PyCon South Africa. Discover a two-step approach using SQLAlchemy to identify available stored procedures and Jinja2 to generate Pydantic models and FastAPI endpoints. Explore how to securely expose internal database functionality to external parties without compromising security, using Microsoft SQL Server as an example. Gain insights into deploying the solution via Docker containers with automatic endpoint generation capabilities. Perfect for mid-level Python developers looking to bridge the gap between legacy database procedures and modern API architectures. Access accompanying resources including detailed slides and source code from the GitLab repository to implement this solution in your own projects.
