FastAPI A FastAPI application with SQLAlchemy and PostGreSQL.

Sample Setup Create a virtual environment using virtualenv module in python.

Install module (globally)

pip install virtualenv

Generate virtual environment

virtualenv --python= venv

Activate virtual environment

source venv/bin/activate

Install depdendency packages

pip install -r requirements.txt Configure .env file Setup a postgres docker container docker run -p 5432:5432 --name postgres -e POSTGRES_PASSWORD= -d postgres:14 At app directory, run alembic migration command. Please make sure your postgres DB is ready and accessible. In case you want to use SQLite instead, please be sure to configure the env.py file in alembic folder to support batch execution since SQLite does not support ALTER command, which is needed to configure the foreign key and establish the indexes.

Migrate to latest revison

alembic upgrade head

Dowgragde to specific revision

alembic downgrade <revision_number>

Downgrade to base (revert all revisions)

alembic downgrade base

Create new revision

alembic revision -m Run uvicorn web server from app directory (reload mode is for development purposes) uvicorn main:app --reload