What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

PostgreSQL is an object-relational database management system (ORDBMS) based on the INGRES (INteractive Graphics REtrieval System) package, which was developed at the University of California, Berkeley. The POSTGRES (Post Ingres) project started in 1985, and version 1 was released to a small number of external users in June of 1989. Now, with more than 20 years of development, PostgreSQL has become the most advanced open source database, available all over the world.

This chapter 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 NodeJS 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. We will utilize DevOps through the setting up of PostgreSQL high availability (HA) clusters. We will also set up New Relic to monitor a PostgreSQL database, carry out performance tests on a PostgreSQL database with PGBench and JMeter, and use PostgreSQL testing frameworks.

In this chapter, we will cover the following main topics:

An overview of PostgreSQL development
An overview of PostgreSQL administration

Key benefits

Build real-world enterprise database management systems using Postgres 12 features

Explore the development, administrative and security aspects of PostgreSQL 12

Implement best practices from industry experts to build powerful database applications

Description

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 the 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 like 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 as per your organization's needs.

Who is this book 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 you will learn

Set up high availability PostgreSQL database clusters in the same containment, a cross-containment, and on the cloud

Monitor the performance of a PostgreSQL database

Create automated unit tests and implement test-driven development for a PostgreSQL database

Develop PostgreSQL apps on cloud platforms using DevOps with Python and Node.js

Write robust APIs for PostgreSQL databases using Python programming, Node.js, and PostgREST

Create a geospatial database using PostGIS and PostgreSQL

Implement automatic configuration by Ansible and Terraform for Postgres

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

zł177.99

Developing Modern Database Applications with PostgreSQL

zł197.99

zł197.99

Total zł 573.97

Filter reviews by

All

Amazon verified reviews

filippos Sep 14, 2021

This book is trying to bridge the gap between postgres/devops/application engineers and developers and it succesfully does so as you can actually build a whole application just by following the recipes on it. Initially you will create an RDS instance and then it's time for the application side where Node.js/django/postgis or even you own APIs will be explained in detail. At this point you need to make sure you can re-deploy your instance if needed and build a resilient infrastructure. Here notions like automation (jenkins,ansible,puppet,terraform etc) are in the first place. After this is completed, it's time for monitoring and dashboards. Finally some performance testing to make sure your app performs as expected are required and also some testing to QA purposes. I was amazed by how much content a book of 400 pages can include and by how reading chapter after chapter you are able to get all this content in the proper order, exactly as it would be used in a real life scenario. It's obvious that the authors have a lot of experience in the field. Reading from a postgres engineer's view i gained a lot of insight on how the app side of things work. I am sure next time i will have to debug some issue i will understand much better how each part of the system works individually but also a whole. If i could make a small suggestion i would have liked a little more info/examples on the postgis chapter. However,it's a great book overall and it's highly recommended for anyone working directly or indirectly with postgres.

Amazon Verified review

Sai Aug 16, 2021

This is a well written book, it certainly assumes the reader has a certain level of understanding of the topics. Most books tend to be from an academic standpoint but this one doesn't and thats what I loved about it, if you are a DBA , it is a must read ! For developers , it give a pretty good understanding of the use case and implementation principles.

Anurag Oct 25, 2021

This book is for anyone who is looking to get their hands dirty on PostgreSQL and get up to the speed quickly. In today's world, technology is changing so fast that it is sometimes intimidating for the new starters in any given area. Lack of information and too much information both are counter productive. Author did a great job by providing the right content needed to make any projects working. What I liked most about this book is the approach author used to explain different concepts by using mini projects on different platforms and technology. Given the popularity of cloud databases, author also covered in detail about AWS RDS databases and examples of available extensions. In conclusion, this book is helpful at the each phase of software development life cycle and that is why it useful to everyone irrespective of their role. DBA, developer, tester and technical leaders, no matter what is your role but if you are new to PostgreSQL and exploring to use it in your applications then this book is for you.

Rafayel Aug 16, 2021

As a PostgreSQL DBA, I can claim that the book is well written and has interesting implementations of PostgreSQL. This book is not for beginners. It requires the reader to have basic knowledge and some experience in PostgreSQL administration, ops, scripting etc.What is particularly good about this book is that it's written based on real practice. It's not an academic book coming from PostgreSQL's documentation and about how things should work.As a DBA, I would have liked to see more examples of best practices. I would have liked to read about security as well. In this book I didn't find any security related chapters and I think it is one of the most important aspects in modern applications.Overall, I think the book is for developers, who need to learn more about PostgreSQL implementation's.

Joseph Oct 22, 2021

This is a nicely written book that covers a lot of areas pertaining to application development alongside the concepts of provisioning and managing the PostgreSQL database as backend. Some of the topics covered would be digestible for developers with some experience rather than newbies. The step-by-step instructions for the sample projects are appreciable.

Developing Modern Database Applications with PostgreSQL: Use the highly available and object-relational PostgreSQL to build scalable and reliable apps

What do you get with eBook?