Novokreshchenov Konstantin novokrest

#!/bin/bash

db_set () { echo "$1,$2" >> database }

db_get () { grep "^$1," database | sed -e "s/^$1,//" | tail -n 1 }

See also:

Service	Type	Storage	Limitations
Amazon DynamoDB	⚠️ Proprietary NoSQL	25 GB	⚠️ Payment method required
Amazon RDS	⚠️ Proprietary RDBMS		⚠️ Only free for 1 year
Azure SQL Database	MS SQL Server		⚠️ Only free for 1 year
👉 Clever Cloud	PostgreSQL, MySQL, MongoDB, Redis	256 MB (PostgreSQL)	Max 5 connections (PostgreSQL)

Vagrant and VMWare Tech Preview on Apple M1 Pro

This document summarizes notes taken while to make the VMWare Tech preview work on Apple M1 Pro, it originated from discussions in hashicorp/vagrant-vmware-desktop#22

Created on: November 1, 2021 Updated on: September 17, 2022

Installing Rosetta

Installing Postgres via Brew

Pre-Reqs

Brew Package Manager

In your command-line run the following commands:

brew doctor
brew update

You have to do 2 things in order to allow your container to access your host's postgresql database

Make your postgresql listen to an external ip address
Let this client ip (your docker container) access your postgresql database with a given user

Obs: By "Host" here I mean "the server where docker is running on".

Make your postgresql listen to an external ip address

Find your postgresql.conf (in case you don't know where it is)

$ sudo find / -type f -name postgresql.conf

	# https://www.codementor.io/@engineerapart/getting-started-with-postgresql-on-mac-osx-are8jcopb

	brew install postgresql
	pg_ctl -D /usr/local/var/postgres start && brew services start postgresql

	# check
	postgres -V

	psql postgres
	-- CREATE ROLE username WITH LOGIN PASSWORD 'quoted password';

	# https://medium.com/coding-blocks/creating-user-database-and-adding-access-on-postgresql-8bfcd2f4a91e
	# https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-18-04
	# https://www.liquidweb.com/kb/how-to-remove-postgresql/

	$ export LANGUAGE="en_US.UTF-8"
	$ echo 'LANGUAGE="en_US.UTF-8"' >> /etc/default/locale
	$ echo 'LC_ALL="en_US.UTF-8"' >> /etc/default/locale
	$ sudo locale-gen en_US en_US.UTF-8
	$ sudo dpkg-reconfigure locales

	# https://kifarunix.com/install-java-11-on-debian-9-8-ubuntu-18-04/

	sudo apt install software-properties-common
	sudo add-apt-repository ppa:linuxuprising/java
	sudo apt update

	# check
	sudo apt-cache policy oracle-java11-installer-local

	mkdir -p /var/cache/oracle-jdk11-installer-local

	import os
	import sys
	import argparse
	import subprocess
	import requests as r
	from os import path
	from urllib.parse import urlparse

	class Creds:
	def __init__(self, team_name, auth, ssh_host_alias):

	# https://www.liquidweb.com/kb/how-to-remove-postgresql/
	dpkg -l \| grep postgres
	sudo apt-get --purge remove pgdg-keyring postgresql-10 postgresql-client-10 postgresql-client-common postgresql-common