Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Developing Modern Database Applications with PostgreSQL Use the highly available and object-relational PostgreSQL to build scalable and reliable apps

Product type Paperback

Published in Aug 2021

Publisher Packt

ISBN-13 9781838648145

Length 440 pages

Edition 1st Edition

Languages

Python

Tools

PostgreSQL

Concepts

Database Administration

Authors (2):

Marcelo Diaz

Quan Ha Le

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1 - Introducing PostgreSQL Development and Administration

2. Introduction to PostgreSQL Development and Administration FREE CHAPTER

3. Section 2 - Development in PostgreSQL

4. Setting Up a PostgreSQL RDS for ATMs

5. Using PostgreSQL and Node.js for Banking Transactions

6. Managing Bank ATM Locations Using PostgreSQL and Django

7. Creating a Geospatial Database Using PostGIS and PostgreSQL

8. Managing Banking Transactions using PostgREST

9. Section 3 - Administration in PostgreSQL

10. PostgreSQL with DevOps for Continuous Delivery

11. PostgreSQL High Availability Clusters

12. High-Performance Team Dashboards Using PostgreSQL and New Relic

13. Testing the Performance of Our Banking App with PGBench and JMeter

14. Test Frameworks for PostgreSQL

15. Other Books You May Enjoy

Leave a review - let other readers know what you think

APPENDIX - PostgreSQL among the Other Current Clouds

PostgREST on TimescaleDB

TimescaleDB is an open source database for time series data; we first heard about TimescaleDB when we investigated standalone PostgREST because it had TimescaleDB as a built-in extension. Obviously, PostgREST is also able to create a timing API for TimescaleDB.

Unfortunately, the PostgreSQL RDS does not support TimescaleDB. If we would like to install TimescaleDB for AWS, we will have to use the recently invented Timescale Cloud to connect to AWS. Timescale Cloud can support TimescaleDB for AWS:

Please visit the following link to sign up for a new user account at Timescale Cloud: https://www.timescale.com/cloud-signup.
Please enter your full name, email address, and password for Timescale Cloud:

Figure 6.17 – Registering for a new Timescale Cloud user account

Please press the Create an account button, which will lead you to the Email confirmed screen:

Figure 6.18 – Email confirmed screen

Please find the Timescale...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (2)

Dr. Quan Ha Le graduated with a Ph.D. in computer science from the Queen's University of Belfast, United Kingdom, in 2005. Since his Ph.D. graduation, he has been working as a PostgreSQL database administrator all over Alberta and Ontario, Canada, until now. From 2008 to 2019, Dr. Le Quan Ha administered, designed, and developed 24 small, medium, large, and huge PostgreSQL databases in Canada. Since 2016, after writing a good publication on PostgreSQL database clusters on clouds, he has been a member of the United States PostgreSQL Association (PgUS) in New York City. Dr. Le Quan Ha has also been a board member of the PgUS Diversity committee since 2018.

See other products by Le

Diaz

Marcelo Diaz is a software engineer with more than 15 years of experience, with a special focus on PostgreSQL. He is passionate about open source software and has promoted its application in critical and high-demand environments where he has worked as a software developer and consultant for both private and public companies. He currently works very happily at Cybertec and as a technical reviewer for Packt Publishing. He enjoys spending his leisure time with his daughter, Malvina, and his wife, Romina. He also likes playing football.

See other products by Diaz