Hello everyone, السلام عليكم و رحمة الله و بركاته
SQL (Structured Query Language) is an essential tool for managing and manipulating relational d...
For further actions, you may consider blocking this person and/or reporting abuse
Hi Bilel. Nice post! I’ve recently written a PostgreSQL book that covers advanced SQL, query planning, index design, and uses a Ruby on Rails app for examples and exercises.
After reading through your examples, I’ve realized we didn’t cover recursive CTEs (non recursive CTEs are covered) or lateral joins. I’ll save your post and link to as you introduce those topics nicely.
You did a great job of boiling down all of these topics into short descriptions with examples.
As you mentioned in Postgres we’ve got native materialized views that can be refreshed concurrently and indexed. In the extension ecosystem, there are even extensions to incrementally update materialized views.
Thanks for writing the post!
You are welcome, Thank you .
Great article, I just learned a bunch of new techniques! I only missed a mention to the use case of ANALYZE statement to update the statistics about the dataset, allowing optimization of WHERE clauses.
Very interresting informations
Awesome article. 👏🏽
Very well done. I've got some videos on YouTube on the same topic as well, and I agree with a lot of this!
Did you state a product anywhere or are you picking pure ANSI standard SQL ?
Looks like SQL Server to me.
standard SQL, i put some notes for mysql about materialized views
Extremely helpful
Good job 👏
Thanks very much.
But are this sql construct portable across all major relational databases because you only took notes of MySQL?
i took note for mysql because it doesn't support directly materialized views but postgres for example supports materialized views . It's more general than specific db .
Nice article!
Very helpful 💯
well done 💯
Great👍
Great