Database

Database posts, videos, courses, and more

DevDojo inspector Avatar

Valerio · 2 years ago

Save 1.2 million queries per day with Laravel Eager Loading

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...
2
DevDojo bobbyiliev Avatar

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
DevDojo bobbyiliev Avatar

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
DevDojo techvblogs Avatar

TechvBlogs · 2 years ago

How to Get Random Records from Database in Laravel

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...
DevDojo techvblogs Avatar

TechvBlogs · 2 years ago

How to use multiple database in Laravel

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...
7
DevDojo bobbyiliev Avatar

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
DevDojo bobbyiliev Avatar

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
DevDojo omarthedev Avatar

Omar Moustafa · 2 years ago

Introducing Supabase: The new open-source Firebase alternative

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...
3
DevDojo bobbyiliev Avatar

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
DevDojo bobbyiliev Avatar

Bobby Iliev · 2 years ago

Building an Order Tracking Demo App using AdonisJS Materialize and Redpanda

Introduction ❗️ This demo includes examples for an unsupported version of Materialize (0.26.x) ❗️ This is a self-contained demo using Materialize to process orders and display the delive...
5
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

10 simple tips for optimizing your Laravel application

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...
5
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

Decoupled Microservices Architecture with Materialize

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...
5
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo sachinchaurasiya Avatar

Sachin Chaurasiya · 3 years ago

What is mongo DB ? and why it is getting more popularity?

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...
3
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo techvblogs Avatar

TechvBlogs · 3 years ago

Build Crud API with Node.js, Express, and MongoDB

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...
3
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 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
DevDojo sandorturanszky Avatar

Sandor · 3 years ago

How to create LinkedIn-like reactions with Serverless Redis

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...
3
DevDojo bo-iliev Avatar

Boyan Iliev · 3 years ago

Introduction To MongoDB and How To Use It

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...
6
DevDojo bobbyiliev Avatar

Bobby Iliev · 3 years ago

Opensource Introduction to SQL eBook 💡

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...
11
DevDojo ppopescu Avatar

Petre Popescu · 4 years ago

How to properly store a password in the Database

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...
2
DevDojo tnylea Avatar

Tony Lea · 4 years ago

Understanding Polymorphic Relationships

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...
7
DevDojo tnylea Avatar

Tony Lea · 5 years ago

Connecting to a MySQL database in NodeJS

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

Loading More Content