Learning Heroku Postgres
Год издания: 2015
Автор: Patrick Espake
Издательство: Packt Publishing
ISBN: 9781782173458
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 164
Описание: 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.
Примеры страниц Оглавление
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
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
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
4: PG Backups
Importing in Heroku Postgres
Exporting databases
Downloading the backup
Restoring to local database
Removing the add-on
Self-test Questions
5: Dataclips
Creating dataclips
Sharing dataclips
Interacting with dataclips
Dataclips security
Limitations and additional settings
Self-test questions
6: Rollback, Followers, and Forks
Heroku Postgres rollback
Heroku Postgres follower databases
Heroku Postgres forking databases
Self-test questions
7: Understanding Log Statements and Common Errors
Log statements
Common errors
Metrics logs
Self-test questions
8: Extensions, PostGIS, Full Text Search Dictionaries, Data Caching, and Tuning
Heroku Postgres extensions
Data types
Full text search dictionaries
Data caching
Setting up PostGIS
Database tuning
Automatic vacuuming
Performance analysis
Self-test Questions

If you like the topic, please click share to help develop our site.

To download the file disable ad blocking, and reload the page.

disable adblock How to disable ad blocking?

Download by magnet link 2 MB Download Torrent

Login using:

Similar topics

Hans-Jürgen Schönig - Mastering PostgreSQL 10 [2018, PDF, ENG]
 2 MB   0 | 0   16-Aug-18 15:10   11

Current time is: 18-Feb 19:53 :: All times are UTC + 3