Benji Asperheim basperheim

Useful Postgres (psql) commands

Here are some useful and essential psql commands to perform CRUD operations on PostgreSQL data.

DISCLAIMER: Use these commands with extreme caution.

It is highly recommended to:

Back up your database before running any of these commands (especially the UPDATE, DROP, TRUNCATE, and DELETE commands).
Double-check the command is the intended action you want to do.
Review the output of the SELECT query before executing any DROP statements.

FFmpeg: Create filler video and merge them

Creating monochrome filler videos, add audio tracks to them, and merge them together.

Creating a filler video without audio

Is it possible to add a black video with no volume, as filler, to the end of an MP4, using FFmpeg?

Yes, it is possible to add a black video with no volume as filler to the end of an MP4 using FFmpeg. You can achieve this by creating a black video clip with the desired duration and then concatenating it with the original video.

FFmpeg: merge a folder of AVI files with names that include order number

You can merge a series of .avi files with ffmpeg using the concat filter. However, the concat filter requires that all inputs have the same streams (same codecs, same time base, etc.).

Here is an example of how you can do it (each video file should end in ..-01.avi, ..-02.avi, etc..):

Create the text file using echo

First, create a file that contains the list of all your .avi files. You can do this manually, but if your files are named in a sequence like 01.avi, 02.avi, 03.avi, and so on, you can generate this list automatically using a bash command. Here's how you can do it:

Useful FFmpeg Commands

Remove Metadata from Video File

To remove metadata from a video file using FFmpeg, you can use the following command:

ffmpeg -i input.mp4 -map_metadata -1 -c:v copy -c:a copy output.mp4

Linux/Ubuntu commands to get Docker Compose working on a Raspberry Pi

Command history

# Get Docker script
cd ~/Downloads
curl -fsSL https://get.docker.com -o get-docker.sh
sudo chmod +x get-docker.sh 
./get-docker.sh

	import os
	import subprocess

	DRY_RUN = False

	# Function to find all video files in the current directory
	def find_video_files():
	video_files = []
	for file in os.listdir('.'):
	if file.endswith('.mkv') or file.endswith('.mp4'):

	import os
	import subprocess

	DRY_RUN = False

	# Function to find all mkv files in the current directory
	def find_mkv_files():
	mkv_files = []
	for file in os.listdir('.'):
	if file.endswith('.mkv'):

	import os
	import fnmatch
	import sys
	import json
	import re
	import subprocess
	import argparse

	# Check if ffmpeg is installed
	try:

	import { Component, OnInit, OnDestroy } from "@angular/core";
	import { Subscription, Observable, of } from "rxjs";
	import { delay } from "rxjs/operators";

	@Component({
	selector: "replace-me",
	templateUrl: "./replace-me.html",
	styleUrls: ["./replace-me.scss"],
	})
	export class ReplaceMe implements OnInit, OnDestroy {

	from datetime import datetime, time
	import holidays
	import pytz

	def market_is_open():
	"""
	Checks whether the U.S. stock market (NYSE) is currently open based on Eastern Standard Time (EST).

	This function considers both the current date and time, taking into account:
	- U.S. holidays observed by NYSE.