ETL and Tools

  • What is ETL?
    ETL is short for extract, transform, load, three database functions that are combined into one tool to pull data out of one database and place it into another database.
    • Extract - reading data from original database
    • Transform - converting extract data from original form to target form. (rules or lookup tables or combining the data with other data)
    • Load - writing data to target database
Read More

Prevent MACBook Sleep

Some 3rd parties can prevent MacBook from sleep. Why does Apple always let MacBook/Air go to sleep when lid is closed and ignore user’s settings?

Read More

Fix Docker Exception - Credentials store error on MacOS

When I run docker-compose command on Mac OS, I hit an error as below:

docker.errors.DockerException: Credentials store error: StoreError('Credentials store docker-credential-osxkeychain exited with "User interaction is not allowed.".',)
Failed to execute script docker-compose
Read More

Nginx Proxy Server Configuration

Example 1:

server {
    listen 80;
    index index.html index.htm index.nginx-debian.html index.php;
    server_name aaa.bbb.ccc.ddd;
    location ~/app2(.*)$ {
        proxy_set_header X-Real-IP  $remote_addr;
        proxy_set_header X-Forwarded-For  $proxy_add_x_forwarded_for;
        proxy_set_header Host $host;
        proxy_pass http://aaa.bbb.ccc.ddd:8001$1;
    }
}
Read More