DEV Community: Meng Ly

Changing App Icon in Flutter

Meng Ly — Thu, 14 Nov 2024 13:55:12 +0000

Introduction:

Here's a quick guide to changing the app icon in a Flutter application. We’ll cover the steps to navigate the project structure, set up correctly sized images, and follow best practices. Plus, we’ll include links to free icon generators for easy customization.

Step 1: Navigate to the Root Folder Structure

To change the app icon, navigate to the root folder of your Flutter project. Here, you'll find the files needed to replace the default icon.

flutter pub add

flutter pub run flutter_launcher_icons

Step 2: Replace the Default App Icon Image

In the root folder structure, locate the android and ios directories. Inside these directories, you will find subdirectories named res and Assets.xcassets, respectively. These directories contain the image files for the app icons. Replace the default app icon image files with your custom app icon images. Make sure to follow the image size specifications for each platform.

Step 3: Image Size Specifications

It’s important to follow the image size specifications for each platform to ensure that the app icon looks good on all devices. Here are the recommended image sizes:

Android:

mipmap-mdpi: 48x48 pixels
mipmap-hdpi: 72x72 pixels
mipmap-xhdpi: 96x96 pixels
mipmap-xxhdpi: 144x144 pixels
mipmap-xxxhdpi: 192x192 pixels
mipmap-xxxxhdpi: 512x512 pixels

IOS:

20x20 pixels
29x29 pixels
40x40 pixels
60x60 pixels
76x76 pixels
83.5x83.5 pixels
1024x1024 pixels And more sizes may be required for specific devices and situations.

Contact Me:

*Telegram: * https://t.me/MenglyUch
*TikTok: * https://www.tiktok.com/@mengly9662

MySQL cheatsheet

Meng Ly — Fri, 01 Nov 2024 01:03:59 +0000

1. Browsing

SHOW DATABASES;
SHOW TABLES;
SHOW FIELDS FROM table / DESCRIBE table;
SHOW CREATE TABLE table;
SHOW PROCESSLIST;
KILL process_number;

2. Select

SELECT * FROM table;
SELECT * FROM table1, table2;
SELECT field1, field2 FROM table1, table2;
SELECT ... FROM ... WHERE condition
SELECT ... FROM ... WHERE condition GROUP BY field;
SELECT ... FROM ... WHERE condition GROUP BY field HAVING condition2;
SELECT ... FROM ... WHERE condition ORDER BY field1, field2;
SELECT ... FROM ... WHERE condition ORDER BY field1, field2 DESC;
SELECT ... FROM ... WHERE condition LIMIT 10;
SELECT DISTINCT field1 FROM ...
SELECT DISTINCT field1, field2 FROM ...

3. Select-Join

SELECT ... FROM t1 JOIN t2 ON t1.id1 = t2.id2 WHERE condition;
SELECT ... FROM t1 LEFT JOIN t2 ON t1.id1 = t2.id2 WHERE condition;
SELECT ... FROM t1 JOIN (t2 JOIN t3 ON ...) ON ...

4. Conditions

field1 = value1
field1 <> value1
field1 LIKE 'value _ %'
field1 IS NULL
field1 IS NOT NULL
field1 IS IN (value1, value2)
field1 IS NOT IN (value1, value2)
condition1 AND condition2
condition1 OR condition2

5. Create / Open / Delete Database

CREATE DATABASE DatabaseName;
CREATE DATABASE DatabaseName CHARACTER SET utf8;
USE DatabaseName;
DROP DATABASE DatabaseName;
ALTER DATABASE DatabaseName CHARACTER SET utf8;

6. Backup Database to SQL File

mysqldump -u Username -p dbNameYouWant > databasename_backup.sql

7. Restore from backup SQL File

mysql -u Username -p dbNameYouWant < databasename_backup.sql;

8. Repair Tables After Unclean Shutdown

mysqlcheck --all-databases;
mysqlcheck --all-databases --fast;

