Ahmad ahmadazimi

Download Audio from YouTube

-i - ignore errors

-c - continue

-t - use video title as file name

--extract-audio - extract audio track

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

This guide assumes that you recently run brew upgrade postgresql and discovered to your dismay that you accidentally bumped from one major version to another: say 9.3.x to 9.4.x. Yes, that is a major version bump in PG land.

First let's check something.

brew info postgresql

The top of what gets printed as a result is the most important:

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>Neshan Map Example (OpenLayers)</title>
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

	<link rel="stylesheet" type="text/css" href="https://static.neshan.org/sdk/openlayers/4.6.5/ol.css">
	<!-- The line below is only needed for old environments like Internet Explorer and Android 4.x -->
	<script src="https://cdn.polyfill.io/v2/polyfill.min.js?features=requestAnimationFrame,Element.prototype.classList,URL"></script>

	# Create a directory
	mkdir ~/tmux-install
	cd ~/tmux-install

	# Get the files
	curl -OL https://www.openssl.org/source/openssl-1.0.2l.tar.gz
	curl -OL https://github.com/tmux/tmux/releases/download/2.3/tmux-2.3.tar.gz
	curl -OL https://github.com/libevent/libevent/releases/download/release-2.0.22-stable/libevent-2.0.22-stable.tar.gz

	# Extract them

	<?php

	namespace App\Events;

	use Illuminate\Contracts\Broadcasting\ShouldBroadcast;
	use Illuminate\Queue\SerializesModels;

	class NewMessage extends Event implements ShouldBroadcast
	{

	worker_processes 1;

	events {
	worker_connections 1024;
	}

	http {
	access_log /usr/local/var/log/nginx/access.log;
	error_log /usr/local/var/log/nginx/error.log;
	include mime.types;


	/*

	-- EXAMPLE --

	SELECT
	* FROM
	unnest(grid(array(SELECT
	(
	lat,


	/**
	* Based on the mysql cluster
	* @link http://jonisalonen.com/2012/k-means-clustering-in-mysql/
	*/
	-- SELECT
	-- * FROM
	-- unnest(kmeans(array(SELECT
	-- (
	-- lat,

	Model::

	/Select/
	select('col1','col2')
	->select(array('col1','col2'))
	->select(DB::raw('businesses.*, COUNT(reviews.id) as no_of_ratings, IFNULL(sum(reviews.score),0) as rating'))
	->addSelect('col3','col4')
	->distinct() // distinct select

	/From/

Ahmad ahmadazimi

Download Audio from YouTube

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`