Introduction When your application or website starts to receive more traffic, you'll need to think about how to scale your database to handle the additional load. There are two main ways to...

Introduction Building and testing a real-time fraud detection application requires a continuous stream of realistic data. But generating that data can be a challenge. That's why we recently...

Laravel does a lot of magic behind the scenes when fetching data from the database. Luckily there are some really easy ways to get the raw SQL query so that you can understand everything tha...

Introduction PostgreSQL is a powerful, open-source database system. It is a relational database management system (RDBMS) based on the SQL language. PostgreSQL is one of the most popular dat...

Introduction The jsonb_array_elements function returns a set of rows, one for each element of the input array. The input array can be a top-level array or a nested array. In this tutorial, w...

Introduction This is a self-contained example of a real-time chart powered by Deno, Web Sockets, Chart.js, and Materialize. Deno is a simple and secure runtime for JavaScript and TypeScript...

Introduction Materialize is a streaming database for real-time analytics. It was launched in 2019 to address the growing need for the ability to build real-time applications easily and effic...

Introduction Materialize is a streaming database for real-time analytics. It was launched in 2019 to address the growing need for the ability to build real-time applications easily and effic...

Introduction This is a self-contained example of a real-time notification app with Deno, Materialize and Discord. Deno is a simple and secure runtime for JavaScript and TypeScript that uses...

This is a simple Node.js URL shortener app that uses Cloudflare Workers. The app is powered by Cloudflare Workers and Upstash Redis for storing data and Kafka for storing the click events al...

Introduction This is a self-contained demo using Materialize. This demo would show you how to use Materialize with Airbyte to create a live dashboard. For this demo, we are going to monitor...

Introduction ❗️ This demo includes examples for an unsupported version of Materialize (0.26.x). ❗️ Managing your schema migrations is essential for any application. In this tutorial, we...

Introduction Minimizing downtime during any deployment is a key part of any successful deployment strategy. There are many ways to achieve this, and blue-green deployments are one of them. U...

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

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

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

Introduction 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 monitor the reviews left by users o...

Introduction 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 materialized view. For this demo, we are go...

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

Introduction 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 on streaming data using standard...

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

Introduction If you've ever used SQL, you probably know that UNIONs can be quite confusing at first. In this quick post we are going to learn what the difference between UNION and UNION ALL...

Introduction In this tutorial, I will show you how Materialize works by using it to run SQL queries on continuously produced nginx logs. By the end of the tutorial, you will have a better id...

Introduction If you've ever used SQL, you probably know that JOINs can be very confusing. In this quick post we are going to learn what the difference between JOIN and INNER JOIN is! Differe...

Introduction In some cases if you have a really large .sql file, it is best to import it via the command line. You might need to do this in case that you are using a tool like PHPmyAdmin, wh...

Introduction In this quick tutorial, you will learn how to add a default value to an existing column in MySQL. Prerequisites You always need to be careful, when changing the structure of an...

Introduction No matter if you are a data analyst or a system administrator when working with unstructured files in Linux there are a set of commands that would help you a lot in your daily t...

Introduction With the ever growing data volumes and demands, the data engineering career has been one of the fastest growing jobs for the past few years. According to the 2021 Stack Overflow...

Introduction No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you will most likely have to use SQL at some point in your career. The guide is suitable fo...

Introduction The Eloquent ORM included with Laravel provides you with an easy way of interacting with your database. This simplifies all CRUD (Create, read, update, and delete) operations an...