Before I was a software developer, I worked in hospitality sales and marketing. One of the most time-consuming (and seemingly never-ending) tasks I had early on in my career was loading hotel inventory and rates onto online travel agency websites like Expedia and Booking.com. And back in the day before channel managers let you update the sites all at once, I had to enter this site by site, room type by room type, day by day for four properties and over 800 rooms. To say that I have some strong opinions about data entry UI design is an understatement.
The completed project will look like this:
A quick guide to creating a PostgreSQL database through ElephantSQL and connecting it to your Node.js application and Postico
In this tutorial we will walk through setting up a node application with a database, using ElephantSQL to set up a PostgreSQL database as well as connecting to visual interface, Postico.
All of these tools have free plans which will allow you to get started with your project without any put of pocket costs.
There will be four steps you will need to complete before your project is up and running:
1) Set up a Postgres database using ElephantSQL
Before I learned to write code, I wrote blog posts and marketing copy for businesses in the hospitality industry. Since my work was remote and on a freelance basis, I didn’t have co-workers, but house guests and strangers in coffee shops often commented on my lighting fast typing speed. Also, that I’m a very loud typer — you can rest assured that there is a lot of force behind these words!
But when I started my programming journey, the new-to-me syntax and constant changes needed to make my code work had me hunting and pecking at the keyboard like my…
Software Developer | Freelance Writer | Based in Savannah, GA