Introduction In some cases, you might want to choose the output value based on column values directly in your SQL statement. In this article, we will explain how to use the CASE expression in SELECT SQL statements. We will also explain how to use an ...

Introduction In this guide, we will walk you through how to use Laravel WebSockets. We will be using the Laravel WebSockets package which is a great replacement for Pusher. The Laravel WebSockets package emulates the Pusher API and allows you to easi...

Introduction Server-sent events (SSE) is a way to send data to the browser without reloading the page. This allows you to use streaming data and build real-time applications that can be used in a variety of scenarios. FastAPI is a Python framework th...

Introduction This is a self-contained demo of FastAPI and Materialize. This demo project contains the following components: FastAPI: A fast, modern, and feature-rich framework for building APIs with Python. Redpanda: Kafka® compatible event stream...

Introduction Redpanda is a Kafka-compatible event stream platform written in C++. It comes with a simple command-line interface called rpk that lets you interact with the platform. In this tutorial, we will be using the rpk command-line interface to ...

Introduction Laravel is a PHP framework for web development. It was created by Taylor Otwell and was initially released as an open-source project in June 2011. Since its initial release, Laravel has grown to become one of the most popular PHP web fra...

Introduction Laravel was created by Taylor Otwell and was initially released in June 2011. It is an open-source PHP framework that is used to build web applications. It is without a doubt the most popular PHP framework and even one of the most popula...

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 Materialize is a streaming database that takes data coming from different sources like Kafka, PostgreSQL, S3 buckets, and more and allows users to write views that aggregate/materialize that data and let you query those views using pure ...

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