
Take note of this URL as we'll be using it later. You will notice a "DATABASE_URL" field with a URL field next to it containing the Heroku URL for your database. Now navigate to the Settings tab within your application and in the Config Variables section click the Reveal Config Vars button. If you would like to upgrade to a paid plan, doing some research on the Heroku website would be strongly advised. Click the Provision button to add this feature. We will be covering the Hobby Dev - Free version only. Select Heroku Postgres from the dropdown and a popup window will appear asking what plan you would like to use. Application names on Heroku are first come, first serve, and the name will eventually be a part of the web URL used to access your application.Īfter creating the app, navigate to the Resources tab within the application and enter the following into the search bar located in the Add-ons section: Next you will need to create a new app on your Heroku account. Likewise, I am assuming that you'll be utilizing PSequel as a GUI to manage our database.įirst, you'll need to travel on over to the Heroku website and set up your There are many different database management systems available today, but for the sake of this article I am assuming you are familiar with PostgreSQL. This article will assume you have a working local PostgreSQL database and a working directory with at least an index.php file that you are using to query information from the database.
#HEROKU PSEQUEL INSTALL#
Much like npm for JavaScript, Composer will help you install cool packages to make your application better and will automatically install the dependencies these packages will require. The first of these is a package manager for PHP named Composer.

There will be a few items that you will need to install to make this process easier.

This article will serve as a quick reference guide to setting up your PHP application and database to be served over Heroku.
