Homebrew installed MariaDb too many open files

MariaDB broken

It happened again.

I did brew update/upgrade a while ago then weeks after that restarted MariaDB then days later tried to access MariaDB.

MariaDb too many open files

Trying to get info over the config file seems not easy.

Apple movie file to animated gif

Make a proper recording

  • Record using QuickTime
  • Clip/trim the video

Convert

ffmpeg -i video.mov -vf fps=5,scale=450:-1 animated.gif

Resources

https://compendiumdev.storychief.io/how-to-convert-video-to-animated-gif-using-ffmpeg

Install image on Pinephone

According to Copying an operating system image to an SD card using Mac OS steps are

Info

diskutil list

(snip)
/dev/disk4 (external, physical):
   #:                       TYPE NAME                    SIZE       IDENTIFIER
   0:     FDisk_partition_scheme                        *32.0 GB    disk4
   1:                 DOS_FAT_32 NO NAME                 32.0 GB    disk4s1
(snip)

Unmount

Take disk identifier and unmount disk

Adding an inset using minkowski

Cubes with one applying minkowski

OpenSCAD is a scripting CAD tool every developer could like.

Create alias when tired of opening customer site in particular browser

For this to work you need to have your Drush aliasses configured

You also need the path to your Browser app.

alias customer_test_dir='cd path-to/customer_dir'
alias customer_test='customertest_dir ; open -a /Applications/Chromium.app `drush @tst uli --mail=clemens@build2be.nl --no-browser`'

Create an alias when composer runs out of memory

alias composer='php -d memory_limit=-1 `which composer`'

Compiling Godot on MacOS

The documentation for compiling Godot is well written. The new tools are a little overwhelming at first but just follow the steps was good enough.

Building master branch

Fetching the latest master version then compiling I failed to compile the 3.2 version.

git checkout master
scons platform=osx arch=x86_64 --jobs=$(sysctl -n hw.logicalcpu)

gives some warnings and error.

Learning Rust

Motivation

Having the need for a shell tool builder lets try Rust language. They have some interesting outputs and books

WebASM

As a web developer using Drupal and Javascript my interest for WebASM is growing.

Shell

Doing some file search

Networking

Instead of using node or my favorite Deno we can probably connect to Drupal similar using Rust.

Skybox

A Skybox is part of a 3D World Environment.

  • You could change the default_env.tres
  • But you could also add a WorldEnvironment
  • Each camera has an Environment

default_env.tres

Add a 360 photo

The 8K photo was downloaded from HDRIhaven old bus depot

Migrate plugins

cd web/code/
# source
find . -type d -name "migrate" | ack -v -i test | xargs -I {} find {}/source -name '*.php' 2>/dev/null | wc -l
     121
# destination
find . -type d -name "migrate" | ack -v -i test | xargs -I {} find {}/destination -name '*.php' 2>/dev/null | wc -l
      34
# process
find . -type d -name "migrate" | ack -v -i test | xargs -I {} find {}/process -name '*.php' 2>/dev/null | wc -l
      84
# all ?!?
core clemens$ find . -type d -name "migrate" | ack -v -i test | xargs -I {} find {} -name '*.php' 2>/dev/null | wc -l
     509