News for hackers. Stuff that matters.

A comment on SQL: One of the most valuable skills. Parent comment

Re:SQL: One of the most valuable skills by jbverschoor on Wednesday February 13, 2019 @10:46AM (#19153877)
What's the difference between that and a non sql approach?

Writing a program that makes a temporary table somewhere, and if there's a mistake you have to start all over again?

[ Parent | on HN ]
Re:SQL: One of the most valuable skills by magicalhippo on Wednesday February 13, 2019 @06:16PM (#19158102)
Well, for immediate refresh materialized views, how do you keep your non-sql solution up to date?

For manual refresh, I agree, either non-sql or just plain temp tables is a decent alternative. In our case the views do a lot of joins and subqueries, so we've mostly used temp tables.

[ Parent | on HN ]