Introduction There are several ways to handle data in a microservice architecture, in this article we will cover the approach of having a separate database for each microservice. Prerequisites This article will build upon the concepts covered in the ...

Introduction [!WARNING] This demo includes examples for an unsupported version of Materialize (0.26.x). Materialize is a streaming database that takes data coming from different sources like Kafka, PostgreSQL, S3 buckets, and more and allows users ...

Introduction Event streams provide you with a way to send events to the client without having to reload the page. This is useful for things like updating the user interface in real-time changes are made to the database. Unlike traditional Long-pollin...

Introduction [!WARNING] This demo includes examples for an unsupported version of Materialize (0.26.x). This is a self-contained demo using Materialize to process data IoT devices data directly from a PostgreSQL server. The demo builds up on the Ho...

Introduction [!WARNING] This demo includes examples for an unsupported version of Materialize (0.26.x). This is a self-contained demo using Materialize. This demo shows you how to use dbt together with Materialize. For this demo, we are going to mo...

Introduction I have a few Raspberry Pi devices at home and I wanted to be able to collect the data from their temperature sensors on a regular interval and store that data in a Postgres database. Later on, I could use that data for some analytics tog...

Introduction [!WARNING] This demo includes examples for an unsupported version of Materialize (0.26.x). This is a self-contained demo using Materialize. This demo would show you how to use Materialize to join MySQL and Postgres in a live materializ...

Introduction If you have ever worked with MySQL and had to create your table structure, you have probably noticed that the DATETIME and TIMESTAMP data types are quite similar at a first glance as they have a lot of similarities. In this tutorial, we ...

Introduction [!WARNING] This demo includes examples for an unsupported version of Materialize (0.26.x). In this tutorial, we are going to build a web application using AdonisJS and integrate it with Materialize to create a real-time dashboard based...

Introduction In this quick tutorial, you will learn how to find the duplicate values in a SQL table with a single SQL query. Let's say that we have a table called users with the following data: SELECT username,email FROM users; +----------+----------...