You're reading from Building Python Microservices with FastAPI Build secure, scalable, and structured Python microservices from design concepts to infrastructure

Product type Paperback

Published in Aug 2022

Publisher Packt

ISBN-13 9781803245966

Length 420 pages

Edition 1st Edition

Languages

Python

Tools

FastAPI

Concepts

Microservices

Author (1):

Sherwin John C. Tragura

View More author details

Table of Contents (17) Chapters

Preface

1. Part 1: Application-Related Architectural Concepts for FastAPI microservice development

2. Chapter 1: Setting Up FastAPI for Starters FREE CHAPTER

3. Chapter 2: Exploring the Core Features

4. Chapter 3: Investigating Dependency Injection

5. Chapter 4: Building the Microservice Application

6. Part 2: Data-Centric and Communication-Focused Microservices Concerns and Issues

7. Chapter 5: Connecting to a Relational Database

8. Chapter 6: Using a Non-Relational Database

9. Chapter 7: Securing the REST APIs

10. Chapter 8: Creating Coroutines, Events, and Message-Driven Transactions

11. Part 3: Infrastructure-Related Issues, Numerical and Symbolic Computations, and Testing Microservices

12. Chapter 9: Utilizing Other Advanced Features

13. Chapter 10: Solving Numerical, Symbolic, and Graphical Problems

14. Chapter 11: Adding Other Microservice Features

15. Index

Why subscribe?

16. Other Books You May Enjoy

Preparing for database connectivity

Let us consider some application-related concerns before we start discussing database connectivity in FastAPI:

First, all the application prototypes from this chapter onward will be using PostgreSQL as the sole relational DBMS. We can download its installer from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.
Second, the fitness club management system prototype has an existing database called fcms with six tables, namely signup, login, profile_members, profile_trainers, attendance_member, and gym_class. All these tables, along with their metadata and relationships, can be seen in the following diagram:

Figure 5.1 – The fcms tables

The project folder contains a script called fcms_postgres.sql that installs all these schemas.

Now that we’ve installed the latest version of PostgreSQL and run the fcms script file, let us learn about SQLAlchemy, the most widely used ORM library...