Challenges students face when learning to work with relational databases and SQL

Re:Challenges students face when learning to work with relat... by eyelidlessness on Sunday August 29, 2021 @11:01PM (#28352448)

Be careful with blanket CTE recommendations. They tend to deoptimize with writes in really surprising ways. If you’re just reading data, they’re great.

[ Parent | on HN ]

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 ]