How do I connect FastAPI to a database?

How do I connect FastAPI to a database?

You can connect FastAPI to a database using SQLAlchemy or Tortoise-ORM. Which one would you prefer?

I think I'll go with SQLAlchemy. Can you show me an example?

Sure! First, install SQLAlchemy and a database driver, like asyncpg for PostgreSQL. Then, set up your database models.

What does the model setup look like?

Here's a simple example:

from sqlalchemy import Column, Integer, String
from database import Base

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String, index=True)

This defines a User model with an ID and name.