3 ms·
I have a little bit of experience with PostgreSQL. Coming from MySQL background, I was pleasantly surprised how much abstraction you can build into your Postgr
by dexen 10y ago
I have a little bit of experience with PostgreSQL.
Coming from MySQL background, I was pleasantly surprised how much abstraction you can build into your PostgreSQL database itself. With just a few views and perhaps functions you can abstract away your actual data in clean and performant way, and thus enable use of such REST API without worrying too much about future schema change.
- ruslan_talpa 10y agoYou've just formulated one of the core concepts/techniques PostgREST relies on. You don't expose your core tables as an API, you expose views that extract data from your core tables, even if in the beginning those views are nothing more then "select * from some_table". As the api evolves, you are free to change the logic in those views without the need to touch your core tables
- Walkman 10y agoThat's actually a very good counter-argument against mine.