mucaho

# Instructions for darwin coreutils
# credits: https://stackoverflow.com/questions/3840908/how-do-i-see-the-differences-between-2-mysql-dumps

cd /to/appropriate/working/dir

docker exec -ti mysql5.7 /bin/bash
> mysqldump --skip-opt DB_NAME > prior.sql
> exit
docker cp mysql5.7:/prior.sql prior.sql
sed -i='' -e "s/[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]/0000-00-00 00:00:00/g" prior.sql

mucaho

First creation date: 2025-04-20
Latest update date: 2025-04-24

Changelog

• 2025-04-24: Updated solution for state-threading

Table of Contents

• Introduction
• State threading

mucaho

module ArelHelpers
  extend self

  def self.included(base)
    base.extend self
  end

  def asterisk(arel_table_or_model)
    arel_table, columns = case arel_table_or_model
                          when Arel::Table

mucaho

Arel Cheatsheet on Steroids

A (more) complete cheatsheet for Arel, including NamedFunction functions, raw SQL and window functions.

Tables

posts = Arel::Table.new(:posts)
posts = Post.arel_table # ActiveRecord

Table alias

mucaho

Minimum working example for issue described in https://support.google.com/webmasters/thread/171071268?hl=en

• Requires installation of Node.js

• Put these files into a directory, run npm install to install dependencies

• Use ssh -R 80:localhost:8080 localhost.run to setup a temporary tunnel to your local machine, leave that shell open

• Copy & paste the publicly accessible tunnel url that will be established, e.g. https://XXX.lhrtunnel.link

• Open Google Search Console and create a new URL prefix property with that tunnel link

• Use the meta tag verification method and paste it into the project's index.html file's header

mucaho

// ==UserScript==
// @name        YouTube restore video time
// @namespace   Violentmonkey Scripts
// @match       https://*.youtube.com/*
// @grant       none
// @version     1.0
// @author      mucaho
// @description -
// ==/UserScript==

mucaho

async function main() {
    const rej = Promise.reject('err')
    // the following line is needed,
    // otherwise UnhandledPromiseRejectionWarning is thrown
    // which can't be caught anywhere else (not even by async caller)!
    // can be NOOP though, if error handling may be delayed to below catch block
    rej.catch(e => console.log(e)) // logs 'err'

    const del = new Promise((resolve) => {
        setTimeout(() => resolve('del'), 100)

mucaho

FROM node:12-alpine
RUN apk add --no-cache tini
RUN apk add --no-cache curl

ADD https://raw.githubusercontent.com/eficode/wait-for/master/wait-for /bin/wait-for.sh
RUN chmod +rx /bin/wait-for.sh

USER node
RUN mkdir -p /home/node/app
WORKDIR /home/node/app

mucaho

mucaho

active_guide
argument-name
block_cursor
brackethighlighter.curly
brackethighlighter.tag
class
class-inheritance
class-name
comment
comment.block