Currently, the application connects to a locally installed PostgreSQL database instance. This introduces setup friction and makes it harder to ensure consistency across development environments.
This issue proposes setting up the database using Docker Compose, and updating the application to use this setup. Additionally, a support for running database migrations within the Dockerized environment can also be added.