Things I Learned Today about programming languages, frameworks and libararies or technology in general

Laravel

• Fix key is too long error in laravel
• Add helper files in laravel
• Create and use seeders in laravel
• Add a user middleware in laravel
• Create a user by default in laravel
• Use refresh database in laravel phpunit tests
• Modify laravel 'home' redirection path
• Setup token api auth with sanctum in laravel
• Migrate and seed with same command
• Test registration and login in laravel
• Create model, controller and migration in same command
• Use validator and get all errors in laravel
• Manually handle http exceptions in laravel
• Common laravel template structure

Ffmpeg

• Reverse a video in ffmpeg
• Make a video greyscale in ffmpeg
• Rotate a video by x degress in ffmpeg
• Mute video at certain mark in ffmpeg
• Flip a video horizontally or vertically in ffmpeg
• Extract audio of a video in ffmpeg
• Generate thumbnails from video in ffmpeg
• Extract video waveform in ffmpeg
• Increase video speed
• Add watermark in any position in ffmpeg
• Split a vide in ffmpeg
• Show two videos side by side in ffmpeg
• Add subtitles in ffmpeg
• Increase or decrease audio in ffmpeg

Mysql

• Import sql file and skip errors
• Update table with matches from another table in mysql
• Create new user and give all privilages
• Create btree indexes in mysql
• Show all tables with specific engine
• Output select query into a text file
• Create or dop multiple mysql indexes in same query
• Create fulltext indexes in mysql
• Select from another table using id and sort
• Update datetime field with conversion from another in mysql
• Copy a table with schema, indexes and data
• Find duplicates with counts in mysql table

Linux

• Create new apache user in linux
• Run commands x number of times in linux
• Count number of lines in file
• Change host name in linux server
• Download apache password protected file using wget in linux
• Count files per day in a directory in linux
• Take screenshots or screen recordings in ubuntu 20
• Post ubutnu 20 installation tools checklist
• Run a command on each file in directory
• How quickly delete a huge directory in linux

Python

• Install virtualenv and create virtual environment on windows 10
• Read a csv file in python
• Play music in vlc using python on windows
• Filter and delete google chrome history items with python
• Open a url in chrome using python
• Read txt file separated by line into list in python
• Proxy usage with requests in python
• Change windows wallpaper using python 3
• Search question using wolframalpha in python
• Extract numbers from a string

Jquery

• Iterate over several elements in jquery
• Follow people in bulk on mediumcom
• Include jquery in console
• Scroll to bottom of html page using jquery
• Eyes friendly article reading with jquery
• Quick ajax template jquery
• Send an ajax request
• Quick each example jquery

Php

• Autoload classes in php
• Use proxies with curl in php
• Read csv file in php
• Find total weekends between two dates in php
• Rotate all videos in a directory using ffmpeg
• Run a command on multiple mysql tables using php

Scrapy

• Retry failed requests in scrapy
• Update a request url in scrapy
• Run a fucntion when scrapy spider closes
• Use proxies with scrapy
• Make scrapy spider interactive any point
• Find element that has particular text in scrapy

Bash

• Quickly login to mysql using bash
• Zip all files in directory and send to another server
• Run a script if it is not already running using bash
• Activate a virtual environment via bash
• Create mysql table and import large file

Youtube-dl

• Download all videos from youtube channel
• Search and download audio of first youtube video
• Extract best quality mp3 from a list of youtube urls
• Extract best quality mp3 audio from youtube video

Docker

• Docker quick commands
• Installation on ubuntu

Xampp

• Use mysql cli in xampp
• Create virtual host in xampp

Bootstrap

• Center any element in bootstrap
• Display two elementss side by side in bootstrap

Flask

• Multiple endpoints in same functions in flask
• Dynamically generate url for assets in flask

Powershell

• Get saved wifi password

Twig

• Dynamically create a table in twig

Mailgun

• Send an email using mailgun with attatchments in php

Css

• How to center things using css

Jinja

• Jinja if else and loops

Google-chrome

• View google chrome extension source code

Metasploit

• Create payload and make it stick

Javascript

• Javascript es 6 notes

Sphinx

• Start stop and reindex in sphinx

.git