Learning PostgreSQL 11 - Third Edition

RESTful APIs using PostgreSQL

It's convenient to provide an interface to share data that's commonly used by several applications via a RESTful API. Let's assume we have a table that's used by several applications; one way to make these applications aware of that table is to create a Data Access Object (DAO) for that table, wrap it in a library, and then reuse that library in those applications. This approach has some disadvantages, such as resolving library dependency and mismatching library versions. Also, deploying new versions of a library requires a lot of effort because applications using that library need to be compiled, tested, and deployed.

The advantage of providing a RESTful API interface for the PostgreSQL database is to allow ...