Discover gists

Guide rapide d'utilisation de FFmpeg

Ce document est un résumé rapide basé sur la documentation officielle de FFmpeg. Il a été créé pour faciliter la manipulation vidéo, bien que certaines informations puissent également être pertinentes pour l'audio.

Note : Ce document est une compilation de ce que j'ai compris et de mes propres expériences. Il est fait d'abord pour moi, est incomplet et peut contenir des erreurs.

Informations générales

Pour une documentation complète, consultez le site officiel de FFmpeg.
Wiki complet et bien écrit qui m'a beaucoup aidé ici.

Benchmark: Measuring Process Costs for Formulas in Cells on Google Spreadsheet using Google Apps Script

Description

When Google Spreadsheet is used, there is the case that the built-in functions and the custom functions in the cells are used. For the functions of Google Apps Script, there is the method for measuring the process cost. Ref But for the built-in functions, it is required to create the script for it. In this report, the script for measuring a function put in a cell has been proposed, and the process cost of the built-in functions has been measured. The proposed script can measure the process cost for the built-in functions and custom functions on Google Spreadsheet. The script is created with using Google Apps Script. When the process cost can be known for the built-in functions and custom functions, it is considered that it will be useful for the developers using Google Spreadsheet.

The origin of this method

Mike's x86-64 Assembly (ASM) Notes

Assembling Binary Machine Code

Operating `Modes`:

These determine the assumed/default size of instruction operands, and restricts which opcodes are available, and how they are used.

Modern operating systems, booted inside Real mode,

MySQL Cheat Sheet

Help with SQL commands to interact with a MySQL database

MySQL Locations

Mac /usr/local/mysql/bin
Windows /Program Files/MySQL/MySQL version/bin
Xampp /xampp/mysql/bin

Add mysql to your PATH

`envsource`

⚠️ NOTE (20.5.2023): I don't really use this function at all anymore since there are now tools such as Taskfile, which reads the .env file for me sparing me the need to pollute my session with environment variables.

I've been using Fish shell for years which is great and all, but one thing that has got me frustrated is using it with .env files.

When attempting to run source .env in a project, I usually encounter this problem:

Add Git Branch Name to Terminal Prompt (Linux/Mac)

Open ~/.bash_profile in your favorite editor and add the following content to the bottom.

# Git branch in prompt.

parse_git_branch() {

	#!/bin/sh

	set -euo pipefail
	#set -x

	MICRODNF_PACKAGES_F38="https://kojipkgs.fedoraproject.org//packages/microdnf/3.9.0/2.fc38/x86_64/microdnf-3.9.0-2.fc38.x86_64.rpm \
	https://kojipkgs.fedoraproject.org//packages/libpeas/1.34.0/3.fc38/x86_64/libpeas-1.34.0-3.fc38.x86_64.rpm \
	https://kojipkgs.fedoraproject.org//packages/dnf/4.14.0/2.fc38/noarch/dnf-data-4.14.0-2.fc38.noarch.rpm \
	https://kojipkgs.fedoraproject.org//packages/libdnf/0.68.0/2.fc38/x86_64/libdnf-0.68.0-2.fc38.x86_64.rpm"

	<?php
	/**
	* Update related item from form action/notification
	*
	* @param array $args [description]
	* @return [type] [description]
	*/
	function my_update_related_items( $args = array() ) {

	$relation = ! empty( $args['relation'] ) ? $args['relation'] : false;

	##### 使用说明 #####
	# 1. 请填写 proxy-providers - subscribe - url 为订阅链接
	# 2. 下载 https://github.com/Loyalsoldier/clash-rules/archive/refs/heads/release.zip 并解压至 ./profiles/ruleset 文件夹下
	# 3. 若需要自动更新 ruleset, 请编辑 rule-providers-config - type 为 http

	##### 参考链接 #####
	# 1. clash 样例配置文件
	# https://lancellc.gitbook.io/clash/clash-config-file/an-example-configuration-file
	# 2. clash 规则集
	# https://github.com/Loyalsoldier/clash-rules


	export const firstNameAndLastnamePattern: string = '([a-zA-Z]+) ([a-zA-Z]+)';
	export const emailPattern: string = "^[a-z0-9._%+-]+@[a-z0-9.-]+\\.[a-z]{2,4}$";