REST API for any Postgres database

Posted by danskeren on Wednesday November 17, 2021 @05:35PM
from the postgrest.org dept.

( 5 comments | 38 points | on HN )

Re:REST API for any Postgres database by misterpurple45 on Thursday November 18, 2021 @02:47AM (#29263100)

This is very seductive, but what happens when I need to refactor the database? Do all my API consumers just have to deal with a new interface?

[ Parent | on HN ]

Re:REST API for any Postgres database by lf-non on Thursday November 18, 2021 @03:48AM (#29263452)

Yes, A popular convention when using such tools is to use views for any tables that may change, and then treat those views as public interface.

So, when you refactor the underlying, you can also update your view definition so that the interface remains the same.

[ Parent | on HN ]

Re:REST API for any Postgres database by typingmonkey on Wednesday November 17, 2021 @09:10PM (#29261300)

Is it possible to also expose a websocket that emits changes?

[ Parent | on HN ]

Re:REST API for any Postgres database by killingtime74 on Wednesday November 17, 2021 @11:12PM (#29261909)

[ Parent | on HN ]

Re:REST API for any Postgres database by futhey on Wednesday November 17, 2021 @10:41PM (#29261751)

Looks neat. Love the name!

[ Parent | on HN ]