sowich

# Включмть индексацию Spotlight можно командой:
sudo mdutil -a -i on

# Выключмть индексацию Spotlight можно командой:
sudo mdutil -a -i off

При выключенной индексации не работают теги!

sowich

WITH RECURSIVE epc (id, parent_id, anchor) as (
    SELECT id, parent_id, anchor FROM table WHERE parent_id = 32
    UNION ALL
    SELECT pc.id, pc.parent_id, pc.anchor FROM table pc
                                        INNER JOIN epc on pc.parent_id = epc.id
)
SELECT * FROM epc order by id

sowich

Конвертировать binary-файл в txt
xxd -p 1.mp3 1.txt

Конвертировать из txt в binary-файл
xxd -r -p 1.txt 2.mp3

sowich

UPDATE table SET post_author = 4 WHERE RAND() < 0.5

UPDATE wp_posts SET post_author = 5 where rand()<0.1 and post_author = 6

sowich

- github:
"Managing remote repositories"
https://docs.github.com/en/get-started/getting-started-with-git/managing-remote-repositories

======================================================================================

- stackoverflow
"How do I use cURL to perform multiple simultaneous requests?"
https://stackoverflow.com/a/66998509

sowich

package main

import (
	"fmt"
	"log"
	"net/http"
	"strings"
	"sync"
	"time"

sowich

Посмотреть открытые порты

lsof -PiTCP -sTCP:LISTEN

Посмотреть все маршруты

netstat -nr

sowich

package main

import (
	"flag"
	"fmt"
	"log"
	"net/http"
	"time"
	"strings"
	"os"

sowich

SELECT 
    wp_posts.ID
FROM
    wp_posts
        LEFT JOIN
    wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE
    1 = 1 AND wp_posts.ID NOT IN (93110)
        AND (wp_term_relationships.term_taxonomy_id IN (8))
        AND wp_posts.post_type = 'post'

sowich

"use strict";

fetch("...", {method: "POST"})
    .then(result => result.json())
    .then(result => {
        let ws = new WebSocket("..." + result.connectionId);

        ws.onopen = () => {
            ws.send(JSON.stringify({...}));
            ws.send(JSON.stringify({...}));