vyspiansky

ngrok notes

ngrok creates a tunnel from the public internet to your local machine.

Install

Sign up for an ngrok account https://dashboard.ngrok.com/

brew install ngrok/ngrok/ngrok

vyspiansky

To configure the error messages visibility, set an appropriate configuration in the settings.php file

// Show all error messages, including notices and coding standards warnings.
$config['system.logging']['error_level'] = 'verbose';

File: /path/to/docroot/sites/<SITE_NAME>/settings.php.

Then clear the Drupal cache.

vyspiansky

One of the ways to create an immediately executed anonymous function

(function() {
    'use strict';
    
    // ...
})();

vyspiansky

Drush version: 12.3.0.0.

Remove nodes with a specific bundle

If you have a large number of nodes and want to process them in batches, you can use the --chunk option:

drush entity:delete node --bundle=article --chunks=50

vyspiansky

Performance Comparison: UUID Field vs CRC Index Querying

• MySQL version: 5.7.29

SELECT * FROM uuid_crc_test WHERE uuid = 'c3830c70-a8e6-11ef-b990-0242ac180005';

Number of records	Execution times (ms)

vyspiansky

MySQL queries for selecting records based on different time criteria using a timestamp integer field named created.

Get records newer than today's 10 AM

SELECT
  *
FROM
  your_table
WHERE

vyspiansky

This technique updates your local branch and then "replays" your changes on top, effectively putting your changes at the head of the branch.

Enable

git config --global pull.rebase true

Disable

vyspiansky

“There are only two hard things in Computer Science: cache invalidation and naming things.”

— Phil Karlton

“One of life's greatest sources of satisfaction is the knowledge that something you have created is contributing to the progress or welfare of society.”

— Donald Knuth

vyspiansky

-- Remove all watchdog's records from a MySQL table except for the last 500.

DELETE FROM `watchdog`
WHERE wid NOT IN (
    SELECT wid
    FROM (
        SELECT wid
        FROM `watchdog`
        ORDER BY wid DESC
        LIMIT 500

vyspiansky

<?php

use Drupal\Core\Database\Database;
use Drupal\Core\Database\Query\SelectInterface;

/**
 * Returns a plain SQL query from a Select query object.
 */
function get_plain_sql_query(SelectInterface $query): string
{