Andy Chiang大滷麵式的系統設計接到一個功能需求要在某個封閉式系統運作,可這個系統僅包裝了一些看不到底層的模組,只有其公開出來的函式可用,因此在開發過程中踩了不少坑啊。Feb 2, 2023Feb 2, 2023
Andy ChiangMBP to Serial Port (mini UART on Raspberry Pi)Cable is the most Important thing, pick a USB to TTL RS232/UART Serial Converter AdapterFeb 15, 2022Feb 15, 2022
Andy ChiangCan not start PyCharm IDE 2020.3 via JetBrain ToolBox on Mac OS XIf you upgrade PyCharm old version (ex: 2020.2) to 2020.3 and you get this alert…..Jan 6, 2021Jan 6, 2021
Andy ChiangBatch drop foreign keys in postgreSQLI have lots tables need to remove foreign keys constraints, but I dont want to open table and delete it one by one, so I GOOGLE and found…Jul 22, 2020Jul 22, 2020
Andy ChiangPostgreSQL 12 的 timezone 修改在安裝 PostgreSQL 12 之後,雖然時區內建預設是 GMT,但由於用了 initdb 這個指令,他便根據 OS 的 timezone 設定,把 $PGDATA/postgesql.conf 裡面的 timezone 和 log_timezone 設定為系統時區Mar 31, 2020Mar 31, 2020