tegos

Comparing Two MySQL Queries for Top Solution Authors

This summarizes two queries to get the top users by solutions count, their corrected forms, simulated execution plans, and recommendations. For this video: Laravel Performance: Careful with withCount() by Povilas Korop.

Query 1 – Subquery in SELECT

Corrected Query

tegos

<?php

declare(strict_types=1);

namespace Tests\Unit\Architecture;

use Illuminate\Support\Facades\App;
use RecursiveDirectoryIterator;
use RecursiveIteratorIterator;
use RegexIterator;

tegos

#!/bin/bash

TODAY=`date +%d.%m.%Y`
TODAY_TIME=`date +%d.%m.%Y-%T`

DB_BACKUP_PATH='/backups/mysql-backups'
MYSQL_CONFIG_PATH='/backups/mysql.cnf'
DATABASE_NAME='asg'

DB_FILE=${DB_BACKUP_PATH}/${TODAY}/${DATABASE_NAME}-${TODAY_TIME}.sql

tegos

DDD

• https://laracasts.com/discuss/channels/general-discussion/folder-and-namespace-structure-with-ddd

Porto

• https://github.com/saveroo/Porto

Laravel HMS

• https://github.com/somratcste/hospital-management-system

Apicentric Laravel with Porto Approach

tegos

import math
import os
import urllib
from shapely.geometry import Polygon

def deg2num(lat_deg, lon_deg, zoom):
	lat_rad = math.radians(lat_deg)
	n = 2.0 ** zoom
	xtile = int((lon_deg + 180.0) / 360.0 * n)
	ytile = int((1.0 - math.log(math.tan(lat_rad) + (1 / math.cos(lat_rad))) / math.pi) / 2.0 * n)

tegos

Laravel's Dependency Injection Container in Depth

Translations: Korean (by Yongwoo Lee)

Laravel has a powerful Inversion of Control (IoC) / Dependency Injection (DI) Container. Unfortunately the official documentation doesn't cover all of the available functionality, so I decided to experiment with it and document it for myself. The following is based on Laravel 5.4.26 - other versions may vary.

Introduction to Dependency Injection

I won't attempt to explain the principles behind DI / IoC here - if you're not familiar with them you might want to read What is Dependency Injection? by Fabien Potencier (creator of the Symfony framework).