psiborg

Database Naming Conventions Cheat Sheet

Updated: 2025.07.17

Following a consistent style is crucial for database readability, maintainability, and portability.

General Principles

These conventions apply to all database objects, including tables, columns, views, and functions.

psiborg

#!/usr/bin/env bash

# Usage: ./describe_diagrams.sh /path/to/folder

# Exit on error, treat unset variables as an error
set -euo pipefail

# Ensure folder argument is provided
if [ -z "$1" ]; then
  echo "Usage: $0 /path/to/folder"

psiborg

Color Schemes

Ubuntu

Color	RGB	Item	RGB
Black	${\textsf{\textcolor[RGB]{118, 118, 118}{■}}}$ #767676	Foreground	${\textsf{\textcolor[RGB]{255, 255, 255}{■}}}$ #FFFFFF
Red	${\textsf{\textcolor[RGB]{192, 28, 40}{■}}}$ #C01C28	Background	${\textsf{\textcolor[RGB]{48, 10, 36}{■}}}$ #300A24
Green	${\textsf{\textcolor[RGB]{38, 162, 105}{■}}}$ #26A269	Cursor color	${\textsf{\textcolor[RGB]{255, 255, 255}{■}}}$ #FFFFFF
Yellow	${\textsf{\textcolor[RGB]{162, 115, 76}{■}}}$ #A2734C	Selection background	${\textsf{\textcolor[RGB]{255, 255, 255}{■}}}$ #FFFFFF

psiborg

By default, Windows 11 shows a simplified right-click context menu, and you have to click "Show more options" (or press Shift + F10) to access the full legacy menu. You can make Windows 11 always show the full context menu by following these steps:

1. Run the following command in Command Prompt (Admin):

reg add "HKEY_CURRENT_USER\Software\Classes\CLSID\{86CA1AA0-34AA-4E8B-A509-50C905BAE2A2}\InprocServer32" /f /ve

2. Restart Windows Explorer by running:

psiborg

#!/bin/bash

# Log and data files
LOG_FILE="distro_checker.log"
DATA_FILE="distro_versions.txt"

# Source the external distro configuration file
source "./distro_checker_config.sh"

# Function to fetch and extract version information

psiborg

Huffman Coding (Variable-Length Encoding)

Huffman coding is a lossless data compression algorithm that assigns shorter binary codes to more frequent characters and longer codes to less frequent characters. This minimizes the overall size of encoded data while ensuring perfect decompression.

How Huffman Coding Works

1. Analyze Character Frequencies
   • Count how often each character appears in the text.
2. Build a Huffman Tree

• Create a binary tree where characters with lower frequency are placed deeper.

psiborg

# Define the target directory
$targetDirectory = "C:\Path\To\Your\Directory"

# Initialize counters for each file type
$counterPDF = 0
$counterTXT = 0

# Process both "booklist.pdf" and "booklist.txt"
foreach ($fileType in @("booklist.pdf", "booklist.txt")) {
    Get-ChildItem -Path $targetDirectory -Recurse -Filter $fileType | ForEach-Object {

psiborg

@echo off
C:\Users\jing\anaconda3\python.exe "C:\Users\jing\AppData\Local\Microsoft\WindowsApps\rename_photos.py" %*
pause

psiborg

@echo off
:: Script to rename files: lowercase and replace spaces with underscores
setlocal enabledelayedexpansion

:: Check if any files were passed
if "%~1"=="" (
    echo Usage: Drag and drop files onto this script to rename them.
    echo The script will rename files to lowercase and replace spaces with underscores.
    pause
    exit /b

psiborg

flowchart TD
    A[Locate Both Cars] --> B[Position Cars Close]
    B --> C[Turn Off Both Cars]
    C --> D[Connect Red Jumper Cable to Dead Battery's Positive Terminal]
    D --> E[Connect Red Jumper Cable to Good Battery's Positive Terminal]
    E --> F[Connect Black Jumper Cable to Good Battery's Negative Terminal]
    F --> G[Connect Black Jumper Cable to Metal Surface on Dead Car]
 G --> H[Start Good Car]