Book Image

Learning Heroku Postgres

By : Patrick Rafael de Oliveira Espake
Book Image

Learning Heroku Postgres

By: Patrick Rafael de Oliveira Espake

Overview of this book

Table of Contents (17 chapters)
Learning Heroku Postgres
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Keyword List
Index

Summary


In this chapter, you learned the differences between PG Backups add-on plans and learned how to choose the best plan according to your need, how to use the main features provided by the add-on in order to create backups, and perform a database restore. In addition, you learned how to import database to Heroku and how to export your Heroku Postgres database.

Backup routines are important for the safety and integrity of your data; always remember to configure backups according to your need as failures can occur in any project.

In the next chapter, you will learn how to use Dataclips. Basically, this function allows you to write queries in SQL and share the results with your colleagues; they are able to view the data and download it in many formats. Besides that, you will also learn about security and some limitations.