Rada Bogdan bogdanRada

Installing mysql2 gem

This is always an annoying process, especially when you are setting up a new computer. I assume you are using macOS + homebrew. I also assume that you want to run an older version of MySQL (although the instructions should be adaptable).

Installing MySQL

$ brew install [email protected] # change the version if needed

Converting mkv to mp4 with `ffmpeg`

Essentially just copy the existing video and audio stream as is into a new container, no funny business!

The easiest way to "convert" MKV to MP4, is to copy the existing video and audio streams and place them into a new container. This avoids any encoding task and hence no quality will be lost, it is also a fairly quick process and requires very little CPU power. The main factor is disk read/write speed.

With ffmpeg this can be achieved with -c copy. Older examples may use -vcodec copy -acodec copy which does the same thing.

These examples assume ffmpeg is in your PATH. If not just substitute with the full path to your ffmpeg binary.

Single file conversion example

Stackoverflow answer link - https://stackoverflow.com/a/2068371/867451

Copied the content for quick reference

Each YouTube video has four generated images. They are predictably formatted as follows:

https://img.youtube.com/vi/<insert-youtube-video-id-here>/0.jpg

https://img.youtube.com/vi/<insert-youtube-video-id-here>/1.jpg

	#!/usr/bin/env bash
	RUBOCOP_CONF="$1"

	cat "$RUBOCOP_CONF" \| \
	sed -e 's\|^DuplicatedGem\|Bundler/DuplicatedGem\|g' \| \
	sed -e 's\|^InsecureProtocolSource\|Bundler/InsecureProtocolSource\|g' \| \
	sed -e 's\|^OrderedGems\|Bundler/OrderedGems\|g' \| \
	sed -e 's\|^DuplicatedAssignment\|Gemspec/DuplicatedAssignment\|g' \| \
	sed -e 's\|^OrderedDependencies\|Gemspec/OrderedDependencies\|g' \| \
	sed -e 's\|^RequiredRubyVersion\|Gemspec/RequiredRubyVersion\|g' \| \

	# I submitted a bug report https://github.com/rails/rails/issues/34244
	# b/c Rails was not honouring my `rescue_from` block which was causing my API to
	# be inconsistent. I was told this is expected behaviour. I think it's probably
	# fine for an HTML app where you control the form inputs. But for an API app,
	# the API is public facing and very important, so Rails shouldn't have its own
	# special errors that bypass my app's configuration and make my API inconsistent.
	#
	# Decided it shouldn't be too difficult to handle this myself. So, here is my
	# solution. It contains most of the important lessons I've learned about how to
	# get a Rails API app setup. It removes Rails' params parsing and adds its own.

	ARG RELEASE=bookworm
	FROM debian:${RELEASE}-slim

	LABEL maintainer="NGINX Docker Maintainers <[email protected]>"

	# Define NGINX versions for NGINX Plus and NGINX Plus modules
	# Uncomment this block and the versioned nginxPackages block in the main RUN
	# instruction to install a specific release
	# ARG RELEASE
	# ENV NGINX_VERSION=32

	#!/usr/bin/env bash

	# USAGE: mysqlOptimizeForImports <- before importing
	# mysqlDefaultSettings <- to go back to normal

	# Based on https://dba.stackexchange.com/questions/83125/mysql-any-way-to-import-a-huge-32-gb-sql-dump-faster/83385#83385

	mysqlStateFile="$HOME/mysql.optimized.for.exports"
	mysqlConfigLocation="/etc/mysql/my.cnf" # <-- change to the correct for your system, should be for global mysql settings

	/* This Source Code Form is subject to the terms of the Mozilla Public
	* License, v. 2.0. If a copy of the MPL was not distributed with this
	* file, You can obtain one at http://mozilla.org/MPL/2.0/. */

	var EXPORTED_SYMBOLS = ["BrowserGlue", "ContentPermissionPrompt"];

	const XULNS = "http://www.mozilla.org/keymaster/gatekeeper/there.is.only.xul";

	const { XPCOMUtils } = ChromeUtils.import(
	"resource://gre/modules/XPCOMUtils.jsm"

	#!/bin/sh
	#
	# This script should be run via curl:
	# sh -c "$(curl -fsSL https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)"
	# or wget:
	# sh -c "$(wget -qO- https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)"
	#
	# As an alternative, you can first download the install script and run it afterwards:
	# wget https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh
	# sh install.sh