Chapter 1, Introduction to PostgreSQL Development and Administration, introduces the development of PostgreSQL and how PostgreSQL has become a popular Database as a Service (DBaaS) among the current clouds. We will present an overview of the numerous features of PostgreSQL in various development environments, such as Node.js and Django. Moving forward, we will introduce you to the PostGIS extension, which is a PostgreSQL facility for a geospatial PostgreSQL database. We will also present the PostgREST standalone web server, which aims to do one thing well: add an HTTP interface to any PostgreSQL databases or RESTful APIs. Then, in the second part of the chapter, we will learn about the administration of PostgreSQL.
Chapter 2, Setting Up a PostgreSQL RDS for ATM Machines, describes the DBaaS options for PostgreSQL through Amazon RDS for PostgreSQL.
Chapter 3, Using PostgreSQL and Node.js for Banking Transactions, describes the steps to create a RESTful web service that will be an Application Programming Interface (API) based on Node.js, Express, and PostgreSQL and will implement HTTP requests such as the GET, PUT, POST, and DELETE methods on data.
Chapter 4, Managing Bank ATM Locations Using PostgreSQL and Django, shows how to install and configure PostgreSQL so that you can use it with a Django application.
Chapter 5, Creating a Geospatial Database Using PostGIS and PostgreSQL, introduces you to PostGIS, a spatial extension for PostgreSQL. Through the project in the chapter, we will learn to implement geographic mapping for our Postgres Relational Database Service (RDS).
Chapter 6, Managing Banking Transactions Using PostgREST, teaches how to develop with PostgREST. The project in this chapter will help us use PostgREST to create an API for sending requests to the RDS.
Chapter 7, PostgreSQL with DevOps for Continuous Delivery, teaches how to set up DevOps tasks for PostgreSQL databases.
Chapter 8, PostgreSQL High Availability Clusters, focuses on High Availability (HA) clusters and how to achieve them with PostgreSQL.
Chapter 9, High-Performance Team Dashboard Using PostgreSQL and New Relic, demonstrates how to install and activate PostgreSQL integration and will help you gain an understanding of the data collected by the New Relic infrastructure.
Chapter 10, Testing the Performance of Our Banking App with PGBench and JMeter, shows us how to create a load test for a PostgreSQL database to benchmark PostgreSQL performance with PGBench and JMeter.
Chapter 11, Test Frameworks for PostgreSQL, showcases how to write automated tests for existing stored procedures and develop procedures using the concepts of unit tests and Test-Driven Development (TDD).
Chapter 12, Appendix - PostgreSQL among the Other Current Clouds, talks about the various DBaaS options for PostgreSQL with other cloud platforms.
