Bivek

# Getting clang error while installing mysql gem in macos
# Try this it might solve your issue or try trinity gem instead
gem install mysql2 -v '0.5.5' -- --with-mysql-config=$(brew --prefix mysql)/bin/mysql_config --with-ldflags="-L$(brew --prefix zstd)/lib -L$(brew --prefix openssl)/lib" --with-cppflags=-I$(brew --prefix openssl)/include

Bivek

1. Show data lock held or requested (https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html)
    
    mysql> SELECT * FROM performance_schema.data_locks

2. General information about tables
    
    mysql> SHOW TABLE STATUS

3. Show table information

Bivek

Working solution
-----------------
gem install mysql2 -v '0.5.5' -- --with-mysql-config=$(brew --prefix mysql)/bin/mysql_config --with-ldflags="-L$(brew --prefix zstd)/lib -L$(brew --prefix openssl)/lib" --with-cppflags=-I$(brew --prefix openssl)/include


Better to use ```trilogy``` gem instead of ```mysql2``` for smooth setup process.

In your database.yml file update adapter to trilogy if you are using trilogy instead.

Bivek

#STEP1: SET Max lenght according the need
SET group_concat_max_len = 40048;

#STEP2: Execute this to get the query that needs to be executed
SELECT left(tab, length(tab)-6) AS query
FROM (
	SELECT GROUP_CONCAT(tab SEPARATOR ' ') AS tab
	FROM (
		SELECT CONCAT(
		    'SELECT "', 

Bivek

alias k="kubectl"
kubectl get deploy
kubectl get services
kubectl get svc
kubectl create deployment nginx-deployment --image=nginx
kubectl get pods
kubectl expose deployment nginx-deployment --port=8080 --port-target=80
kubectl get svc
minikube ip
ssh docker@<above-ip> (default password is tcuser)

Bivek

IRB.conf[:USE_READLINE] = false
rails console -- --nomultiline
#defaults write com.microsoft.VSCode ApplePressAndHoldEnabled -bool false
#defaults write -g ApplePressAndHoldEnabled -bool false

Bivek

Complete ES Guide

• Getting Started
• Managing Documents
• Mapping
• Analysis & Analyzers
• Introduction to Searching
• Term Level Queries
• Full Text Queries
• [Adding Boolean Logic to Queries](https://github.com/codingexplained/complete-guide-to-elasticsearch/tree/

Bivek

set -e, -u, -o, -x pipefail

The set lines

• These lines deliberately cause your script to fail. Wait, what? Believe me, this is a good thing.
• With these settings, certain common errors will cause the script to immediately fail, explicitly and loudly. Otherwise, you can get hidden bugs that are discovered only when they blow up in production.

• set -euxo pipefail is short for:

set -e
set -u

Bivek

1.next # => 2

next_method_object = 1.method("next")
next_method_object.call # => 2

arr = ['Ruby', 'Golang', 'Node.js', 'Deno', 'Typescript', 'Scala', 'Python']

arr.[](3) # => Deno

def add(*numbers)

Bivek

import boto3
import urllib.request

def lambda_handler(event, context):
    # Anuska Sharma Images
    #source_file='https://www.pinkvilla.com/files/styles/contentpreview/public/anushka_sharma_prays_for_those_affected_by_uttarakhand_glacier_burst_main_1.jpg'
    # target_file='https://m.media-amazon.com/images/M/MV5BNGM5YmYwNjUtNzQyYS00OGY0LTljZDAtMDNiMjhiOTFiMzRiXkEyXkFqcGdeQXVyMTExNDQ2MTI@._V1_UY317_CR3,0,214,317_AL_.jpg'
    # Katrina Kaif Images
    source_file = 'https://cdn.dnaindia.com/sites/default/files/styles/full/public/2020/03/21/898813-katrina-kaif-coronavirus-video-public-transport-1.jpg'
    target_file = 'https://author.vogue.in/wp-content/uploads/2020/07/Katrina-Kaif-during-Bharat-promotions-1366x768.jpg'