Saturday, September 12, 2020

schema vs database in MySQL and PostgreSQL


TL;DR: both schema and database mean database in MySQL.



MySQL (<— you’re here in SQL client, unless you set default schema in connection)

database1 (<— you're here if use database1;)

tables


PostgreSQL

database1

public (<— you’re here in SQL client, unless you set default search_path in connection)

tables

schema1 (<— you're here if set search_path=schema1;)

tables


Sunday, June 16, 2019

how to slow down a video (and its audio) by 1.25x


$ brew install ffmpeg

$ ffmpeg -i input.mp4 -filter_complex "[0:v]setpts=1.25*PTS[v];[0:a]atempo=0.8[a]" -map "[v]" -map "[a]" output.mp4