1
November 02, 2019, 12:07:28 pm
esptool.py erase_flash https://github.com/espressif/ESP8266_NONOS_SDK/archive/v3.0.1.tar.gz esptool.py -p /dev/tty.usbserial-A603AYEQ --chip esp8266 write_flash --flash_size 2MB-c1 0x00000 boot_v1.2.bin 0x01000 at/1024+1024/user1.2048.new.5.bin 0x1fc000 esp_init_data_default_v05.bin 0xfe000 blank.bin 0x1fb000 blank.bin 0x1fe000 blank.bin
2
November 01, 2019, 08:50:40 pm
Connect the ESP8266-12E as follows;GPIO15 - GND GPIO02 - VCC GPIO00- GND RESET - GND ( Temporarily ) TX - RX RX - TX pip install esptool https://github.com/espressif/ESP8266_NONOS_SDK/archive/v2.2.1.zip Extract files and go to bin/ Run the following command and reset the chip esptool.py --port /dev/tty.usbserial-A603AYEQ --baud 115200 write_flash --flash_mode dio 0x00000 boot_v1.2.bin 0x01000 at/512+512/user1.1024.new.2.bin 0x7B000 blank.bin 0x3FC000 esp_init_data_default_v05.bin 0x7E000 blank.bin
3
October 20, 2018, 12:15:49 pm
find . -type f -name '*.php' -exec php -l {} \;
4
October 20, 2018, 12:05:30 pm
find /home/tino/YAPortal/ -type f -exec sed -i 's/@version 1.0.1/@version 1.0.2/g' {} \;
5
July 08, 2018, 06:59:48 pm
Linuxfind . -type f -name '*.txt' -exec sed --in-place 's/[[:space:]]\+$//' {} \+ macOSfind . -iname '*.txt' -type f -exec sed -i '' 's/[[:space:]]\{1,\}$//' {} \+
12
May 05, 2017, 10:57:38 pm
Show running queries (9.2)SELECT pid, age(query_start, clock_timestamp()), usename, query FROM pg_stat_activity WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' ORDER BY query_start desc; kill running querySELECT pg_cancel_backend(procpid); Kill idle querySELECT pg_terminate_backend(procpid);
13
May 05, 2017, 10:54:31 pm
Compare two rows SELECT T1.log_dt, T2.log_dt, EXTRACT(EPOCH FROM (T2.log_dt - T1.log_dt)) FROM power_data AS T1 INNER JOIN power_data AS T2 USING ( node ) WHERE T1.log_dt > '2017-05-05 22:10:00' AND T2.log_dt > '2017-05-05 22:10:00' ORDER BY T1.id, T2.id LIMIT 2
14
May 04, 2017, 05:08:41 pm
#define ATOMIC for(INTCONbits.GIE=0;!INTCONbits.GIE;INTCONbits.GIE=1)
15
February 26, 2017, 07:07:35 pm
class MyClass { public function __construct() { echo 'I am initialized!'; } } $getMyClass = function() { $myClass = new MyClass(); return $myClass; }; $myClass = $getMyClass();