Platform-as-a-service in your own Cloud
withcoherence.com

Flask and Postgres Example

Full stack Flask and Postgres application (employee management)

This is the code to accompany the tutorial available at our Framework Guide (Flask) page.

You can use it as a starting point for any full stack Flask application. Read the guide to see how to deploy it to a production environment in your own cloud, or see the instructions below to run a development version of it locally.

Setup

Prerequisites

• Docker
• Postgres

Installation and Usage

1. Clone the repository:

   git clone https://github.com/<your_github_username>/flask-postgres-employees-demo.git
   cd flask-postgres-employees-demo

2. Add your database credentials to the docker-compose.yml file:

   services:
     db:
       image: postgres:13
       environment:
         POSTGRES_DB: <database_name>
         POSTGRES_USER: <database_user>
         POSTGRES_PASSWORD: <database_password>

3. Add your database credentials to the app.py file:

   app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql://<database_user>:<database_password>@db:5432/<database_name>'

4. Build and run the Docker container:

   docker-compose up --build

5. Run database migrations:

   docker-compose exec web flask db upgrade

6. Access the application: Open your browser and navigate to http://localhost:5000/.

Usage

1. Add Employee:

   • Fill out the form with the employee's name, email, and phone number.
   • Click "Add Employee".

2. Edit Employee:

   • Click the "Edit" link next to the employee you want to edit.
   • Update the employee's information in the form.
   • Click "Update".

3. Delete Employee:

   • Click the "Delete" link next to the employee you want to delete.

Running migrations

To run migrations, use the following command:

docker-compose exec web python migrations.py

or on Coherence add to your cnc.yaml file:

migrate: python migrations.py

Resources

Take a look at the following for more information:

• Coherence
• Why Choose Coherence
• Coherence Documentation

Cloud Infrastructure On Autopilot

Deploy containerized and serverless apps to your own cloud in minutes, not weeks.