Difference between scaling horizontally and vertically for databases?

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

5

Bobby Iliev · 1 year ago

Simulating Streaming Data for Fraud Detection with Datagen CLI

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

1

Cody Jenson · 1 year ago

How to output the raw SQL query in Laravel

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

2

Bobby Iliev · 2 years ago

How to show all tables in PostgreSQL?

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

8

Bobby Iliev · 2 years ago

How to flatten JSON array in SQL using jsonb_array_elements?

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

3

Bobby Iliev · 2 years ago

Building a live chart with Deno, WebSockets, Chart.js and Materialize

Introduction ❗️ This demo includes examples for an unsupported version of Materialize (0.26.x) ❗️ This is a self-contained example of a real-time chart powered by Deno, Web Sockets, Char...

6

Bobby Iliev · 2 years ago

How to use Materialize with DigitalOcean Serverless Functions

Introduction ❗️ This demo includes examples for an unsupported version of Materialize (0.26.x) ❗️ Materialize is a streaming database for real-time analytics. It was launched in 2019 to...

4

Bobby Iliev · 2 years ago

Python Script to Copy The Content of a Materialized View to S3

Introduction ❗️ This demo includes examples for an unsupported version of Materialize (0.26.x) ❗️ Materialize is a streaming database for real-time analytics. It was launched in 2019 to...

6

Bobby Iliev · 2 years ago

Using Deno and Materialize to send notifications in real-time

Introduction ❗️ This demo includes examples for an unsupported version of Materialize (0.26.x) ❗️ This is a self-contained example of a real-time notification app with Deno, Materialize...

7

Bobby Iliev · 2 years ago

Serverless Node.js URL Shortener App powered by Upstash Kafka and Materialize

❗️ This demo includes examples for an unsupported version of Materialize (0.26.x) ❗️ This is a simple Node.js URL shortener app that uses Cloudflare Workers. The app is powered by Cloudf...

8

Bobby Iliev · 2 years ago

Using Materialize and Airbyte with MySQL and Redpanda/Kafka

Introduction ❗️ 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 Mat...

5

Bobby Iliev · 2 years ago

How to manage your Materialize migrations with Laravel Zero?

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

4

Bobby Iliev · 2 years ago

Blue-green deployments with Materialize

Introduction [!WARNING] This demo includes examples for an unsupported version of Materialize (0.26.x). For a more up to date guide checkout the documentation here: Materialize Blue/Green...

3

Bobby Iliev · 2 years ago

How to use 'IF' in 'SELECT' SQL statements?

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

11

Bobby Iliev · 2 years ago

How to connect Laravel to Materialize and build a live dashboard?

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

2

Bobby Iliev · 2 years ago

How to create a simple event streaming in Laravel?

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

6

Bobby Iliev · 2 years ago

How to use dbt with Materialize and Redpanda

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

5

Bobby Iliev · 2 years ago

How to join MySQL and Postgres in a live materialized view

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

4

Bobby Iliev · 2 years ago

What is the difference between DATETIME and TIMESTAMP data type in MySQL?

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

4

Bobby Iliev · 2 years ago

Building a real-time web application with Materialize and AdonisJS

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

10

Bobby Iliev · 2 years ago

How to Find Duplicate Values in a SQL Table?

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

7

Bobby Iliev · 2 years ago

What is the difference between UNION and UNION ALL in SQL?

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

4

Bobby Iliev · 2 years ago

Learn Materialize by running streaming SQL on your nginx logs

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

7

Bobby Iliev · 2 years ago

What is the difference between JOIN and INNER JOIN in SQL?

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

8

Bobby Iliev · 2 years ago

How to import an SQL file using the command line in MySQL?

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

6

Bobby Iliev · 2 years ago

How to Add a Default Value to an Existing Column in MySQL

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

5

Bobby Iliev · 3 years ago

The top 10 Linux Commands that Every Data Engineer Should Know

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

5

Bobby Iliev · 3 years ago

