Image compression with Squoosh

Squoosh is a tool made by the Google Chrome Community.
I personally recommend this tool. Everything is handled locally, so no additional data is sent to the server

Squoosh is an image compression web app that allows you to dive into the advanced options provided by various image compressors.

Squoosh Github Repository

Here’s a quick tutorial for you πŸ€“

  • Select an image or multiple images you want to compress
  • Drag and drop it into the application
  • Modify the settings
  • Click the blue icon in the bottom right corner to download the compressed image

Give it a try! πŸ‘

Add SSH key to authorized_keys

Add SSH key to authorized_keys

It has been always a pain to put your server’s password every damn time. You can add your key to the authorized_keys of the server. Here’s how you do it

Generate your SSH key if you don’t have one already.

ssh-keygen -t rsa -b 2048

Copy your generated SSH key to the server
Insert the password of your server when prompted

ssh-copy-id [email protected]

Connect to the server without a password πŸ”₯

ssh [email protected]

Convert MySQL table and columns to UTF-8

MySQL to UTF-8 encoding

Changing to UFT-8 encoding can be a pain when you’re doing it from a GUI like MySQL Workbench.
There’s always an easier way to do it with some basic SQL.

The utf8 in mySQL doesn’t actually create a real UTF8 database. It creates a proprietary subset. Real UTF8 in MySQL is called utf8mb4.

-- convert the data that already exists to the character set utf-8
ALTER TABLE <table> CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- change the character set to utf-8
ALTER TABLE <table> DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- change specific columns
ALTER TABLE <table> CHANGE <column_name> <column_name> VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Read the full article here