mahkassem

Northwind Database Queries

Description

This project is a collection of SQL queries that answer questions about the Northwind database using MySQL8 DQL commands.

Connect to the Database

Parameter	Value

mahkassem

Research Project: Comparing Document vs Relational Modeling

This project focuses on solidifying your understanding of the document data model and relational model using MongoDB and MySQL.

Project Goals

• Grasp the core concepts of document and relational data models. Evaluate the strengths and weaknesses of each model for a chosen use case.
• Design sample schemas for the use case in both (MongoDB) and a relational database (MySQL).
• Analyze the trade-offs in terms of data flexibility, querying complexity, and scalability for each approach.

mahkassem

import {
    ValidatorConstraint,
    ValidatorConstraintInterface,
    ValidationArguments,
    registerDecorator,
    ValidationOptions,
} from 'class-validator';
import { DataSource } from 'typeorm';

@ValidatorConstraint({ async: true })

mahkassem

K8s

kubeconfig

• kubectl commands:

# View the current context:
kubectl config current-context

mahkassem

Hi 👋, I'm Mahmoud Kassem

Software Engineer | Instructor

Blogs posts

Connect with me:

mahkassem

Linux Server Setup & Deployment

Deploy NodeJS application and html website with PostgresSQL and Nginx as a server

Environment

• OS: Linux20.04 LTS
• Server: Nginx 1.20
• NodeJS: nvm 0.39
• Database: PostgreSQL 12.11

Steps

mahkassem

How to use

• Add laravel-octane-pm2.yml in laravel app base directory
• start using pm2 start laravel-octane-pm2.yml
• Enable pm2 to auto start your app using pm2 save

mahkassem

pm2 start artisan --name laravel-worker --interpreter php -- octane:start --server=roadrunner --max-requests=1000 --host=127.0.0.1 --port=8000

mahkassem

## Personal note: Muslims are not terrorists and I humbly request my engineering community to help end racism.
# You should look at the following URL's in order to grasp a solid understanding
# of Nginx configuration files in order to fully unleash the power of Nginx.
# http://wiki.nginx.org/Pitfalls
# http://wiki.nginx.org/QuickStart
# http://wiki.nginx.org/Configuration
#
# Generally, you will want to move this file somewhere, and start with a clean
# file but keep this around for reference. Or just disable in sites-enabled.
#

mahkassem

git config --global alias.a "! git add . && git status"
git config --global alias.aa "! git add . && git add -u . && git status"
git config --global alias.ac "! git add . && git commit"
git config --global alias.acm "! git add . && git commit -m"
git config --global alias.alias "! git config --list | grep 'alias\.' | sed 's/alias\.\([^=]*\)=\(.*\)/\1\  => \2/' | sort"
git config --global alias.au "! git add -u . && git status"
git config --global alias.c "commit"
git config --global alias.ca "commit --amend"
git config --global alias.cm "commit -m"
git config --global alias.co checkout