Ivan Mykhavko 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

DigitalOcean does not provide a way to download a snapshot of your droplet locally. You can use rsync to accomplish this instead.

On your local machine, assuming you have added your-server in your SSH config:

rsync -aAXHv --append-verify --exclude={"/dev/*","/proc/*","/sys/*","/tmp/*","/run/*","/mnt/*","/media/*","/lost+found"} your-server:/

-a : archive mode (all files, with permissions, etc.)
-A : preserve ACLs/permissions (not included with -a)

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

public function connections()
{
	$relation = $this
		->belongsToMany(static::class, 'connections', 'requestor_id', 'requested_id')
		->withTimestamps();

	/// delete the already built inner join
	$relation
		->getQuery() // Eloquent\Builder

People

`:bowtie:`	😄 `:smile:`	😆 `:laughing:`
😊 `:blush:`	😃 `:smiley:`	☺️ `:relaxed:`
😏 `:smirk:`	😍 `:heart_eyes:`	😘 `:kissing_heart:`
😚 `:kissing_closed_eyes:`	😳 `:flushed:`	😌 `:relieved:`
😆 `:satisfied:`	😁 `:grin:`	😉 `:wink:`
😜 `:stuck_out_tongue_winking_eye:`	😝 `:stuck_out_tongue_closed_eyes:`	😀 `:grinning:`
😗 `:kissing:`	😙 `:kissing_smiling_eyes:`	😛 `:stuck_out_tongue:`

	## References:
	# https://git.io/Jf3l9
	# https://circleci.com/docs/2.0/yarn/
	# https://circleci.com/docs/2.0/caching/#yarn-node
	# https://circleci.com/orbs/registry/orb/circleci/node
	# https://discuss.circleci.com/t/circleci-2-1-config-overview/26057
	version: 2.1

	orbs:
	node: circleci/[email protected]

	<?php

	namespace <Your namespace here>;

	use Illuminate\Support\Facades\DB;

	/**
	*
	* @author Ervinne Sodusta <[email protected]>
	*/

	<?php

	use Illuminate\Support\Facades\Schema;
	use Illuminate\Database\Schema\Blueprint;
	use Illuminate\Database\Migrations\Migration;

	class LaravelConditionalIndexMigration extends Migration
	{
	/**
	* Run the migrations.

	# === Optimized my.cnf configuration for MySQL/MariaDB (on Ubuntu, CentOS, Almalinux etc. servers) ===
	#
	# by Fotis Evangelou, developer of Engintron (engintron.com)
	#
	# ~ Updated September 2024 ~
	#
	#
	# The settings provided below are a starting point for a 8-16 GB RAM server with 4-8 CPU cores.
	# If you have different resources available you should adjust accordingly to save CPU, RAM & disk I/O usage.
	#

	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)