gnzsnz

Creating GPG keys and subkeys

There are the steps to create GPG key pair and the additional steps to create a subkey.

Create GPG keys

gpg --full-generate-key
Please select what kind of key you want:

gnzsnz

Install latest version

sudo apt install postgresql-16 postgresql-client-16

List clusters

sudo pg_lsclusters

gnzsnz

Create postgres user and database

How to create a user, a database and grant all privileges on the new database?

sudo -u postgres psql
postgres=# CREATE DATABASE mydb;
postgres=# CREATE USER myuser WITH ENCRYPTED PASSWORD 'mypass';
postgres=# GRANT ALL PRIVILEGES ON DATABASE mydb TO myuser;
postgres=# GRANT ALL ON SCHEMA public TO myuser;

gnzsnz

How to use semaphores in asyncio

A short example showing asyncio semaphores

import asyncio
import time
from random import random

async def my_coroutine(sem,task_id):

gnzsnz

# -*- coding: utf-8 -*-
"""
Created on Sun Jan 31 11:03:57 2013
 
@author: Sukhbinder
https://sukhbinder.wordpress.com/2022/08/21/principal-component-analysis-with-numpy/
"""
 
 
import numpy as np

gnzsnz

import math
import asyncio
import logging, sys
import sqlite3
from asyncio import sleep
from logging.handlers import TimedRotatingFileHandler

import aiohttp_cors
import aiosqlite
import socketio

gnzsnz

Lecture 1: Introduction to Research — [📝Lecture Notebooks] [▶️Video]
Lecture 2: Introduction to Python — [📝Lecture Notebooks] [▶️Video]
Lecture 3: Introduction to NumPy — [📝Lecture Notebooks] [▶️Video]
Lecture 4: Introduction to pandas — [📝Lecture Notebooks] [▶️Video]
Lecture 5: Plotting Data — [📝Lecture Notebooks] [[▶️Vide

gnzsnz

SSH Certificates

Create CA

A certificate authority is a third party trusted by hosts and users to sign each other public certificates. So user would need it's pub key signed by the CA in order to access host. And host would need it's pub certificate signed by the CA for users to trust that it's the host they intend to connect.

Host CA

Generate a host certificate authority

gnzsnz

List of git aliases

Simple log

git config --global alias.slog "log --graph --all --topo-order --pretty='format:%h %ai %s%d (%an)'"

List git aliases

gnzsnz

List linux users

this will list non system users only

getent passwd | awk -F: '$3 >= 1000 && $3 <=60000 { print $1}'