Blog Spot!
PocketBase - open source Go backend tool in 1 file
PocketBase is an open source Go backend, consisting of:
- embedded database (SQLite) with real time subscriptions
- built-in files and users management
- convenient Admin dashboard UI
- and simple REST-ish API
Links:
Everything SQLite
zcat for 7zip
#!/bin/bash
# copy this file into /bin/zcat to a file called /bin/7zcat
PATH=${GZIP_BINDIR-'/bin'}:$PATH
exec 7z e -so -bd "$@" 2>/dev/null | catHow to read a CSV file with bash under Linux terminal
#!/usr/bin/env bash
#
# Read line by line and parse a CSV file
# ex. test@office.com,Alex,1-800-555-321
#
# "IFS" - https://www.baeldung.com/linux/ifs-shell-variable
# ${gsm:2}" - remove the first 2 characters from the string
while IFS=, read -r email name gsm
do
echo "${name} $email ${gsm:2}"
done < users.csvYouTube - play, cast or download videos
CLI Tools
- youtube-dl - CLI program to download videos from YouTube and other video sites.
- yt-dlp - A youtube-dl fork with additional features and fixes.
- ytcast - Cast YouTube videos to your smart TV from CLI. Related [tools].ytcast-tools
- ytsearch - Search and select youtube video links (no api).
Limit resolution
Sometimes it is better to limit the max resolution when playing videos with MPV.
# video resolutions: ..240, 360p, 480p, 720p,..
mpv --ytdl-format="bestvideo[height<=480]+bestaudio/best[height<=480]" $1