Ihor Vyspiansky 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.

One of the ways to create an immediately executed anonymous function

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

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

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)

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

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

“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

.lando.yml

name: "..."
recipe: lamp
config:
  php: "8.1"
  xdebug: false
services:
 appserver:

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

	<?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
	{