Import data from local to postgreSQL and pgAdmin4 running on Docker

Copy the csv file to a local folderOpen pgAdmin4 and select the table where you want to import the data intoRight click and select Import/Export Select the Import option and click on three dots for file name Click on the icon highlighted in red which is to drag file Drag the file that you want … Continue reading Import data from local to postgreSQL and pgAdmin4 running on Docker

Run PostgreSQL and pgAdmin in docker for local development using docker compose

create a directory mkdir postgres-docker && cd postgres-dockercreate a file and name it as docker-compose.yml Add the following content in the docker-compose,yml file version: "3.8" services: db: image: postgres container_name: local_pgdb restart: always ports: - "54320:5432" environment: POSTGRES_USER: user POSTGRES_PASSWORD: admin volumes: - local_pgdata:/var/lib/postgresql/data pgadmin: image: dpage/pgadmin4 container_name: pgadmin4_container restart: always ports: - "5050:80" environment: … Continue reading Run PostgreSQL and pgAdmin in docker for local development using docker compose

Calendar Terminal Utility for Mac.

Just found this calendar utility which can be used in mac. To see the current month's calendar, type "cal To see the current month's calendar along with week type "ncal" To see the current month's calendar along with week number type "ncal -w" To see the 3 month's calendar(previous, current and next month) along with … Continue reading Calendar Terminal Utility for Mac.

Infrastructure as Code (IaC) & Pulumi

Infrastructure as code(IaC) is a very important element in an organizations cloud adoption journey. It helps to bring consistency, standard, speed and most importantly leverage drive cost optimization on cloud. Infrastructure is the underlying computing machinery example physical server, database, network , storage etc which is required for a software to run. In the absence … Continue reading Infrastructure as Code (IaC) & Pulumi