Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Learning Heroku Postgres
  • Table Of Contents Toc
Learning Heroku Postgres

Learning Heroku Postgres

By : Patrick Rafael de Oliveira Espake
4.3 (4)
Buy this Book
close
close
Learning Heroku Postgres

Learning Heroku Postgres

4.3 (4)
By: Patrick Rafael de Oliveira Espake
Buy this Book

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.
Table of Contents (12 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Getting Started with Heroku Postgres
Icon
1. Getting Started with Heroku Postgres
Icon
How does Heroku work?
Icon
Postgres supported versions
Icon
Choosing the right Heroku Postgres plan
Icon
Production-tier technical characterization
Icon
High availability
Icon
Self-test Questions
Icon
Summary
2
2. Heroku Toolbelt
Icon
2. Heroku Toolbelt
Icon
Signing up
Icon
Installing the Heroku Toolbelt
Icon
Logging in to Heroku
Icon
Deploying an application
Icon
The sample application source code
Icon
The dependencies file
Icon
Deploying the sample application
Icon
Visiting the sample application
Icon
Self-test questions
Icon
Summary
3
3. Postgres Add-on
Icon
3. Postgres Add-on
Icon
Local setup
Icon
Creating a new app
Icon
Adding the add-on and creating the first database
Icon
Heroku Postgres web interface
Icon
Using the Heroku client with Postgres
Icon
Connecting with Java
Icon
Connecting with Python
Icon
Connecting with Django
Icon
Connecting with Node.js
Icon
Connection permissions
Icon
Multiple schemas
Icon
External connections
Icon
Connecting to databases from outside Heroku
Icon
Monitoring and logging
Icon
Removing the add-on
Icon
Self-test Questions
Icon
Summary
4
4. PG Backups
Icon
4. PG Backups
Icon
Plans
Icon
Importing in Heroku Postgres
Icon
Exporting databases
Icon
Downloading the backup
Icon
Restoring to local database
Icon
Removing the add-on
Icon
Self-test Questions
Icon
Summary
5
5. Dataclips
Icon
5. Dataclips
Icon
Creating dataclips
Icon
Sharing dataclips
Icon
Interacting with dataclips
Icon
Dataclips security
Icon
Limitations and additional settings
Icon
Self-test questions
Icon
Summary
6
6. Rollback, Followers, and Forks
Icon
6. Rollback, Followers, and Forks
Icon
Heroku Postgres rollback
Icon
Heroku Postgres follower databases
Icon
Heroku Postgres forking databases
Icon
Self-test questions
Icon
Summary
7
7. Understanding Log Statements and Common Errors
Icon
7. Understanding Log Statements and Common Errors
Icon
Log statements
Icon
Common errors
Icon
Metrics logs
Icon
Self-test questions
Icon
Summary
8
8. Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning
chevron up
Icon
8. Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning
Icon
Heroku Postgres extensions
Icon
Data types
Icon
Statistics
Icon
Languages
Icon
Full text search dictionaries
Icon
Data caching
Icon
Setting up PostGIS
Icon
Database tuning
Icon
Automatic vacuuming
Icon
Performance analysis
Icon
Self-test Questions
Icon
Summary
9
A. Keyword List
Icon
A. Keyword List
10
B. Self-test Answers
Icon
Chapter 1: Getting Started with Heroku Postgres
Icon
Chapter 2: Heroku Toolbelt
Icon
Chapter 3: Postgres Add-on
Icon
Chapter 4: PG Backups
Icon
Chapter 5: Dataclips
Icon
Chapter 6: Rollback, Followers, and Forks
Icon
Chapter 7: Understanding Log Statements and Common Errors
Icon
Chapter 8: Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning
11
Index
Icon
Index

Data types

In computer science, data type is a combination of values and operations that one variable can perform. There are a large number of data types available such as integer, float, Boolean, Array, Hash, and many others. PostgreSQL is no different; you have a collection of data types available by default, such as numeric, monetary, character, binary, date/time, Boolean, enumerated, and many others.

In some cases, other kinds of data types are necessary and they aren't installed by default on PostgreSQL. In this section, you will discover the power of some important extensions for data types.

Case-insensitive text – citext

This data type is very useful for working with queries where the data is case insensitive. You can use this feature with an implementation to facilitate your searches, such as searching for products on an e-commerce website.

For you to understand, the data type text is generally used, but it is case sensitive. For example, suppose you have a table with the...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Learning Heroku Postgres
End of Section 8
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon