Tag

#materialized-views

38 posts0 followers

Explore Hashnode

Alternatives

Rayees PashaOct 16 · 5 min read

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

TL;DR RisingWave 3.1 makes real-time data processing more flexible, efficient, and lakehouse-ready. This release introduces several key enhancements: Native VARIANT Support: Process rich semi-structu

risingwave.com

Phil GrinhamJun 30 · 9 min read

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

philgrinham.hashnode.dev

RisingWave LabsMay 22 · 8 min read

Zero to Streaming: RisingWave in 30 Minutes

TL;DR: RisingWave is a PostgreSQL-compatible streaming database. This tutorial gets you from nothing to a working real-time pipeline in 30 minutes using only Docker and psql. You will simulate a trans

risingwave.com

Yuhao SuMay 22 · 9 min read

How to Use dbt with RisingWave for Streaming Transformations

TL;DR RisingWave has a dedicated dbt adapter called dbt-risingwave. Install it with pip install dbt-risingwave, point your profiles.yml at RisingWave's PostgreSQL-compatible endpoint, and use the mate

risingwave.com

Fahad ShahApr 7 · 14 min read

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

{ "@context": "https://schema.org", "@type": "FAQPage", "mainEntity": [ { "@type": "Question", "name": "What is real-time personalization?", "acceptedAnswer": { "@type": "Answer", "text": "Real-time persona...

risingwave.com

Fahad ShahApr 7 · 14 min read

Real-Time Content Recommendations Without a Machine Learning Model

{ "@context": "https://schema.org", "@type": "FAQPage", "mainEntity": [ { "@type": "Question", "name": "Can you build a content recommendation engine without machine learning?", "acceptedAnswer": { "@type": "Answer...

risingwave.com

Fahad ShahApr 7 · 18 min read

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

{ "@context": "https://schema.org", "@type": "FAQPage", "mainEntity": [ { "@type": "Question", "name": "What is collaborative filtering?", "acceptedAnswer": { "@type": "Answer", "text": "Collaborative filte...

risingwave.com

Fahad ShahApr 7 · 17 min read

How to Build a Real-Time Recommendation System with SQL

{ "@context": "https://schema.org", "@type": "FAQPage", "mainEntity": [ { "@type": "Question", "name": "What is a real-time recommendation system?", "acceptedAnswer": { "@type": "Answer", "text": "A real-ti...

risingwave.com

Fahad ShahApr 7 · 11 min read

Why AI Agents Need Real-Time Data (And How to Deliver It)

Introduction Your fraud detection agent flags a transaction as suspicious, but the customer already updated their shipping address ten minutes ago. Your support agent tells a customer that an item is in stock, but the last inventory sync ran at midni...

3 risingwave.com

Fahad ShahApr 7 · 10 min read

MCP Streaming Database: Connect AI Agents to Live Data with RisingWave

Introduction Your AI agent can write SQL. It can summarize text, reason about user intent, and call external APIs. But when a customer asks "Where is my order right now?", the agent hits a wall: the data it can access is hours old, trapped in a batch...

risingwave.com

Search Hashnode

Explore Hashnode

Trending tags this week

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

Materialized Views: The Sweet Spot

Zero to Streaming: RisingWave in 30 Minutes

How to Use dbt with RisingWave for Streaming Transformations

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

Real-Time Content Recommendations Without a Machine Learning Model

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

How to Build a Real-Time Recommendation System with SQL

Why AI Agents Need Real-Time Data (And How to Deliver It)

MCP Streaming Database: Connect AI Agents to Live Data with RisingWave