Software Engineer, PostgreSQL and Ruby on Rails specialist, Author of "High Performance PostgreSQL for Rails" (PragProg.com). Find my site and social media accounts at: andyatkinson.com/social-media
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.
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 .