Since various elements of the Inspector backend rely on Laravel, I worked a lot with the ORM component myself, and its Eager Loading features. The tradeoff in using an ORM always remains tre...

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

In the project development sometimes we need to display random data on Frontend that time we need to fetch random records from the database to display random records on the frontend. In Lara...

Laravel is a free, open-source PHP framework, created by Taylor Otwell. It follows a Model-View-Controller (MVC) design pattern. Laravel reuses the existing components of different framewor...

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

Supabase? The open-source Firebase alternative?! This is an Extra Ordinary Claim because it requires Extra Ordinary Evidence "Supabase VS Firebase" Supabase VS Firebase 1. Features...

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

Introduction This is a self-contained demo using Materialize to process orders and display the delivery status and coordinates in real-time. Prerequisites Before you get started, you need to...

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

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

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

What is mongo DB? Basically mongo DB is JSON like structure database which provide us with the facility to use JSON objects to store data in our database. Mongo DB is No SQL database. Wait b...

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

Currently, most of the websites operate on an API-based backend structure, where we just send a request from the front end of the website by calling an API and obtaining the required results...

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

As a side hustle, I teach tech recruiters web and software development technologies using plain English. It helps them with understanding job specs and resumes and it makes all of us, tech p...

Introduction MongoDB is a NoSQL (not only SQL) database. In NoSQL databases, we store our data in a collection of documents. These documents are very similar to JavaScript objects or JSON ob...

This is an open-source introduction to SQL guide that will help you learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects. No matter if you a...

Article originally posted on my website un How to securely store the password in the Database When I started LOGaritmical, one of the first functionalities that I implemented was registering...

Polymorphic Relationships frightened me a little bit. I mean, who wouldn't be afraid of something called "Polymorphic Relationships." Even saying those words used to make me shiver...

Connecting to a MySQL database in NodeJS is actually quite simple. First off, you'll need to make sure you have a local MySQL server on your machine and then you can follow these steps.To st...