Tag

#materialized-views

38 posts0 followers

Explore Hashnode

Alternatives

Introducing RisingWave 3.1: Smarter Lakehouse Integration, Flexible Pipelines, and More Powerful SQL

RisingWave 3.1 with native VARIANT support, enhanced Apache Iceberg integration, flexible materialized views, SQL improvements, and more.

5 min readrisingwave.com

Phil GrinhamJun 30

Materialized Views: The Sweet Spot

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 readphilgrinham.hashnode.dev

RisingWave LabsMay 22

Zero to Streaming: RisingWave in 30 Minutes

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 readrisingwave.com

Yuhao SuMay 22

How to Use dbt with RisingWave for Streaming Transformations

Combine dbt's transformation framework with RisingWave streaming SQL to build testable, version-controlled, and always-fresh real-time data pipelines

9 min readrisingwave.com

Fahad ShahApr 8

Streaming SQL in 2026: Materialized Views, Windows, and What Actually Works

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 readrisingwave.com

Fahad ShahApr 7

Real-Time Personalization: Score User Preferences from Live Behavioral Data

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 readrisingwave.com

Fahad ShahApr 7

Real-Time Content Recommendations Without a Machine Learning Model

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 readrisingwave.com

Fahad ShahApr 7

Real-Time Collaborative Filtering: Build User-Based and Item-Based Systems in SQL

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 readrisingwave.com

Fahad ShahApr 7

How to Build a Real-Time Recommendation System with SQL

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 readrisingwave.com