Fix database collections

A new fix fo database collections (with supported emoticons)

ActiveRecord::Base.connection.tables.each do |table|
  ActiveRecord::Base.connection.execute( "ALTER TABLE `#{table}` CONVERT TO CHARACTER SET utf8mb4;")
end

Directly send an e-mail in rails without template

Snippet to directly send an e-mail in Rails, without templates

ActionMailer::Base.mail(
  from: "gamecreatre@example.com",
  to: "receiver@example.com",
  subject: "Sample Subject",
  body: "Message Body"
).deliver

Snippet to find string files of a given filename

find . -name config.rb -print0 | xargs -0 grep 'search-thing'

Extract single table from a MySQL dump

sed -n -e '/DROP TABLE.*`table_name`/,/UNLOCK TABLES/p' dump.sql > table_name.sql

Source: https://ruleoftech.com/2019/restore-single-table-from-full-mysql-database-dump

Derailed benchmark not running on production environment

We're running a large rails application, with a lot of request.
Since our upgrade to FreeBSD 13 the live environment is leaking memory in our ruby on rails app.
(FreeBSD 12 version of the jail didn't leak)

This application uses an NFS mount to store (a lot) of client specific files.

Running derailed_benchmark live didn't work. (Pressing ctrl+t, I noticed there were a lof of NFS locks)

In the file
derailed_benchmarks-2.1.1/lib/derailed_benchmarks/load_tasks.rb

it adds '.' to the loadpath. Which causes the production environment to complete iterate over all directories. Which 'hangs', because we have a very big active-strorage directory.

Workaround is to remove the '.' file

#    %W{ . lib test config }.each do |file|
    %W{ lib test config }.each do |file|
      $LOAD_PATH << File.expand_path(file)
    end