Author: Tommy Elmesewdy

Data Janitor

Categories
github

GitHub Container Registry

General https://ghcr.io https://github.blog/2020-09-01-introducing-github-container-registry/ Note: GitHub Container Registry is free for public images. Container Registry is free for private images during the beta, and as part of GitHub Packages will follow the same pricing model when generally available. Create personal token https://docs.github.com/en/authentication/keeping-your-account-and-data-secure/creating-a-personal-access-token Go to https://github.com/settings/tokens. Click Generate new token. Permissions: write:packages / read:packages delete:packages Click Generate token. Copy […]

Categories
General

Push to Google Cloud Registry

https://cloud.google.com/container-registry/docs/overview https://cloud.google.com/container-registry/docs/pushing-and-pulling Auth gcloud auth logingcloud auth configure-docker Pull # Option 1 – pull from Docker Hub docker pull [USERNAME]/[IMAGE]:[TAG] # Option 2 – pull from GCR docker pull [REPOSITORY_NAME]/[FOLDER]/[IMAGE]:[TAG] Example # Option 1 – pull from Docker Hub docker pull itsmetommy/go-guestbook:latest # Option 2 – pull from GCR docker pull us.gcr.io/[PROJECT_ID]/itsmetommy/go-guestbook:latest Tag Note: Use […]

Categories
docker sql

Docker: MySQL

https://hub.docker.com/r/mysql/mysql-server/ Download docker pull mysql/mysql-server:latest Create Option 1 – docker run docker run -d \ –name mysql-itsmetommy \ -p 3306:3306 \ –env=”MYSQL_ROOT_PASSWORD=password” \ mysql/mysql-server:latest Option 2 – docker-compose cat <<EOF > docker-compose.yml version: ‘3.8’ services: db: image: mysql:latest restart: always environment: MYSQL_DATABASE: ‘db’ # Optional user account MYSQL_USER: ‘tommy’ # Password for optional user account […]

Categories
Code

Markdown Preview using Sublime Text

Preview and build your markdown files (e.g. README.md) in your web browser using Sublime Text. https://github.com/facelessuser/MarkdownPreview Install Open Command Palette. Option 1: Type control+shift+p Option 2: Tools → Command Palette… Type “install” and select “Package Control: Install“. Type “markdownpreview” and select it. Restart Sublime Text. Open your README.md file. Example Open the Command Palette and type “markdown preview“. Select “Markdown Preview: Preview […]

Categories
postgresql sql

Securing PostgreSQL using Host Based Authentication (HBA)

HBA stands for Host-base Authentication. The pg_hba.conf config file controls the authentication method. By default, local connections to Postgres uses peer authentication. That means that instead of asking you for a password, it checks to see if you are currently logged in as a system user that matches the user name in Postgres. This is where […]