Flask + PostgreSQL codebase containing real world examples (CRUD, auth, advanced patterns, etc) that adheres to the RealWorld spec and API

Demo    RealWorld

This codebase was created to demonstrate a fully fledged fullstack application built with Flask including CRUD operations, authentication, routing, pagination, and more.

We've gone to great lengths to adhere to the Flask community styleguides & best practices.

For more information on how to this works with other frontends/backends, head over to the RealWorld repo.

How it works

Directory Structure

/alembic
/realworld
│   app.py
│   /api
│   │   /core
│   │   │   auth.py
│   │   │   db.py
│   │   │   models.py
│   │   /routes/v1
│   │   │   /articles
│   │   │   │   endpoints.py
│   │   │   │   models.py
│   │   │   │   handlers.py
│   │   │   /profiles
│   │   │   │   ...
│   │   │   /users
│   │   │   │   ...
/scripts
/tests (only covering reasonable scenarios)

Data Model

erDiagram
    ARTICLES {
        UUID id PK
        UUID author_user_id
        TEXT title
        TEXT slug
        TEXT description
        TEXT body
    }
    TAGS {
        UUID id PK
        TEXT name
    }
    ARTICLE_TAGS {
        UUID tag_id PK
        UUID article_id PK
    }
    USERS {
        UUID id PK
        TEXT email
        TEXT username
        TEXT password_hash
        TEXT bio
        TEXT image_url
    }
    USER_FOLLOWS {
        UUID user_id PK
        UUID following_user_id PK
    }
    ARTICLE_FAVORITES {
        UUID user_id PK
        UUID article_id PK
    }
    ARTICLE_COMMENTS {
        UUID id PK
        UUID article_id
        UUID commenter_user_id
        TEXT body
    }

    ARTICLE_TAGS }o--|| ARTICLES : "article_id"
    ARTICLE_TAGS }o--|| TAGS : "tag_id"
    ARTICLE_FAVORITES }o--|| ARTICLES : "article_id"
    ARTICLE_FAVORITES }o--|| USERS : "user_id"
    ARTICLE_COMMENTS }o--|| ARTICLES : "article_id"
    ARTICLE_COMMENTS }o--|| USERS : "commenter_user_id"
    USER_FOLLOWS }o--|| USERS : "user_id"
    USER_FOLLOWS }o--|| USERS : "following_user_id"

Loading

Getting started

Clone the repository

git clone git@github.com:mhegelheimer/realworld-flask.git

Configure Environment Variables

Update the .env file with your desired configuration or leave as is for local development.

# don't change
export FLASK_APP=realworld.app

# configure
export FLASK_ENV=development
export FLASK_RUN_PORT=8080
export POSTGRES_HOST=postgres
export POSTGRES_DB=realworlddb
export POSTGRES_USER=testuser
export POSTGRES_PASSWORD=changeme

Run with Docker

Ensure you have Docker installed (install here) and running on your machine.

docker info

See the run script for available commands.

# Start the server
./run server

Other commands include:

./run

Available commands:
    dev -- Enter a shell with the dev environment set up
    server -- Start the server
    test -- Run tests
    e2e -- Run end-to-end tests against local api
    fmt -- Run black and ruff
    mypy -- Run static type checker
    teardown -- Teardown the Docker environment
    help -- List all available commands

Sample Snippets

Once the server is running, you can interact with the API using curl or Postman. Otherwise, you can browse Codebase Show and find a frontend to clone and configure to interact with the API.

curl -X POST \
  http://localhost:8080/api/users \
  -H 'Content-Type: application/json' \
  -d '{
        "user": {
            "username": "test",
            "email": "test@test.com",
            "password": "secret"
        }
    }'

curl -X GET http://localhost:8080/api/profiles/test

curl -X GET http://localhost:8080/api/tags

Third-Party Packages

• Flask
• Pydantic
• Pyhumps
• Alembic
• SQLAlchemy
• Psycopg2
• Bcrypt
• PyJWT
• Flask-Cors
• Black
• Ruff
• Mypy
• Pytest