Small markdown files documenting small things I learn every day. These can be anything from a small command to a small code snippet. The goal is to have a collection of small things that I can refer to later.

Aws

• How to download all s3 bucket files
• Upload files to s3 php sdk

Bash

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

Bootstrap

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

Css

• How to center things using css

Docker

• Docker quick commands
• Installation on ubuntu

Ffmpeg

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

Flask

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

Git

• Helpful git commands

Google-chrome

• View google chrome extension source code

Javascript

• Javascript es 6 notes

Jinja

• Jinja if else and loops

Jquery

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

Laravel

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

Linux

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

Mailgun

• Send an email using mailgun with attatchments in php

Metasploit

• Create payload and make it stick

Mysql

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

Php

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

Powershell

• Get saved wifi password

Python

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

Scrapy

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

Sphinx

• Start stop and reindex in sphinx

Twig

• Dynamically create a table in twig

Xampp

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

Youtube-dl

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