Skip to content

Instantly share code, notes, and snippets.

@calvine
calvine / docker stuff.txt
Last active April 28, 2021 20:14
Create temp postgres database with docker
docker container run -p 5432:5432 -e POSTGRES_PASSWORD=password1 -e POSTGRES_USER=postgres -e PGDATA=/var/lib/postgresql/data --rm --name postgres -v postgres:/var/lib/postgresql/data postgres:latest
# https://hub.docker.com/_/couchdb
docker container run -d --name test_couchdb -p 5984:5984 -v /home/couchdb/data:/opt/couchdb/data -v /home/couchdb/etc:/opt/couchdb/etc/local.d -e COUCHDB_USER=root -e COUCHDB_PASSWORD=password couchdb:3.1.1
@calvine
calvine / ffmpeg.ref
Last active February 24, 2021 15:50
FFMPEG Command Examples
# speed up video
ffmpeg.exe -i .\output_1.mp4 -filter:v "setpts=0.1*PTS,fps=30" output_1_fast.mp4
# concatenate videos
ffmpeg.exe -f concat -safe 0 -i files__.txt -c:v copy timelapse_1.mp4
# powershell get all files names in date order to file
Get-ChildItem -Path . | Sort-Object -Property LastWriteTime | Select-Object -Property Name | Out-File .\files__.txt
# overkill powershell to get all files from a directory with a given file extension order by last write time in expected FFMPEG format
Set-Variable -Name "target_file" -Visibility Public -Value "./timelapse_files.txt"; Get-ChildItem -Path "Z:\Videos\Grow_Footage\Sunflower_feb_2021\DCIM\Timelapse_footage\100GOPRO" | Where-Object {$_.Name -like "*.mp4"} | Sort-Object -Property LastWriteTime | Select-Object -ExpandProperty FullName | ForEach-Object -Begin {Write-Host "Starting Loop"; Remove-Item $target_file -Force; New-Item $target_file -ItemType "file"} -Process { Write-Host $target_file; Add-Content -Path $target_file -Encoding Ascii -Value $("file '{0}'"