How can I integrate a database with FastAPI?

How can I integrate a database with FastAPI?

You can integrate a database with FastAPI using SQLAlchemy or Tortoise-ORM. Which one would you like to know more about?

I'd like to know more about SQLAlchemy.

Great choice! First, you'll need to install SQLAlchemy and a database driver. Do you have a specific database in mind?

I'm planning to use PostgreSQL.

Perfect! You can install the PostgreSQL driver using pip. Would you like a code example to get started?

Yes, please provide a code example.

Here's a simple example:

from fastapi import FastAPI
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

DATABASE_URL = "postgresql://user:password@localhost/dbname"
engine = create_engine(DATABASE_URL)
Base = declarative_base()

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

Base.metadata.create_all(bind=engine)

This sets up a basic User model.