9. Insert

INSERT INTO table1 (field1, field2) VALUES (value1, value2);

10. Delete

DELETE FROM table1 / TRUNCATE table1
DELETE FROM table1 WHERE condition
DELETE FROM table1, table2 WHERE table1.id1 =
  table2.id2 AND condition

11. Update

UPDATE table1 SET field1=new_value1 WHERE condition;
UPDATE table1, table2 SET field1=new_value1, field2=new_value2, ... WHERE
  table1.id1 = table2.id2 AND condition;

12. Create / Delete / Modify Table

12.1 Create

CREATE TABLE table (field1 type1, field2 type2);
CREATE TABLE table (field1 type1, field2 type2, INDEX (field));
CREATE TABLE table (field1 type1, field2 type2, PRIMARY KEY (field1));
CREATE TABLE table (field1 type1, field2 type2, PRIMARY KEY (field1,field2));

CREATE TABLE table1 (fk_field1 type1, field2 type2, ...,
  FOREIGN KEY (fk_field1) REFERENCES table2 (t2_fieldA))
    [ON UPDATE|ON DELETE] [CASCADE|SET NULL]

CREATE TABLE table1 (fk_field1 type1, fk_field2 type2, ...,
 FOREIGN KEY (fk_field1, fk_field2) REFERENCES table2 (t2_fieldA, t2_fieldB))

CREATE TABLE table IF NOT EXISTS;

CREATE TEMPORARY TABLE table;

12.2 Delete

DROP TABLE table;
DROP TABLE IF EXISTS table;
DROP TABLE table1, table2, ...

12.3 Modify

ALTER TABLE table MODIFY field1 type1
ALTER TABLE table MODIFY field1 type1 NOT NULL ...
ALTER TABLE table CHANGE old_name_field1 new_name_field1 type1
ALTER TABLE table CHANGE old_name_field1 new_name_field1 type1 NOT NULL ...
ALTER TABLE table ALTER field1 SET DEFAULT ...
ALTER TABLE table ALTER field1 DROP DEFAULT
ALTER TABLE table ADD new_name_field1 type1
ALTER TABLE table ADD new_name_field1 type1 FIRST
ALTER TABLE table ADD new_name_field1 type1 AFTER another_field
ALTER TABLE table DROP field1
ALTER TABLE table ADD INDEX (field);

12.4 Change field order

ALTER TABLE table MODIFY field1 type1 FIRST
ALTER TABLE table MODIFY field1 type1 AFTER another_field
ALTER TABLE table CHANGE old_name_field1 new_name_field1 type1 FIRST
ALTER TABLE table CHANGE old_name_field1 new_name_field1 type1 AFTER
  another_field

13. Keys

CREATE TABLE table (..., PRIMARY KEY (field1, field2))
CREATE TABLE table (..., FOREIGN KEY (field1, field2) REFERENCES table2
(t2_field1, t2_field2))

14. Users and Privileges

CREATE USER 'user'@'localhost';
GRANT ALL PRIVILEGES ON base.* TO 'user'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, DELETE ON base.* TO 'user'@'localhost' IDENTIFIED BY 'password';
REVOKE ALL PRIVILEGES ON base.* FROM 'user'@'host'; -- one permission only
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'host'; -- all permissions
FLUSH PRIVILEGES;

SET PASSWORD = PASSWORD('new_pass');
SET PASSWORD FOR 'user'@'host' = PASSWORD('new_pass');
SET PASSWORD = OLD_PASSWORD('new_pass');

DROP USER 'user'@'host';

15. Reset Root Password

$ /etc/init.d/mysql stop
$ mysqld_safe --skip-grant-tables
$ mysql # on another terminal
mysql> UPDATE mysql.user SET password=PASSWORD('new_pass') WHERE user='root';
## Switch back to the mysqld_safe terminal and kill the process using Control + \
$ /etc/init.d/mysql start

Laravel deployment with dokku

