abmmhasan

Popular providers

Provider	Type	Primary DNS	Secondary DNS
Cloudflare	Global	1.1.1.1	1.0.0.1
Cloudflare	Secure	1.1.1.2	1.0.0.2
Cloudflare	Secure+Family	1.1.1.3	1.0.0.3
Google	Global	8.8.8.8	8.8.4.4
Quad9	Secure	9.9.9.9	149.112.112.112
OpenDNS	Global	208.67.222.222	208.67.220.220

abmmhasan

Basic

## Unstage files
git restore --staged .

## Change last commit message (1st one will open editor)
git commit --amend
git commit --amend -m "New commit message"

## Add another repo in existing

abmmhasan

Arch based

• Manjaro
• EndeavourOS

Dabian based

• Debian (itself), Unofficial non-free firmaware included, Unofficial non-free firmaware included (weekly build: direct download)
• VanillaOS
• Deepin
• Mint

abmmhasan

Install some required

# vim
sudo apt install vim curl wget git

Install nix package manager (https://github.com/NixOS/nix)

• https://nix-tutorial.gitlabpages.inria.fr/nix-tutorial/getting-started.html
• https://nixos.org/manual/nix/stable/
• https://christitus.com/nix-package-manager/

abmmhasan

1. Buy a Raspberry Pi (or any low-cost PC build)

At first buy a Raspberry Pi (I recommend Zero edition for minimum cost) with casing (official one is enough for Zero). My configuration:

• Rapberry Pi Zero with Official Casing (used the Cover with Center Hole)
• MicroSD card
• Micro-USB to LAN converter (can be replaced with OTG Cable + USB to LAN converter)
• Micro-USB power cable
• LAN connection cable

2. Prepare OS

abmmhasan

-- Import(FROM) / Export(TO) CSV file from/into a table
-- Ref: https://www.postgresql.org/docs/current/sql-copy.html
-- If processing all columns, no need column specification
-- If CSV file don't include header, remove 'HEADER' from below query
-- For Export, can also specify Query, instead of Table & Column name
COPY table_name (column_1, column_2, column_3, column_5) 
[FROM/TO] 'csv_file_location' DELIMITER ',' CSV HEADER QUOTE '"' ESCAPE '"'

-- Dump database on remote host to file
-- Ref: https://www.postgresql.org/docs/current/app-pgdump.html