Database Management System

MySQL | PostgreSQL

Prerequisite

1. A Very Nice Terminal 🤞

Nearest example for windows user: Windows Terminal

    if (-not (Get-Command wt.exe -ErrorAction SilentlyContinue)) {
        winget install -e --id Microsoft.WindowsTerminal --source winget --silent
    }
    

2. PowerShell Core 🐱‍👤

PowerShell Core: pwsh

    if (-not (Get-Command pwsh.exe -ErrorAction SilentlyContinue)) {
        winget install --id Microsoft.Powershell --source winget --silent
    }
    Start-Process powershell -Verb runAs -ArgumentList "Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser" -PassThru -Wait
    

3. One Nerd Font ✨

    if (-not (Get-Command git -ErrorAction SilentlyContinue)) {
        winget install -e --id Git.Git  --source winget --silent
    }
    git clone --filter=blob:none --sparse https://github.com/ryanoasis/nerd-fonts.git $env:TEMP\NerdFront
    cd $env:TEMP\NerdFront
    ./install.ps1 Hack
    

4. A SQL Database 🤗

Choice 1. MySQL

        if (-not (Get-Command mysql -ErrorAction SilentlyContinue)) {
            winget install -e --id Oracle.MySQL --silent
        }
        

Choice 2. PostgreSQL

        if (-not (Get-Command psql -ErrorAction SilentlyContinue)) {
            winget install -e --id PostgreSQL.PostgreSQL --silent
        }
        

Usage

Clone the github repo in your local machine

git clone https://github.com/jay-neo/DBMS.git
cd DBMS

then run

./run.ps1

or pwsh run.ps1 or & (Join-Path (Get-Location) "run.ps1")

psql.mp4

To run code with different user account with saving info

./run.ps1 -config

To run code with different user account without saving info

./run.ps1 -private

Direct interact with SQL Shell after executing code

./run.ps1 -it

To save the output log file

./run.ps1 -log