--- title: "#materialized-views articles | Hashnode" description: "Explore 38 articles tagged #materialized-views on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/materialized-views" --- Tag # #materialized-views 38 posts · 0 followers [Rayees Pasha](https://hashnode.com/@rayees) · [Oct 16](https://hashnode.com/posts/introducing-risingwave-3-1-smarter-lakehouse-integration-flexible-pipelines-and-more-powerful-sql/6ad1a7ce36f465c7c71dfc62) ### [Introducing RisingWave 3.1: Smarter Lakehouse Integration, Flexible Pipelines, and More Powerful SQL](https://risingwave.com/blog/introducing-risingwave-3-1-smarter-lakehouse-integration-flexible-pipelines-and-more-powerful-sql?utm_source=hashnode&utm_medium=feed) RisingWave 3.1 with native VARIANT support, enhanced Apache Iceberg integration, flexible materialized views, SQL improvements, and more. 5 min read · [risingwave.com](https://risingwave.com/blog/introducing-risingwave-3-1-smarter-lakehouse-integration-flexible-pipelines-and-more-powerful-sql?utm_source=hashnode&utm_medium=feed) [Phil Grinham](https://hashnode.com/@PhilGrinham) · [Jun 30](https://hashnode.com/posts/materialized-views-the-sweet-spot/6a453454fbfc9f1ee09e7f17) ### [Materialized Views: The Sweet Spot](https://philgrinham.hashnode.dev/materialized-views-the-sweet-spot?utm_source=hashnode&utm_medium=feed) The Inspiration I recently read an article from the always excellent Connor McDonald that I highly recommend where he provided a solution on how to maintain a materialized view that needs to be "up to 9 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/materialized-views-the-sweet-spot?utm_source=hashnode&utm_medium=feed) [RisingWave Labs](https://hashnode.com/@RisingWaveLabs) · [May 22](https://hashnode.com/posts/risingwave-zero-to-streaming-30-minutes/6a10ce4a02c892c4d530ceb1) ### [Zero to Streaming: RisingWave in 30 Minutes](https://risingwave.com/blog/risingwave-zero-to-streaming-30-minutes?utm_source=hashnode&utm_medium=feed) A self-contained beginner's tutorial. Install RisingWave with Docker, simulate a live event stream, build materialized views, and watch them update in real time. No Kafka, no setup tax. 8 min read · [risingwave.com](https://risingwave.com/blog/risingwave-zero-to-streaming-30-minutes?utm_source=hashnode&utm_medium=feed) [Yuhao Su](https://hashnode.com/@yuhao) · [May 22](https://hashnode.com/posts/risingwave-dbt-streaming-transformations/6a10c0d8029687802a67d608) ### [How to Use dbt with RisingWave for Streaming Transformations](https://risingwave.com/blog/risingwave-dbt-streaming-transformations?utm_source=hashnode&utm_medium=feed) Combine dbt's transformation framework with RisingWave streaming SQL to build testable, version-controlled, and always-fresh real-time data pipelines 9 min read · [risingwave.com](https://risingwave.com/blog/risingwave-dbt-streaming-transformations?utm_source=hashnode&utm_medium=feed) [Fahad Shah](https://hashnode.com/@fahadshah) · [Apr 8](https://hashnode.com/posts/streaming-sql-2026/69d5a018978cad6bb0ff25c1) ### [Streaming SQL in 2026: Materialized Views, Windows, and What Actually Works](https://risingwave.com/blog/streaming-sql-2026?utm_source=hashnode&utm_medium=feed) Streaming SQL has gone from research concept to production standard. In 2026, you can build real-time pipelines entirely in SQL -- but the syntax and semantics differ significantly from batch SQL. 24 min read · [risingwave.com](https://risingwave.com/blog/streaming-sql-2026?utm_source=hashnode&utm_medium=feed) [Fahad Shah](https://hashnode.com/@fahadshah) · [Apr 7](https://hashnode.com/posts/real-time-personalization-user-preferences/69d552a2f15d2525f68f1349) ### [Real-Time Personalization: Score User Preferences from Live Behavioral Data](https://risingwave.com/blog/real-time-personalization-user-preferences?utm_source=hashnode&utm_medium=feed) Batch-computed user profiles are always a step behind. This is how to maintain continuously updating preference scores so every page load gets a personalized experience based on what the user just did. 15 min read · [risingwave.com](https://risingwave.com/blog/real-time-personalization-user-preferences?utm_source=hashnode&utm_medium=feed) [Fahad Shah](https://hashnode.com/@fahadshah) · [Apr 7](https://hashnode.com/posts/real-time-content-recommendations-sql/69d5529eb1aa7b20b0f64c9c) ### [Real-Time Content Recommendations Without a Machine Learning Model](https://risingwave.com/blog/real-time-content-recommendations-sql?utm_source=hashnode&utm_medium=feed) You don't need a recommendation model to personalize content feeds. Trending topics, reading history, and tag similarity implemented in SQL outperform most batch ML pipelines for freshness. 15 min read · [risingwave.com](https://risingwave.com/blog/real-time-content-recommendations-sql?utm_source=hashnode&utm_medium=feed) [Fahad Shah](https://hashnode.com/@fahadshah) · [Apr 7](https://hashnode.com/posts/real-time-collaborative-filtering-sql/69d552941bb85072cf8838cb) ### [Real-Time Collaborative Filtering: Build User-Based and Item-Based Systems in SQL](https://risingwave.com/blog/real-time-collaborative-filtering-sql?utm_source=hashnode&utm_medium=feed) Collaborative filtering is traditionally a batch ML problem. With streaming materialized views, you can maintain item similarity and user cohort signals continuously in SQL -- no model training required. 19 min read · [risingwave.com](https://risingwave.com/blog/real-time-collaborative-filtering-sql?utm_source=hashnode&utm_medium=feed) [Fahad Shah](https://hashnode.com/@fahadshah) · [Apr 7](https://hashnode.com/posts/real-time-recommendation-system-sql/69d5528fd1653ade36128000) ### [How to Build a Real-Time Recommendation System with SQL](https://risingwave.com/blog/real-time-recommendation-system-sql?utm_source=hashnode&utm_medium=feed) Batch recommendation pipelines miss the purchase window. This is the complete SQL architecture for recommendations that update within seconds of each user action. 17 min read · [risingwave.com](https://risingwave.com/blog/real-time-recommendation-system-sql?utm_source=hashnode&utm_medium=feed) [Fahad Shah](https://hashnode.com/@fahadshah) · [Apr 7](https://hashnode.com/posts/ai-agents-real-time-data-1/69d53d42002ad788db3877c5) ### [Why AI Agents Need Real-Time Data (And How to Deliver It)](https://risingwave.com/blog/ai-agents-real-time-data-1?utm_source=hashnode&utm_medium=feed) AI agents make poor decisions on stale data. Learn how a streaming database delivers sub-second fresh context to your agents using plain SQL. 11 min read · [risingwave.com](https://risingwave.com/blog/ai-agents-real-time-data-1?utm_source=hashnode&utm_medium=feed) [3](https://hashnode.com/posts/ai-agents-real-time-data-1/69d53d42002ad788db3877c5)