Providing a RESTful API interface for PostgreSQL

It is convenient to provide an interface to share data commonly used by several applications via a RESTful API. Let's assume we have a table that is 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 ...

Get Learning PostgreSQL 10 - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.