Useful PostgreSQL Queries & Commands All sizes in MB, change /1024/1024 to /1024/1024/1024 for GB. Databases sizes Without system databases select datname as database, (pg_database_size(datname)/1024/1024) as size
YouTube video stream format codes Comprehensive list of YouTube format code itags itag Code Container Content Resolution Bitrate Range VR / 3D 5 flv audio/video 240p - - - 6 flv audio/video 270p - - - 17 3gp audio/video 144p - - - 18 mp4 audio/video 360p - - - 22 mp4 audio/video 720p - - -
Processing JSON using jq jq is useful to slice, filter, map and transform structured json data. Installing jq On Mac OS brew install jq
Remove MySQL completely Open the Terminal Use mysqldump to backup your databases Check for MySQL processes with: ps -ax | grep mysql Stop and kill any MySQL processes Analyze MySQL on HomeBrew: brew remove mysql