Setting up a free PostgreSQL database on Heroku

I'm a full-stack developer from South Africa 🇿🇦. I love writing about JavaScript, HTML and CSS.
Search for a command to run...

I'm a full-stack developer from South Africa 🇿🇦. I love writing about JavaScript, HTML and CSS.
No comments yet. Be the first to comment.
Most of you know me for my consistency, a golden arrow in my blog series. I've written 1000 articles in 1008 days! Almost an article a day, and my honeymoon was the only holiday I ever took. I'm super proud of this achievement; it has been a fantasti...

It's not the first time I'll be talking about community. I think it's an essential aspect of any successful tool. This shows in my previous explorations of Astro, Medusa, and now Vendure as well. All these products thrive in a super open, welcoming, ...

The cool part about Vendure is how easy it is to set up and how abstract each layer is. Basically, we get the following elements: External database Server Worker Admin UI Frontend While this is amazing, it also brings a bit of complexity when it co...

The previous article looked at customizing Vendure on a data and process level. In this article, we'll look at customizing emails, as they are often a big part of a webshop system. We'll be looking at two different layers of customization for customi...

Even though Vendure is a pretty significant project out of the box, in some cases, we might want to go in and modify some elements to work to our specific use case. In this article, I'll take a high-level look at some elements we can customize within...

Recently I wanted to explore Postgres databases for a specific use case. However, this use case needed the database to be hosted online.
Then I found out you can quickly set up a free Postgres database on Heroku!
In this article, I'll show you how you can also create your own free Postgres database.
Do note this database will be limited to the free plan. It's easy for prototyping but might be too limited for your existing apps.
First of all, we need to create or log into our Heroku account. Do todo this head over to their website and follow the login/signup process.
Once your login, add a new app by clicking the "new" button.

Give this app a name and pick a region that works for you.

Once your app is set up, we need to visit the resource panel and search for 'Postgres' to add this add-on.

On the next step, it's crucial to pick the hobby tier as this is the only free one.

To find the database credentials click on the Postgres add-on in your resource overview.

This will open up a new page where you can view the actual Postgres database in more detail. To find the credentials open up the settings menu.

Use these credentials in a database explorer for instance to connect to it. (I'll be using TablePlus)

And there you go, we now have a free Postgres database we can use!
Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter