Blog: Settings

Blog

Add a new blog
July 13

Flutter notes

1. setup coding env. for Andriod & iOS Anrioid download Android stuidio and install it: https://developer.android.com/studio  and download for Flutter for Mac: https://flutter.dev/docs/get-started/install/macos   (tip: you might want to use https://code.visualstudio.com/docs/?dv=osx for IDE) iOS xxx 2. modify, run, and deploy modify: change the code as you need run: (android) visual studio terminal: $ flutter emulators  (get list of devices) $ flutter emulators --launch pixel (launch it) $ flutter run  (compile and run) deploy andriod go to /andriod/app/build.gradle and uncomment the {splits}...

May 28

Tips for linux/ubuntu 'du' for hidden files

du -sch .[!.]* * |sort -h ...

May 13

Use /etc/hosts to direct wildcard domain name

You need to set up a DNS server. (install dnsmasq (is light) or bind (is rather heavy)). To install... Ubuntu OS: sudo apt-get install dnsmasq In /etc/NetworkManager/dnsmasq.d/dnsmasq-localhost.conf and address=/localhost.com/127.0.0.1 restart sudo /etc/init.d/dnsmasq restart with Mac OS: Install dnsmasq brew update # Always update Homebrew and the formulae first brew install dnsmasq sudo brew services start dnsmasq sudo brew services start dnsmasq Configure dnsmasq Its default configuration file is located at /usr/local/etc/dnsmasq.conf and contains examples of...

May 5

Fast and easy way to create free logo online in minutes

1. Use https://logojoy.com to create your ideal logo (you don't need to buy it from them). 2. get your SVG code and paste into any html page. 3. use SVG to PNG tool online with https://ezgif.com/svg-to-png by copying your SVG code url into the SVG to PNG tool online to download your PNG file. All free, and you will have your free logo in minutes if you...

April 17

Remove or revoke DB access or privileges from mysql user both local and remote

Remove or revoke DB access or privileges from mysql user both local and remote: REVOKE ALL PRIVILEGES ON *.* FROM 'plugins_dbuser'@'localhost'; REVOKE ALL PRIVILEGES ON *.* FROM 'plugins_dbuser'@'%'; ...

April 15

Update a column value, replacing part of a string

here is how we can replace partial of the string on all rows in MySQL:  UPDATE my_table_name SET my_field_name = REPLACE(my_field_name, 'unwanted-string', 'new-string'); ...

March 9

Rsync (Remote Sync)

Basic syntax of rsync command # rsync options source destination Some common options used with rsync commands -v : verbose -r : copies data recursively (but don’t preserve timestamps and permission while transferring data -a : archive mode, archive mode allows copying files recursively and it also preserves symbolic links, file permissions, user & group ownerships and timestamps -z : compress file data -h : human-readable, output...

February 9

MySQL - Merge two user groups users into one current group, and delete the second group.

Merge two user groups users into one current group, and delete the second group. Note: some users might be in both groups already. # Show users in groupID 111 are also in groupID 222 SELECT user_id FROM user_group  WHERE user_group_id={111} AND user_id IN (SELECT user_id FROM user_group WHERE user_group_id={222} )  # Change user_group_id 222 to 111. Use 'UPDATE IGNORE'  assume user_id & user_group_id are unique index UPDATE IGNORE user_group  SET user_group_id={111} WHERE...

December 27

Website loading speed tester

Test your website loading speed world wide: https://www.dotcom-tools.com/website-speed-test.aspx ...

Experteer's Scripting: Coding - Experts Only
Send us a message. We will reply as soon as we can.
×