revilon1991

findMinix() {
    local subnet="192.168.2"
    local enp1s0_mac="a0:1e:0b:0e:81:14"
    local wlan0_mac="cc:4b:73:8e:6c:8a"

    normalize_mac_simple() {
      echo "$1" | tr '[:upper:]' '[:lower:]' | awk -F: '{
        for(i=1;i<=NF;i++) {
          sub(/^0+/, "", $i);
          printf "%s%s", $i, (i==NF ? "\n" : ":")

revilon1991

-- Install https://github.com/Hammerspoon/hammerspoon and put this in ~/.hammerspoon/init.lua
ctrlCmdShortcuts = {
  {"]", "PhpStorm"},
  {"[", "GoLand"},
  {"'", "Spotify"},
  {"/", "Safari"},
  {"\\", "Slack"},
}

for i,shortcut in ipairs(ctrlCmdShortcuts) do

revilon1991

What is a Page Split and Its Impact on Database Fragmentation

A Page Split occurs in B-trees (the underlying structure of most database indexes) when a new record is inserted into a full data page. To make room, the database engine splits the page into two, redistributes the records, and updates the index pointers.

Why Does a Page Split Cause Fragmentation?

1. Breaks Physical Order – The new page may be allocated in a different location, disrupting the sequential structure of the data.
2. Extra Redistribution Costs – Each split requires modifying adjacent pages and potentially updating parent nodes, increasing system load.
3. Decreased Read Efficiency – Fragmentation forces the database to perform additional I/O operations when reading sequential data.

revilon1991

package main

import (
	"context"
	"encoding/json"
	"fmt"
	"net/http"
	"runtime/debug"
	"strconv"
	"sync"

revilon1991

# Complete mapping of ISO 3166 2-letter country codes to descriptions used in Google calendar URLs, accurate as of 29 July 2021.

iso_to_gcal_description = {
    "ad": "ad",
    "ae": "ae",
    "af": "af",
    "ag": "ag",
    "ai": "ai",
    "al": "al",
    "am": "am",

revilon1991

# Majority Grouping
select concat(repeat('*', floor(a.trCount / 100))) as bar,
       floor(avg(a.trCount)) as avgTrCnt,
       max(a.trCount) as maxTrCnt,
       min(a.trCount) as minTrCnt,
       count(*) as accountCnt
from Account a
where 1
    and a.trCount > 10
group by bar

revilon1991

Совместимость типов блокировок на уровне таблицы представлена в следующей матрице

	X	IX	S	IS
X	Конфликт	Конфликт	Конфликт	Конфликт
IX	Конфликт	Совместимо	Конфликт	Совместимо
S	Конфликт	Конфликт	Совместимо	Совместимо
IS	Конфликт	Совместимо	Совместимо	Совместимо

• S-блокировка позволяет транзакции, которая удерживает блокировку, читать строку.
• X-блокировка позволяет транзакции, которая удерживает блокировку, обновлять или удалять строку.

revilon1991

<?php

declare(strict_types=1);

namespace App\Controller;

use App\Entity\Article;
use App\Entity\ArticleHasTag;
use App\Entity\Tag;
use Doctrine\Common\Collections\ArrayCollection;

revilon1991

launchctl stop com.apple.Dock.agent

revilon1991

<?php

// here installed https://github.com/dragonmantank/cron-expression
require_once '/Users/ekuznetsov/projects/pamyatki/vendor/autoload.php';

// current time is 2022-08-18 18:30:30

date_default_timezone_set('Europe/Moscow');

$c = new \Cron\CronExpression('0 0 1 * *');