Heroku Development Tutorials, Guides & Insights

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
import os

app = Flask(__name__)

# Adjust the DATABASE_URL format for SQLAlchemy compatibility
database_url = os.getenv("DATABASE_URL", "")
if database_url.startswith("postgres://"):
    database_url = database_url.replace("postgres://", "postgresql+psycopg2://")

app.config["SQLALCHEMY_DATABASE_URI"] = database_url

# Initialize the SQLAlchemy object
db = SQLAlchemy(app)

# Sample route to test the setup
@app.route("/")
def index():
    return "Database URI setup complete!"

if __name__ == "__main__":
    app.run()

• This code retrieves the DATABASE_URL from the environment.
• If DATABASE_URL starts with postgres://, it replaces it with postgresql+psycopg2://.
• The db instance is initialized with SQLAlchemy(app) for use with SQLAlchemy ORM.
• The replacement of "postgres://" with "postgresql+psycopg2://" is necessary because of a compatibility issue between the URI format provided by Heroku and the URI format expected by SQLAlchemy.

Open your database client, such as pgAdmin or DataGrip, and enter the details from the DATABASE_URL:

• Host: Found in the URL after @
• Database: Found after the last /
• User and Password: Found between // and @
• Port: Default is 5432 (or whatever is in the URL)

To view your Heroku apps, you can use either the Heroku CLI or the Heroku Dashboard.

Make sure you’re logged in to the Heroku CLI by running:

In today’s world of cloud computing, selecting the right cloud service provider is a key decision for developers and businesses alike. AWS (Amazon Web Services), DigitalOcean, Heroku, and Vercel are four popular platforms, each offering a distinct set of services and targeting different use cases. While all these platforms revolve around the idea of providing scalable cloud infrastructure, they vary in their approach, complexity, and target audience. In this article, we will break down the core features of each platform to help you make an informed decision based on your project needs.

AWS is one of the most comprehensive cloud computing platforms available. It offers a vast array of services, including compute power (EC2), storage (S3), databases (RDS), machine learning, networking, and much more. AWS provides a range of solutions from Infrastructure-as-a-Service (IaaS) to Platform-as-a-Service (PaaS) and even Software-as-a-Service (SaaS), making it highly suitable for enterprises that need robust and scalable infrastructure.

Log out from your Heroku account.

heroku create [app-name]