News for hackers. Stuff that matters.

A comment on Challenges students face when learning to work with relational databases and SQL. Parent comment

Re:Challenges students face when learning to work with relat... by hobs on Sunday August 29, 2021 @11:34PM (#28352580)
I would still say they are not great as most engines just... write your sql out, instead of saving/memoizing anything.
[ Parent | on HN ]
Re:Challenges students face when learning to work with relat... by eyelidlessness on Monday August 30, 2021 @12:18AM (#28352779)
All of my experience here is with Postgres, where (in recent versions) read-only CTEs are basically temporary views with all the built in optimizations that come from that.
[ Parent | on HN ]