Alan Vasconcelos alandbh

Wordpress & Docker

This file will setup Wordpress, MySQL & PHPMyAdmin with a single command. Add the code below to a file called "docker-compose.yaml" and run the command

$ docker-compose up -d

# To Tear Down
$ docker-compose down --volumes

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

First of all you need to be able to run MAMP in port 80. This is a "heat check" if you don't have any process jamming http ports. You can check it like this:

sudo lsof | grep LISTEN

If you do happen to have any process with something like this *:http (LISTEN), you are in trouble. Before with adventure check if it isn't MAMP itself (yeah, you should close that beforehand)

ps <pid of that process>

If you don't see MAMP, you are in good hands, I have just the thing for you:

	#!/bin/bash
	# vcompress: comprime um vídeo encontrado por nome parcial.
	# Uso:
	# vcompress <nome-parcial> [--height <H>] [--crf <N>] [--noaudio]
	#
	# Padrões:
	# --height <H> Altura do vídeo (padrão: 1440). Ex.: 720, 900, 1080, 1440
	# --crf <N> Qualidade CRF (padrão: 20). 0–51 (menor = melhor)
	# --noaudio Remove a trilha de áudio
	#

	// SASS FUNCTION TO CONVERT PX INTO REM

	// Defining base font size
	// The default font size for html is 16px
	$base-size: 16;
	//Function to convert px value into rem
	//You can replace rem with any other value you want (rem is most preferred value for web)
	@function size($target, $context: $base-size) {
	@return ($target / $context) * 1em;
	}

	/*
	This .scss loop will create "margin helpers" and "padding helpers" for use in your web projects.
	It will generate several classes such as:

	.m-r-10 which gives margin-right 10 pixels.
	.m-r-15 gives MARGIN to the RIGHT 15 pixels.
	.m-t-15 gives MARGIN to the TOP 15 pixels and so on.

	.p-b-5 gives PADDING to the BOTTOM of 5 pixels
	.p-l-40 gives PADDING to the LEFT of 40 pixels

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
	<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
	<script type="text/javascript" src="jquery-1.7.1.min.js"></script>
	<script type="text/javascript">

	$(document).ready(function () {

	$.getJSON('estados_cidades.json', function (data) {

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

	{
	"keys": ["tab"],
	"command": "expand_abbreviation_by_tab",

	// put comma-separated syntax selectors for which
	// you want to expandEmmet abbreviations into "operand" key
	// instead of SCOPE_SELECTOR.
	// Examples: source.js, text.html - source
	"context": [
	{

Alan Vasconcelos alandbh

Wordpress & Docker

Converting mkv to mp4 with ffmpeg

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

Single file conversion example

Converting mkv to mp4 with `ffmpeg`