Efficiently design, implement, and manage a successful PostgreSQL database with Heroku
This book establishes a good learning mechanism by initially covering simple topics such as Heroku Toolbelt before moving on to complex topics such as data caching and tuning and PostGIS.
The book begins by giving you an introduction to the working of Heroku Postgres. This is followed by an overview of the PostgreSQL add-on, using which you'll create your first database and connect it using various programming languages such as Java, Ruby, Python, and Node.js. You will then look at securing your data, monitoring, working with permissions, and generating backups along with database rollbacks, followers, and forks to manage any loss in your data. Finally, you will improve the performance of your database by diving into log statements and understand how to avoid common mistakes.
What You Will Learn
Introduce yourself to the inner workings of Heroku Postgres
Deploy your first application with Heroku using the Heroku Toolbelt
Work with permission levels to connect your database with a number of programming languages
Secure your database using Postgres backups
Interact with your data and share it with Dataclips
Manage your data loss by performing rollbacks and working with followers and forks
Identify common errors by analyzing logs and viewing metrics
Add functionalities to your database with extensions such as PostGIS and Full Text Search Dictionaries
Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.