Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning Heroku Postgres

By : Patrick Rafael de Oliveira Espake

4.3 (4)

Learning Heroku Postgres

4.3 (4)

By: Patrick Rafael de Oliveira Espake

Overview of this book

Learning Heroku Postgres is targeted at developers and database admins. Even if you're new to Heroku Postgres, you'll be able to master both the basic as well as advanced features of Heroku Postgres. Since Heroku Postgres is incredibly user-friendly, no previous experience in computer coding or programming is required.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started with Heroku Postgres

1. Getting Started with Heroku Postgres

How does Heroku work?

Postgres supported versions

Choosing the right Heroku Postgres plan

Production-tier technical characterization

High availability

Self-test Questions

Summary

2. Heroku Toolbelt

2. Heroku Toolbelt

Signing up

Installing the Heroku Toolbelt

Logging in to Heroku

Deploying an application

The sample application source code

The dependencies file

Deploying the sample application

Visiting the sample application

Self-test questions

Summary

3. Postgres Add-on

3. Postgres Add-on

Local setup

Creating a new app

Adding the add-on and creating the first database

Heroku Postgres web interface

Using the Heroku client with Postgres

Connecting with Java

Connecting with Python

Connecting with Django

Connecting with Node.js

Connection permissions

Multiple schemas

External connections

Connecting to databases from outside Heroku

Monitoring and logging

Removing the add-on

Self-test Questions

Summary

4. PG Backups

4. PG Backups

Plans

Importing in Heroku Postgres

Exporting databases

Downloading the backup

Restoring to local database

Removing the add-on

Self-test Questions

Summary

5. Dataclips

5. Dataclips

Creating dataclips

Sharing dataclips

Interacting with dataclips

Dataclips security

Limitations and additional settings

Self-test questions

Summary

6. Rollback, Followers, and Forks

6. Rollback, Followers, and Forks

Heroku Postgres rollback

Heroku Postgres follower databases

Heroku Postgres forking databases

Self-test questions

Summary

7. Understanding Log Statements and Common Errors

7. Understanding Log Statements and Common Errors

Log statements

Common errors

Metrics logs

Self-test questions

Summary

8. Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning

8. Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning

Heroku Postgres extensions

Data types

Statistics

Languages

Full text search dictionaries

Data caching

Setting up PostGIS

Database tuning

Automatic vacuuming

Performance analysis

Self-test Questions

Summary

A. Keyword List

A. Keyword List

B. Self-test Answers

Chapter 1: Getting Started with Heroku Postgres

Chapter 2: Heroku Toolbelt

Chapter 3: Postgres Add-on

Chapter 4: PG Backups

Chapter 5: Dataclips

Chapter 6: Rollback, Followers, and Forks

Chapter 7: Understanding Log Statements and Common Errors

Chapter 8: Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning

Index

Index

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows:

In the case of Ruby on Rails, these dependencies are found in Gemfile in Python requirements.txt, in Node.js package.json, and in Java pom.xml.

Any command-line input or output is written as follows:

$ heroku pg:info --app learning-heroku-postgres-app

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "clicking the Next button moves you to the next screen".

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Heroku Postgres

Search

Your notes and bookmarks