Welcome to the Python Movie Database!

Built using Piccolo, Piccolo Admin, and FastAPI.

Created for a presentation given at PyData Global 2021.

Running it

Create a Postgres database called ‘pymdb’ (see for the details).

pip install -r requirements.txt
piccolo migrations forwards all
piccolo movies load_data
piccolo user create

To run the server:


Then load localhost:8000 in your browser. localhost:8000/admin shows the admin interface, and localhost:8000/docs shows the Swagger docs.

Creating something similar

To create your own app like this from scratch, start with the following:

pip install piccolo['all']
piccolo asgi new


GitHub - piccolo-orm/pymdb at
A demo Piccolo app - a movie database! Contribute to piccolo-orm/pymdb development by creating an account on GitHub.