Building Generative AI Services with FastAPI

Chapter 7. Integrating Databases into AI Services

A Note for Early Release Readers

With Early Release ebooks, you get books in their earliest form—the author’s raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 7th chapter of the final book. The GitHub repo is available at https://github.com/Ali-Parandeh/building-generative-ai-services.

If you have comments about how we might improve the content and/or examples in this book, or if you notice missing material within this chapter, please reach out to the editor at [e-mail].

Chapter Goals

1. Determine when a database is necessary and identify the appropriate database type for your project

2. Understand the underlying mechanism of relational databases and the use cases of non-relational databases

3. Learn the development workflow, tooling and best practices for working with relational databases

4. Learn the techniques to improve query performance and efficiency when working with databases

5. Understand how to manage ever evolving database schema changes

6. Learn strategies for managing codebase, database schema and data drifts when working in teams

In this chapter, you’re going to integrate a database to your current API service to store and retrieve user interactions.

This chapter assumes basic experience working with databases and SQL (Structured Query Language), so it won’t cover every aspect of SQL programming and database ...