nanusdad / mariadb-cheatsheet.md

Created December 20, 2022 11:31

MariaDB cheatsheet

MariaDB (MySQL) cheatsheet

Create database and add user with access

# Create db
CREATE DATABASE 'testDB';

# Create user on localhost
CREATE USER 'user1'@localhost IDENTIFIED BY 'password1';
# for all hosts
CREATE USER 'user1'@'%' IDENTIFIED BY 'password1';

nanusdad / getting-started-with-Meteor-on-Alpine-Linux.md

Last active October 12, 2022 11:59

Getting started with Meteor on Alpine Linux

Install Alpine Linux Virtual ISO

wget https://dl-cdn.alpinelinux.org/alpine/v3.16/releases/x86_64/alpine-virt-3.16.2-x86_64.iso
# Get the version you need at https://alpinelinux.org/downloads/

Make sure the environment variable for the proxy server is set correctly

export HTTP_PROXY=http://user:pass@http://proxy_server:proxy_port

nanusdad / getting-started-with-Meteor-on-Ubuntu.md

Last active October 10, 2022 07:26

Getting started with Meteor Ubuntu

Create appuser group
Create appuser
Login as appuser

su - appuser

Install nvm

5. Install Meteor

nanusdad / ssl-cert-on-ubuntu-lightsail-for-Moodle.md

Last active February 21, 2025 00:49

Setting up LetsEncrypt SSL certificate for Moodle on Ubuntu

Install certbot

sudo apt install certbot python3-certbot-apache

Enable firewall to allow Apache https and ssh

sudo ufw status
sudo ufw enable

nanusdad / linux-package-installation-and-management.md

Created January 25, 2022 08:10

Linux (Ubuntu / Debian) package installation and management

List packages

apt list --installed
dpkg -l

Remove package

sudo apt-get remove

nanusdad / gitlab-backup-and-restore.md

Last active July 22, 2023 06:03

Gitlab backup and restore notes

Backup (on old server)

sudo gitlab-backup create
#backup is available in
cd /var/opt/gitlab/backups
cp 1643*.tar /tmp
cd /tmp
gzip 1643*.tar

nanusdad / face-crop.md

Created October 8, 2021 06:43

Face Cropping

OpenCV module - https://www.npmjs.com/package/opencv-facecrop

nanusdad / indian-postal-code.md

Last active October 8, 2021 06:42

Indian Postal Code

API to get postal code details - https://api.postalpincode.in/pincode/632011
Using Google Maps API

https://maps.googleapis.com/maps/api/geocode/json?key={API_KEY}&components=postal_code:110011

nanusdad / embedding-videos.md

Last active October 8, 2021 06:39

Embedding videos

Use <video> HTML element - w3schools
Disabling picture-in-picture

<video controls disablePictureInPicture controlsList="nodownload">
  <source src="https://www.w3schools.com/html/mov_bbb.ogg" type="video/mp4">
  <source src="https://www.w3schools.com/html/mov_bbb.mp4" type="video/ogg">
</video>

Disabling picture-in-picture with JavaScript

nanusdad / ffmpeg-cheat-sheet.md

Created May 20, 2021 04:25

FFMPEG cheat sheet

FFMPEG Cheat sheet

Compress MP4 files

ffmpeg -i input.mp4 -vcodec libx265 -crf 28 output.mp4

Compressed file to better compatibility (WhatsApp)

ffmpeg -i broken.mp4 -c:v libx264 -profile:v baseline -level 3.0 -pix_fmt yuv420p working.mp4

nanusdad