lao-tseu-is-alive

# Source: https://gist.github.com/b068c3eadbc4140aed14b49141790940

######################
# Create The Cluster #
######################

az login

az provider register -n Microsoft.Network

lao-tseu-is-alive

# Source: https://gist.github.com/d73fb6f4ff490f7e56963ca543481c09

####################
# Create a cluster #
####################

# Follow the instructions from https://github.com/weaveworks/eksctl to intall eksctl if you do not have it already

export AWS_ACCESS_KEY_ID=[...] # Replace [...] with the AWS Access Key ID

lao-tseu-is-alive

# Source: https://gist.github.com/88e810413e2519932b61d81217072daf

######################
# Create The Cluster #
######################

gcloud auth login

# Open https://console.cloud.google.com/cloud-resource-manager to create a new project if you don't have one already

lao-tseu-is-alive

# Source: https://gist.github.com/69bfc361eefd0a64cd92fdc4840f7aed

######################
# Creating A Cluster #
######################

# NOTE: Docker Desktop and Minikube can be used only in some of the exercises

# Docker Desktop with Istio: https://gist.github.com/9a9752cf5355f1b8095bd34565b80aae (docker-istio.sh)
# Minikube with Istio: https://gist.github.com/a5870806ae6f21de271bf9214e523b53 (minikube-istio.sh)

lao-tseu-is-alive

# Source: https://gist.github.com/d81f114a887065a375279635a66ccac2

######################
# Creating A Cluster #
######################

# NOTE: A new and improved cluster creation Gists for GKE, EKS, and AKS

# Docker Desktop with Istio: https://gist.github.com/9a9752cf5355f1b8095bd34565b80aae (docker-istio.sh)
# Minikube with Istio: https://gist.github.com/a5870806ae6f21de271bf9214e523b53 (minikube-istio.sh)

lao-tseu-is-alive

#!/bin/bash
######################################################################################################
### SCRIPT  : sync_db.sh
### AUTHOR  : CGIL <cgil@lausanne.ch>
### DATE    : 2023-05-10
### DESCRIPTION : this script allows to synchronize the database with a backup available in backup_url
### expects one parameter with the name of the database you want to synchronize
### the current dataabse is not renamed to old if the new one does not contain MIN_NUM_TABLES
######################################################################################################
if [ $# -eq 0 ]

lao-tseu-is-alive

cd /opt
mkdir curl_local
cd curl_local/
wget https://curl.se/download/curl-8.0.1.tar.gz
tar xvfz curl-8.0.1.tar.gz 
apt-get install libssl-dev autoconf libtool make build-essential libnghttp2-dev libssl-dev
cd curl-8.0.1/
./buildconf
./configure --with-gnutls --with-openssl --with-kerberos --with-nghttp2
make

lao-tseu-is-alive

# as root
snap list
systemctl disable snapd.service
systemctl disable snapd.socket
systemctl disable snapd.seeded.service
snap remove lxd
snap remove core20 
snap remove snapd
snap list
apt autoremove --purge snapd

lao-tseu-is-alive

/* I got data like this in a table firstname
id    firstname gender  origin  frequency
5220	janis (1)	  m	    latvian	0
5221	janis (2)	  f	    english	0
9841	shay (1)	  m	    irish, english	0
9842	shay (2)	  m,f	  jewish	0
10002	simone (1)	f	    french	0
10003	simone (2)	m	    italian	0

and I need to remove the (1) and group the information in gender, origin and frequency like this :

lao-tseu-is-alive

Server Price Breakdown: DigitalOcean, Amazon AWS LightSail, Vultr, Linode, OVH, Hetzner, Scaleway/Online.net:

Permalink: git.io/vps

$5/mo

Provider	Type	RAM	Cores	Storage	Transfer	Network	Price