Tag feed

#materialized-views

37 posts0 followers

Explore Hashnode

Alternatives

Trending tags this week

PGPhil Grinhamphilgrinham.hashnode.devJun 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

0

RLRisingWave Labsrisingwave.comMay 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

0

YSYuhao Surisingwave.comMay 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

0

FSFahad Shahrisingwave.comApr 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...

0

FSFahad Shahrisingwave.comApr 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...

0

FSFahad Shahrisingwave.comApr 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...

0

FSFahad Shahrisingwave.comApr 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...

0

FSFahad Shahrisingwave.comApr 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

AE

FSFahad Shahrisingwave.comApr 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...

0

FSFahad Shahrisingwave.comApr 7 · 14 min read

Agentic Data Architecture: A SQL-First Implementation Guide

Introduction Search for "agentic data architecture" and you will find no shortage of material. Pyramid diagrams with three to five layers. Circles labeled "orchestration" pointing to other circles labeled "context." Frameworks with names like the Rea...

0

#materialized-views

Search Hashnode

#materialized-views

Explore Hashnode

Trending tags this week

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

Agentic Data Architecture: A SQL-First Implementation Guide