PLATFORM

  • Tails

    Create websites with TailwindCSS

  • Blocks

    Design blocks for your website

  • Wave

    Start building the next great SAAS

  • Pines

    Alpine & Tailwind UI Library

  • Auth

    Plug'n Play Authentication for Laravel

  • Designer comingsoon

    Create website designs with AI

  • DevBlog comingsoon

    Blog platform for developers

  • Static

    Build a simple static website

  • SaaS Adventure

    21-day program to build a SAAS

COMMUNITY
MORE

Database

Database posts, videos, courses, and more

DevDojo inspector Avatar

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

Valerio ยท 2 years ago

2
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 2 years ago

8
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 2 years ago

3
DevDojo techvblogs Avatar

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

TechvBlogs ยท 2 years ago

DevDojo techvblogs Avatar

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

TechvBlogs ยท 3 years ago

7
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

6
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

6
DevDojo omarthedev Avatar

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

Omar Moustafa ยท 3 years ago

3
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

7
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

5
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

5
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

4
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

11
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

5
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

5
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

5
DevDojo sachinchaurasiya Avatar

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

Sachin Chaurasiya ยท 3 years ago

3
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

4
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

4
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

10
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

7
DevDojo techvblogs Avatar

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

TechvBlogs ยท 3 years ago

3
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

7
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 3 years ago

6
DevDojo sandorturanszky Avatar

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

Sandor ยท 4 years ago

3
DevDojo bo-iliev Avatar

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

Boyan Iliev ยท 4 years ago

6
DevDojo bobbyiliev Avatar

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

Bobby Iliev ยท 4 years ago

11
DevDojo ppopescu Avatar

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

Petre Popescu ยท 4 years ago

2
DevDojo tnylea Avatar

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

Tony Lea ยท 5 years ago

7
DevDojo tnylea Avatar

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

Tony Lea ยท 5 years ago

7

Loading More Content