book

Developing Modern Database Applications with PostgreSQL

by Quan Ha Le, Marcelo Diaz

August 2021

Intermediate to advanced

440 pages

7h 54m

English

Packt Publishing

Read now

Unlock full access

Developing Modern Database Applications with PostgreSQL
About the authorsAbout the reviewerPackt is searching for authors like you
Why subscribe?
Who this book is forWhat this book coversTo get the most out of this bookDownload the example code filesDownload the color imagesConventions usedGet in touchReviews
An overview of PostgreSQL developmentWhat is DBaaS?The development of PostgreSQL by various environmentsFeatures of PostgreSQL with NodeJSFeatures of PostgreSQL with PythonPostGIS spatial extensionThe PostgREST RESTful API for PostgreSQL databasesAn overview of PostgreSQL administrationThe PostgreSQL architectureShared memoryPostgreSQL autovacuumThe PostgreSQL writer and checkpointerPostgreSQL process typesManaging HA in PostgreSQLBenchmarking PostgreSQL performanceKey performance factors in PostgreSQLUsing pgbench for PostgreSQL benchmarkingMonitoring PostgreSQL databasesThe DevOps environment for PostgreSQLPostgreSQL testing frameworksSummary
Technical requirementsAn overview of the projectCreating a PostgreSQL RDS with AWSCreating a PostgreSQL databaseEditing the RDS security groupConnecting to a PostgreSQL database instanceThe pgAdmin serverThe ATM locations tableCreating a PostgreSQL database snapshotDeleting a PostgreSQL database instanceRestoring data from a PostgreSQL database snapshotPoint-in-time recovery for PostgreSQLSummary
Technical requirementsSetting up a Node.js projectInstalling Node.jsRESTful web servicesSetting up PostgreSQL for Node.jsWorking with the server side: routesWorking with the client side: AngularCreating an Angular viewAngular app refactoringAutomated testing with Mocha and ChaiSummary

Technical requirementsSetting up a Django projectInstalling Python 3Creating a virtual environmentInstalling DjangoCreating a Django projectCreating the ATM appDjango database settings with PostgreSQLDatabase models in DjangoMigrating the databaseUnderstanding the Django user interface – admin, views, templates, and URLsMaking the atmapp modifiable inside the adminExploring the free admin functionalitySummary
Technical requirementsInstalling PostGIS for RDS on AWSImporting spatial data files into PostgreSQLSetting up QGISLoading spatial data using QGISExecuting PostGIS queriesOrdering ATM locations by distance from the Brooklyn BridgeFinding ATM locations within 1 kilometer of Times SquareSummary
Technical requirementsIntroduction to PostgRESTUsing DockerInstalling standalone PostgRESTCreating a PostgREST API schema on an RDS (AWS)Executing PostgRESTAdding a trusted userCreating a PostgREST tokenPostgREST administrationPostgREST on TimescaleDBSummary
Technical requirementsSetting up PostgreSQL using Vagrant and VirtualBoxInstalling VirtualBoxInstalling VagrantSelecting a Vagrant box Spinning up Ubuntu server 18.04 with Vagrant Creating the Puppet module for PostgreSQLWorking with Jenkins and PostgreSQLCreating an Ansible playbook for PostgreSQLManaging PostgreSQL by TerraformSummary
Technical requirementsSetting up streaming replication on PostgreSQLSetting up a PostgreSQL HA cluster through the Heimdall data proxy Heimdall installation by DockerHeimdall Webapp and Wizard configurationTesting load balancing and high availabilitySummary
Technical requirementsSigning up for and installing New RelicDefining PostgreSQL role permissionsConfiguring New Relic for PostgreSQLAdding new metric data for PostgreSQLInfrastructure inventory data collectionSummary
Technical requirementsHow to benchmark PostgreSQL performancepgbench 1 – Creating and initializing a benchmark databasepgbench 2 – Running a baseline pgbench testpgbench 3 – Creating and testing a connection poolJMeter setupJMeter for AWS PostgreSQL RDSSummary
Technical requirementsMaking unit tests with pgTAPSetting up pgTAP for PostgreSQL RDSpgTAP test examplesUninstalling pgTAP for PostgreSQL RDSMaking unit tests in a simple way with PG_UnitSetting up PGUnit for PostgreSQL RDSPGUnit test examplesUninstalling PGUnit for PostgreSQL RDSPGUnit – same name but a different approachSetting up simple pgunit for PostgreSQL RDSSimple pgunit test examplesUninstalling simple pgunit for PostgreSQL RDSTesting with Python – TestgresSetting up Testgres for PostgreSQLTestgres test examplesUninstalling Testgres for PostgreSQL RDSSummary
Technical requirementsGoogle Cloud SQLCreating an instancepgAdmin connection for Google CloudMicrosoft Azure for PostgreSQLCreating an Azure database for the PostgreSQL serverGetting an Azure resource connection for pgAdminHeroku PostgresCreating a Heroku appCreating a Heroku PostgreSQL databaseConnecting Heroku PostgreSQL using pgAdminEnterpriseDB cloud databaseCreating a PostgreSQL cluster Using pgAdmin to connect to EDB PostgreSQLSummary
Leave a review - let other readers know what you think

Overview

In "Developing Modern Database Applications with PostgreSQL", you will master the art of building database applications with the highly available and scalable PostgreSQL. Walk through a series of real-world projects that fully explore both the developmental and administrative aspects of PostgreSQL, all tied together through the example of a banking application.

What this Book will help me do

Set up high-availability PostgreSQL clusters using modern best practices.
Monitor and tune database performance to handle enterprise-level workloads seamlessly.
Automate testing and implement test-driven development strategies for robust applications.
Leverage PostgreSQL along with DevOps pipelines to deploy applications on cloud platforms.
Develop APIs and geospatial databases using popular tools like PostgREST and PostGIS.

Author(s)

The authors of this book, None Le and None Diaz, are experienced professionals in database technologies and software development. With a passion for PostgreSQL and its applications in modern computing, they bring a wealth of expertise and a practical approach to this book. Their methods focus on real-world applicability, ensuring that readers gain hands-on skills and practical knowledge.

Who is it for?

This book is perfect for database developers, administrators, and architects who want to advance their expertise in PostgreSQL. It is also suitable for software engineers and IT professionals aiming to tackle end-to-end database development projects. A basic knowledge of PostgreSQL and Linux will help you dive into the hands-on projects easily. If you're looking to take your PostgreSQL skills to the next level, this book is for you.