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 Thaxll on Wednesday August 12, 2020 @10:40AM (#24132471)
If you're learning backend services, don't start by things like postgREST, it's just bad habbit, would be better to start by the basis with API servers / DB ect ...
[ Parent | on HN ]
Re:Ask HN: Self-taught webdev with lots of free time. What s... by emteycz on Wednesday August 12, 2020 @11:05AM (#24132763)
As a seasoned TypeScript backend/fullstack developer I don't understand

- why is it such a bad tool, and if it is because of the tool and not the concept, it seems possible it will be fixed in the future

- why is it a bad habit; I consider the boilerplate CRUD code I write to be a bad habit that I should've automated years ago, and that's exactly what PostgREST does

- why can't you learn the basics of API services and databases with PostgREST

[ Parent | on HN ]
Re:Ask HN: Self-taught webdev with lots of free time. What s... by Thaxll on Wednesday August 12, 2020 @11:16AM (#24132883)
It's a bad habit because of separation of concerns.
[ Parent | on HN ]
Re:Ask HN: Self-taught webdev with lots of free time. What s... by emteycz on Wednesday August 12, 2020 @11:18AM (#24132896)
You're not forced to write your app code in the DB as SQL procedures, you can also write TS or whatever else and use it next to PostgREST.
[ Parent | on HN ]
Re:Ask HN: Self-taught webdev with lots of free time. What s... by steve-chavez on Wednesday August 12, 2020 @01:15PM (#24134281)
Check this thread[1] for a previous discussion about "separation of concerns" and PostgREST.

tl;dr: business logic can be done with views/sps on an isolated schema. More layers makes the overall OLTP system less performant and harder to scale.

[1]: https://news.ycombinator.com/item?id=21438307

[ Parent | on HN ]