database Archives | Ahmed Shaltout

General

System Architecture vs. Software Architecture: Understanding the Blueprint for Digital Solutions

In the world of technology, terms like System Architecture and Software Architecture are often used, but their precise definitions and relationship can be confusing. Simply put, system architecture is the master blueprint for the entire solution, including hardware, software, and networking. In contrast, software architecture is a detailed blueprint for just the software portion of […]

Laravel

Speed Up Laravel Queries: 5 Essential Strategies for Millions of Records

When dealing with massive datasets in Laravel, inefficient database queries can cripple performance. Here are five proven hacks to query millions of records in mere seconds:

Node.js

Web Scraping IMDB With Node & cheerio

Let’s get movies from IMDb using Cheerio and save the data in the Mysql database using Sequelize.

Laravel

Laravel Cache Redis And File Store Tutorial With Example.

Let’s create a Laravel cache class to store data in a Redis server or files. Laravel has powerful APIs for caching so let’s get started.

Laravel

Laravel E-commerce Product Model With Price and Discount Concept.

Let’s create a Multi-languages product table, model, and controller, and Calculate the price according to a discount for a period of time automatically.

Node.js

Authentication In Node.js And MongoDB

This tutorial will explain the easiest way to make an authentication system using Node.js and Mongo Database using JWT and Mongoose

Node.js

Node.js MySQL database CRUD model Express tutorial.

In this tutorial, we are going to create a reusable CRUD model class for MySQL database in Node.js and Express.js with RESTful API.

Laravel

How to add a new column to an existing table via Laravel migration

Sometimes we need to add a new column or update an existing one to an existing table in the database after the migration. it’s so easy to do, we will add a new column and rename and change the data type of another one. let’s get started.

Laravel

Laravel Secure RESTful API CRUD With Access Token tutorial

Sometimes we need to build a single-page application or we just need two applications to talk to each other for example backend Laravel app needs to communicate with the frontend Vuejs app, here comes the RESTful API solution.

WordPress

How to configure the database after deploying WordPress to cPanel

After deploying a WordPress website to cPanel on shared hosting or server, you may wonder where you can configure the database connection. So that, you can use the admin dashboard and the website start to work correctly.