In this chapter, you will learn about the Postgres add-on, how to configure your local development environment, how to use the add-on, how to create your database, and how to connect using different programming languages. In addition, you will learn about connection permissions, how to connect in the database, and how to use databases that are not hosted on Heroku. You will also learn the first concepts of monitoring, information logs, and how to remove the add-on.
In this chapter, we will cover the following topics:
Local setup
Creating a new app
Adding the add-on and creating the first database
The Heroku Postgres web interface
Using the Heroku client with Postgres
Connecting with Java
Connecting with Ruby
Connecting with Python
Connecting with Node.js
Connection permissions
External connections
Connecting to databases from outside Heroku
Monitoring and logging
Removing the add-on