Patrick Espake - Learning Heroku Postgres [2015, PDF, ENG] torrent

Книги и журналы » Компьютерная литература » СУБД

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.
[spoiler="Примеры страниц"]

[/spoiler]
[spoiler="Оглавление"]
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
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
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
Plans
Importing in Heroku Postgres
Exporting databases
Downloading the backup
Restoring to local database
Removing the add-on
Self-test Questions
Summary

5: Dataclips
Creating dataclips
Sharing dataclips
Interacting with dataclips
Dataclips security
Limitations and additional settings
Self-test questions
Summary

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
Log statements
Common errors
Metrics logs
Self-test questions
Summary

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
[/spoiler]