vyspiansky

Convert images to JPEG with quality control via macOS Terminal.

Bash script

File ./convert_to_jpeg.sh content:

#!/bin/bash

# This script converts various image types to JPEG with 75% quality.

vyspiansky

To do this we can use debug_backtrace:

// $backtrace = debug_backtrace();
$backtrace = debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS, 2);

// $caller = isset($backtrace[1]['function']) ? $backtrace[1]['function'] : 'unknown';
$caller = $backtrace[1]['function'] ?? 'unknown';

vyspiansky

To console.log every argument pushed to Google Tag Manager, use

window.dataLayer = window.dataLayer || [];

// Save the original push method
const originalPush = window.dataLayer.push;

// Monkey patch push
window.dataLayer.push = function() {

vyspiansky

To list mounted volumes use the following command in the Terminal (Applications > Utilities):

ls -la /Volumes/

For instance, our SD card is mounted as NO NAME.

Let's check extended attributes

vyspiansky

-- Top 10 largest tables in a MySQL database
-- MySQL 5.7.29

SELECT 
    table_schema AS `Database`,
    table_name AS `Table`,
    ROUND((data_length + index_length) / 1024 / 1024, 2) AS `Size (MB)`,
    ROUND(data_length / 1024 / 1024, 2) AS `Data Size (MB)`,
    ROUND(index_length / 1024 / 1024, 2) AS `Index Size (MB)`,
    table_rows as 'Rows'

vyspiansky

// Create a request object or parse the URL
$request = \Symfony\Component\HttpFoundation\Request::create($urlWithoutToken);

// or get the current request.
// $request = $event->getRequest();

Add new query parameter to URL

vyspiansky

cURL Multi

Native cURL multi-handle API for parallel requests.

Using separate cURL requests

<?php
// File: separate_curl_requests.php

vyspiansky

<?php

declare(strict_types=1);

function simpleGenerator() {
  echo "The generator begins\n"; 

  for ($i = 0; $i < 3; ++$i) {
    yield $i;
    echo "Yielded $i\n";

vyspiansky

Update MySQL's maximum packet size configuration

We're going to fix the following issue

The query length of 118146958 bytes is larger than max_allowed_packet size (33554432).

First of all, let's check the current size

vyspiansky

Using Symfony's MimeTypes

use Symfony\Component\Mime\MimeTypes;

function getFileExtension(string $fileContent): ?string
{
    $mimeType = (new \finfo(FILEINFO_MIME_TYPE))->buffer($fileContent);

 $mimeTypes = new MimeTypes();