News for hackers. Stuff that matters.

A comment on Ask HN: Self-taught webdev with lots of free time. What should I learn?. Parent comment

Re:Ask HN: Self-taught webdev with lots of free time. What s... by steve-chavez on Thursday August 13, 2020 @11:16AM (#24144213)
Don't forget that the database is not only tables. Abstraction can be done at the SQL level with views.

With views you can maintain backwards compatibility despite migrations happening. No need to change your front-end.

Check this section of the PostgREST docs for more details:

http://postgrest.org/en/v7.0.0/schema_structure.html#schema-...

[ Parent | on HN ]
Re:Ask HN: Self-taught webdev with lots of free time. What s... by ahpearce on Friday August 14, 2020 @09:13AM (#24157457)
Yeah, views can definitely fit certain use cases. I've just never encountered cases where I eventually don't need to /do something else/ in between those two layers. Granted I'm doing a lot of systems integration on a lot of complex legacy infrastructure, so that might just be me!
[ Parent | on HN ]