Dynamically Serving REST Endpoints for Database Stored Procedures with FastAPI
PyCon South Africa via YouTube
Finance Certifications Goldman Sachs & Amazon Teams Trust
Master Windows Internals - Kernel Programming, Debugging & Architecture
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
Syllabus
Time: Oct 06 Fri:
Duration:
Taught by
PyCon South Africa