You're reading from Building Data Science Applications with FastAPI Develop, manage, and deploy efficient machine learning applications with Python

Product type Paperback

Published in Jul 2023

Publisher Packt

ISBN-13 9781837632749

Length 422 pages

Edition 2nd Edition

Languages

Python

Tools

FastAPI

Concepts

Data Science

Author (1):

François Voron

View More author details

Table of Contents (21) Chapters

Preface

1. Part 1: Introduction to Python and FastAPI

2. Chapter 1: Python Development Environment Setup FREE CHAPTER

3. Chapter 2: Python Programming Specificities

4. Chapter 3: Developing a RESTful API with FastAPI

5. Chapter 4: Managing Pydantic Data Models in FastAPI

6. Chapter 5: Dependency Injection in FastAPI

7. Part 2: Building and Deploying a Complete Web Backend with FastAPI

8. Chapter 6: Databases and Asynchronous ORMs

9. Chapter 7: Managing Authentication and Security in FastAPI

10. Chapter 8: Defining WebSockets for Two-Way Interactive Communication in FastAPI

11. Chapter 9: Testing an API Asynchronously with pytest and HTTPX

12. Chapter 10: Deploying a FastAPI Project

13. Part 3: Building Resilient and Distributed Data Science Systems with FastAPI

14. Chapter 11: Introduction to Data Science in Python

15. Chapter 12: Creating an Efficient Prediction API Endpoint with FastAPI

16. Chapter 13: Implementing a Real-Time Object Detection System Using WebSockets with FastAPI

17. Chapter 14: Creating a Distributed Text-to-Image AI System Using the Stable Diffusion Model

18. Chapter 15: Monitoring the Health and Performance of a Data Science System

19. Index

Why subscribe?

20. Other Books You May Enjoy

Communicating with a SQL database with SQLAlchemy ORM

To begin, we’ll discuss how to work with a relational database using the SQLAlchemy library. SQLAlchemy has been around for years and is the most popular library in Python when you wish to work with SQL databases. Since version 1.4, it also natively supports async.

The key thing to understand about this library is that it’s composed of two parts:

SQLAlchemy Core, which provides all the fundamental features to read and write data to SQL databases
SQLAlchemy ORM, which provides a powerful abstraction over SQL concepts

While you can choose to only use SQLAlchemy Core, it’s generally more convenient to use ORM. The goal of ORM is to abstract away the SQL concepts of tables and columns so that you only have to deal with Python objects. The role of ORM is to map those objects to the tables and columns they belong to and generate the corresponding SQL queries automatically.

The first step is...