Developing Modern Database Applications with PostgreSQL

Developing Modern Database Applications with PostgreSQL

PostgreSQL is an open source object-relational Database Management System (DBMS) that provides enterprise-level services, including high performance and scalability. This book is a collection of unique projects providing you with a wealth of information relating to administering, monitoring, and testing PostgreSQL. The focus of each project is on both the development and administrative aspects of PostgreSQL.

Starting by exploring development aspects such as database design and its implementation, you’ll then cover PostgreSQL administration by understanding PostgreSQL architecture, PostgreSQL performance, and high-availability clusters. Various PostgreSQL projects are explained through current technologies such as DevOps and cloud platforms using programming languages such as Python and Node.js. Later, you’ll get to grips with the well-known database API tool, PostgREST, before learning how to use popular PostgreSQL database testing frameworks. The book is also packed with essential tips and tricks and common patterns for working seamlessly in a production environment. All the chapters will be explained with the help of a real-world case study on a small banking application for managing ATM locations in a city.

By the end of this DBMS book, you’ll be proficient in building reliable database solutions to meet your organization’s needs.

Who this book is for

This PostgreSQL book is for database developers, database administrators, data architects, or anyone who wants to build end-to-end database projects using Postgres. This book will also appeal to software engineers, IT technicians, computer science researchers, and university students who are interested in database development and administration. Some familiarity with PostgreSQL and Linux is required to grasp the concepts covered in the book effectively.

What this book covers

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.


  • 关于本书的内容介绍、目录、详情等请在 AmazonGoolge Books 等售书网站搜索查看,本站仅展示封面作为参考。
  • 如无特殊说明,本站提供的所有pdf均为文字版(aka True PDF or Digitally Created PDF)。
  • 本站已经列出的所有图书均可以找到。
  • 收到PDF链接之后建议尽快下载或者保存到自己的百度网盘,防止链接过期失效。


扫描下方二维码添加微信号 bookyage 回复本书编号 246669 即可,我们会尽快(一般24小时之内)将本书PDF文件以百度网盘链接的形式发送给您。