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 @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 ]