Dynamically Serving REST Endpoints for Database Stored Procedures with FastAPI
PyCon South Africa via YouTube
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Learn Backend Development Part-Time, Online
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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