How do I set up a database with FastAPI?

How do I set up a database with FastAPI?

To set up a database with FastAPI, you can use SQLAlchemy for ORM. Do you have a specific database in mind?

I want to use PostgreSQL.

Great choice! First, install the required packages: pip install fastapi[all] psycopg2-binary. Then, you can create a database connection using SQLAlchemy.

Can you show me a code example?

Sure! 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 Item(Base):
    __tablename__ = 'items'
    id = Column(Integer, primary_key=True, index=True)
    name = Column(String, index=True)

Base.metadata.create_all(bind=engine)

app = FastAPI()
"""

What about creating API endpoints for the database?

You can create endpoints using FastAPI's routing. For example, to create an item, you can define a POST endpoint that interacts with the database.