2. CRUD Python/Flask with PostgreSQL on Azure

This is video series showcasing how to build and deploy a full stack application in Azure. In this episode I'll continue with a python/flask application. We first introduce PostgreSQL database with some simple schema (a book table with attributes title, author, number of pages and either read/not read will be used). Then we will add CRUD (create, read, update and delete) methods and introduce relevant routes to make our python/flask program a proper API. ?

Previous & Next episodes

1. Dockerized Flask with Gunicorn - https://youtu.be/nrXEnrV-ZSM
2. CRUD Python/Flask with PostgreSQL on Azure - https://youtu.be/DjsLn-S43sA
3. CRUD vue.js using Azure Static Web Application service - https://youtu.be/q-6nQ1dh_7c

Full list of series is here: https://www.youtube.com/playlist?list=PLGDcAnVRQ36OTZqSropZYUcJKx3Hte4K2

All code can be found here - https://github.com/erudinsky/Azure-Bicep-Workshop ?

The goal of the episode is to have API and its database deployed to azure using Web App and managed PSQL (we will also need to bump into Azure Container Registry, Azure KeyVault, Managed Identity, Roles and its assignment). Everything will be done via code, Azure Portal we will use in read only mode (mainly to review and confirm things being done via code).

Chapters:

0:00 Getting started with PostgreSQL
1:07 Python/Flask CRUD application explained
4:45 Working with Postman, calling API endpoints
8:00 Dockering all together and run locally (including docker network config)
12:00 Bicep lang to create Azure KeyVault, Azure Container Registry, Azure Web App and Azure PostgreSQL (Single Server), Managed Identity and Roles with Role Assignments..
28:10 Visualisation of deployed resources

Prerequisites:

PostgreSQL - https://www.postgresql.org/ to store structured data (books)
Postman - https://www.postman.com/ to test CRUD methods
Visual Studio Code ?? - https://code.visualstudio.com/
Python virtual environment https://docs.python.org/3/tutorial/venv.html
Flask: https://flask.palletsprojects.com/en/2.1.x/
Gunicorn WSGI: https://gunicorn.org/
Docker getting started ? - https://docs.docker.com/desktop/mac/install/
Azure Container Registry: https://docs.microsoft.com/en-us/azure/container-registry/
Azure Bicep getting started ? - https://docs.microsoft.com/en-us/azure/azure-resource-manager/bicep/overview?tabs=bicep

#microsoft #azure #fullstack #python #flask #gunicorn #bicep #infrastructureascode #docker #container #postgresql #db #database #webapp #keyvault #managedidentity #serviceprincipal