The Data Engineer Roadmap 🗺

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

7

Bobby Iliev · 3 years ago

🚀 The Missing SQL Basics Crash Course

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

8

Bobby Iliev · 3 years ago

How to limit the result with Laravel Eloquent?

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

9

Tails

Static

MarkdownX

Pines

Wave

Designer

Help & Support

Sponsorships

Terms of Service

Sql

Difference between scaling horizontally and vertically for databases?

Simulating Streaming Data for Fraud Detection with Datagen CLI

How to output the raw SQL query in Laravel

How to show all tables in PostgreSQL?

How to flatten JSON array in SQL using jsonb_array_elements?

Building a live chart with Deno, WebSockets, Chart.js and Materialize

How to use Materialize with DigitalOcean Serverless Functions

Python Script to Copy The Content of a Materialized View to S3

Using Deno and Materialize to send notifications in real-time

Serverless Node.js URL Shortener App powered by Upstash Kafka and Materialize

Using Materialize and Airbyte with MySQL and Redpanda/Kafka

How to manage your Materialize migrations with Laravel Zero?

Blue-green deployments with Materialize

How to use 'IF' in 'SELECT' SQL statements?

How to connect Laravel to Materialize and build a live dashboard?

How to create a simple event streaming in Laravel?

How to use dbt with Materialize and Redpanda

How to join MySQL and Postgres in a live materialized view

What is the difference between DATETIME and TIMESTAMP data type in MySQL?

Building a real-time web application with Materialize and AdonisJS

How to Find Duplicate Values in a SQL Table?

What is the difference between UNION and UNION ALL in SQL?

Learn Materialize by running streaming SQL on your nginx logs

What is the difference between JOIN and INNER JOIN in SQL?

How to import an SQL file using the command line in MySQL?

How to Add a Default Value to an Existing Column in MySQL

The top 10 Linux Commands that Every Data Engineer Should Know

The Data Engineer Roadmap 🗺

🚀 The Missing SQL Basics Crash Course

How to limit the result with Laravel Eloquent?

Tails

Static

MarkdownX

Pines

Wave

Designer

Join 122,522 other developers as we learn, build, and grow together.

Community

Rewards

Resources

Meet the Team

Help & Support

Sponsorships

Terms of Service

Sql

Difference between scaling horizontally and vertically for databases?

Simulating Streaming Data for Fraud Detection with Datagen CLI

How to output the raw SQL query in Laravel

How to show all tables in PostgreSQL?

How to flatten JSON array in SQL using jsonb_array_elements?

Building a live chart with Deno, WebSockets, Chart.js and Materialize

How to use Materialize with DigitalOcean Serverless Functions

Python Script to Copy The Content of a Materialized View to S3

Using Deno and Materialize to send notifications in real-time

Serverless Node.js URL Shortener App powered by Upstash Kafka and Materialize

Using Materialize and Airbyte with MySQL and Redpanda/Kafka

How to manage your Materialize migrations with Laravel Zero?

Blue-green deployments with Materialize

How to use 'IF' in 'SELECT' SQL statements?

How to connect Laravel to Materialize and build a live dashboard?

How to create a simple event streaming in Laravel?

How to use dbt with Materialize and Redpanda

How to join MySQL and Postgres in a live materialized view

What is the difference between DATETIME and TIMESTAMP data type in MySQL?

Building a real-time web application with Materialize and AdonisJS

How to Find Duplicate Values in a SQL Table?

What is the difference between UNION and UNION ALL in SQL?

Learn Materialize by running streaming SQL on your nginx logs

What is the difference between JOIN and INNER JOIN in SQL?

How to import an SQL file using the command line in MySQL?

How to Add a Default Value to an Existing Column in MySQL

The top 10 Linux Commands that Every Data Engineer Should Know

The Data Engineer Roadmap 🗺

🚀 The Missing SQL Basics Crash Course

How to limit the result with Laravel Eloquent?