Meng Ly — Thu, 19 Sep 2024 14:23:45 +0000

Deploy Laravel With Dokku

1. Dokku

Dokku as a special helper that takes your favorite toys and puts them in a big play area so you and your friends can play with them whenever you want.

2. Dokku Installation

System Requirement

Operating Systems
Ubuntu 20.04/22.04
Debain 10+ x64
Min 1GB of system Memory # 3. Install Dokku To install the latest stable version of Dokku, you can run the following shell commands:

wget -NP . https://dokku.com/install/v0.34.4/bootstrap.sh
sudo DOKKU_TAG=v0.34.4 bash bootstrap.sh

4. Administrator to Dokku

Add SSH key

cat ~/.ssh/authorized_keys | dokku ssh-keys:add admin

5.Database on Dokku

Install MYSQL

To install the mysql plugin, you can run the following shell commands:

sudo dokku plugin:install https://github.com/dokku/dokku-mysql.git mysql

6.Deployment

Deploy Laravel App to dokku

Create an app on dokku

dokku apps:create my-app

Create database

dokku mysql:create my-database

Link database to the app

dokku mysql:link my-database my-app

Setup PHP Buildpack

Crate file .buildpacks in your project and paste these code

https://github.com/heroku/heroku-buildpack-php
https://github.com/heroku/heroku-buildpack-nodejs

Create the Procfile in the project directory

release: php artisan migrate --force && composer dumpautoload web: vendor/bin/heroku-php-apache2 -i php_custom.ini public/

Create the php_ custom.ini in the project directory

Enable php plugin

upload_max_filesize = 3000M 
post_max_size = 3000M 
memory_limit = 256M 
max_execution_time = 300 
max_input_time = 300 
max_input_vars = 10000 
max_file_uploads = 20 
max_upload_filesize = 3000M

Config .ENV to the dokku app

Example: mysql://mysql:2f4629asdf309a7d@dokku-mysql-my-database:3306/my_database
Example: DB_CONNECTION://DB_USERNAME:DB_PASSWORD@DB_HOST:3306/DB_DATABASE

dokku config:set my-app APP_ENV=production 
dokku config:set my-app APP_KEY=yoursecretkeyinserthere 
dokku config:set my-app DB_CONNECTION=mysql 
dokku config:set my-app DB_HOST=dokku-mysql-my-database
dokku config:set my-app DB_DATABASE=my_database
dokku config:set my-app DB_USERNAME=mysql 
dokku config:set my-app DB_PASSWORD=2f4629asdf309a7d

Setup Domain

Buy a domain name on NameCheap
More details baout domains (https://dokku.com/docs/configuration/domains/)

dokku domains:set <app> <domain>

Setup HTTPS

More details about letsencrypt (https://github.com/dokku/dokku-letsencrypt)
Documents

$ dokku letsencrypt:help
    letsencrypt:active <app>                Verify if letsencrypt is active for an app
    letsencrypt:auto-renew                  Auto-renew all apps secured by letsencrypt if renewal is necessary
    letsencrypt:auto-renew <app>            Auto-renew app if renewal is necessary
    letsencrypt:cleanup <app>               Cleanup stale certificates and configurations
    letsencrypt:cron-job <--add|--remove>   Add or remove an auto-renewal cronjob
    letsencrypt:disable <app>               Disable letsencrypt for an app
    letsencrypt:enable <app>                Enable or renew letsencrypt for an app
    letsencrypt:list                        List letsencrypt-secured apps with certificate expiry
    letsencrypt:revoke <app>                Revoke letsencrypt certificate for app

What we do

sudo dokku plugin:install https://github.com/dokku/dokku-letsencrypt.git 
sudo dokku plugin:update letsencrypt 
dokku letsencrypt:set app-name email 
dokku letsencrypt:enable

Add remote repository

git remote add dokku dokku@your_instance_ip:my-app

Deploy in just one command

git push dokku main

Thanks you so much guysss.