Book

Developing Modern Database Applications with PostgreSQL

This book is divided into two parts with the first helping you to build advanced and scalable PostgreSQL apps. The second part enables you to administer them using DevOps. All the projects in this book will be demonstrated via the use of a small banking application for managing ATM machine locations in a typical city.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

14h40m

Language

English

About Book

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.

Book content

chapters 14h40m total length

Introduction to PostgreSQL Development and Administration

Setting up a PostgreSQL RDS for ATM Machines

Using PostgreSQL and Node.js for Banking Transactions

Managing Bank ATM locations using PostgreSQL and Django

Creating a Geospatial Database using PostGIS and PostgreSQL

Managing Banking Transactions using PostgREST

PostgreSQL with DevOps for Continuous Delivery

PostgreSQL High Availability Clusters

High-Performance Team Dashboards Using PostgreSQL and New Relic

Testing the Performance of Our Banking App with PGBench and JMeter

Test Frameworks for PostgreSQL

Appendix - PostgreSQL among the Other Current Clouds

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required