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
Xampp
Bootstrap
Flask
Powershell
Twig
Mailgun
Css
Jinja
Google-chrome
Metasploit
Javascript
Sphinx
.git