This post is mainly a notebook I use to record some practical HiveSQL tricks during daily work. Hopefully it will also make your life easier. Concatenate strings from several rows by SQLWe use the same logic as we
Introduction We use pandas and psycopg2 together to connect with PostgreSQL. psycopg2 is a package allows us to create a connection with PostgreSQL databases in Python, and we will use sqlio within pandas to interact with the database.
crontab is often used in Linux systems to perform automation jobs. crontabcrontab -l # list crontab jobs crontab -e # edit crontab jobs20 10 * * * cd /project/my_project/ && /opt/pythonhome/env/python3/bin/python3.7 /project/my_project/
Dash is an open-sourced Python Dashboard package from plot.ly. It's pretty easy to use and has a lot of components to build beautiful and informative graphs and charts. Install Packagespip install dash==1.4.1 # The core
The latest Raspberry Pi 4B comes with a Gigabit ethernet port, up to 4GB RAM and 2 USB3 port. Because of its low power supply, Raspberry Pi 4 surely has the capability of working as an affordable file
From time to time you might want to migrate your website to a different server/VPS provider. This tutorial highlights some steps you should be very careful about. Improper operation may result in loss of data or files
The latest Raspberry Pi 4 comes with an option of 4G ram. This truly makes the Raspberry Pi a workable personal portable computer. However, the temperature could go pretty high when it is implementing intensive tasks. The simplest
The following notes are under the official Raspbian system. Raspberry Pi 4 Model BShutdownMake sure you are shutting your Raspberry Pi down properly before powering it off. Type sudo halt and wait for the Pi to signal it
