ratpik

#List all instances of MySQL that exists by running
brew services

# Remove each instance by running
brew uninstall <instance_name>

#Delete the MySQL directory in /usr/local/var/mysql:
rm -rf /usr/local/var/mysql

# Might need to run brew update here if brew has not been updated for a while

ratpik

#Reference - https://github.com/json-schema-org/json-schema-spec/issues/348#issuecomment-322940347
folderDeleted:
      allOf:
        - $ref: '#/components/schemas/folderCommon'
      properties:
        deletedCollectionItems:
          type: array
          items:
            $ref: '#/components/schemas/collectionItem'
            

ratpik

openssl rand -base64 32

date +%s | sha256sum | base64 | head -c 32 ; echo

< /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c${1:-32};echo;

ratpik

// As of 1st Feb 2022, the VSCode JS Debugger stopped detecting the node version selected using NVM
// Had to install and use NVS
// export NVS_HOME="$HOME/.nvs"
// git clone https://github.com/jasongin/nvs "$NVS_HOME"
// . "$NVS_HOME/nvs.sh" install
// nvs use 14
// Based on the comments here: https://github.com/microsoft/vscode/issues/133521#issuecomment-956108829
{
 // Use IntelliSense to learn about possible attributes.
 // Hover to view descriptions of existing attributes.

ratpik

select * from mytable where category LIKE 'search%' AND client_timestamp BETWEEN timestamp '2020-11-17T00:00:00' AND timestamp '2020-11-18T09:59:29'

ratpik

const assert = require('assert')

let LRUCache = function (capacity) {
 this.capacity = capacity;
 this.cache = {};
 this.head = null;
 this.tail = null;
 this.size = 0;
};

ratpik

# Docker Compose file Reference (https://docs.docker.com/compose/compose-file/)

version: '3.7'

# Define services
services:
  # App backend service
  index-digest:
    image: macbre/index-digest:latest
    # Configuration for building the docker image for the backend service

ratpik

Keybase proof

I hereby claim:

• I am ratpik on github.
• I am pmandrek (https://keybase.io/pmandrek) on keybase.
• I have a public key ASCGIZecGSKe3KKsspNk0kS58-Ce8AP-TPBtHLswDy6IhQo

To claim this, I am signing this object:

ratpik

## View all users who can connect to this database
SELECT `user` FROM `mysql.user`;

## Create a new user in MySQL/AWS MySQL RDS
CREATE USER 'yourusername'@'%' IDENTIFIED BY 'yourpassword';

## List the operations that are permitted for this user
SHOW GRANTS FOR 'yourusername'@'%';
-> GRANT USAGE ON *.* TO 'yourusername'@'%' (Explanation - https://stackoverflow.com/questions/2126225/why-is-a-grant-usage-created-the-first-time-i-grant-a-user-privileges)

ratpik

git for-each-ref --format="%(refname:short) %(taggerdate) %(subject) %(body)" refs/tags