2. Store a new learning

███████╗███████╗██╗  ██╗       ██╗     ███████╗ █████╗ ██████╗ ███╗   ██╗
╚══███╔╝██╔════╝██║  ██║       ██║     ██╔════╝██╔══██╗██╔══██╗████╗  ██║
  ███╔╝ ███████╗███████║ █████╗██║     █████╗  ███████║██████╔╝██╔██╗ ██║
 ███╔╝  ╚════██║██╔══██║ ╚════╝██║     ██╔══╝  ██╔══██║██╔══██╗██║╚██╗██║
███████╗███████║██║  ██║       ███████╗███████╗██║  ██║██║  ██║██║ ╚████║
╚══════╝╚══════╝╚═╝  ╚═╝       ╚══════╝╚══════╝╚═╝  ╚═╝╚═╝  ╚═╝╚═╝  ╚═══╝

[MYSQL-BACKED LEARNING COLLECTION FOR ZSH // SAVE, QUERY, QUIZ]

"Every command you forgot, recoverable."

strykelang · zshrs · MenkeTechnologiesMeta · zsh-more-completions · zsh-git-acp · zsh-expand · zpwr

Read the Docs · Engineering Report

---

Table of Contents

• [0x00] > SYSTEM.INIT
• [0x01] > INSTALL.EXEC
• [0x02] > CONFIG.ENV
• [0x03] > COMMAND.MATRIX
• [0x04] > KEYBIND.MAP
• [0x05] > WORKFLOW.EXAMPLE
• [0x06] > PROJECT.STRUCT

---

[0x00] > SYSTEM.INIT

This plugin turns your terminal into a persistent knowledge base. Store what you learn, search it instantly, and drill yourself with randomized quizzes — all without leaving the command line.

• Save code snippets, one-liners, notes, anything
• Search with filters, fzf fuzzy matching, or random sampling
• Quiz yourself for spaced recall and permanent retention
• Edit entries in-place with your $EDITOR
• Manage with delete, redo, and full SQL access

---

[0x01] > INSTALL.EXEC

Zinit

Add to ~/.zshrc:

source "$HOME/.zinit/bin/zinit.zsh"
zinit ice lucid nocompile
zinit load MenkeTechnologies/zsh-learn

---

[0x02] > CONFIG.ENV

Variable	Default	Description
ZPWR_LEARN_COMMAND	mysql	Database command to execute queries
ZPWR_SCHEMA_NAME	root	Schema name for the learning table
ZPWR_TABLE_NAME	LearningCollection	Table name for stored entries

# Example: MariaDB with unix auth
export ZPWR_LEARN_COMMAND='sudo mysql'

# Custom schema.table (set before CreateLearningCollection)
export ZPWR_SCHEMA_NAME="root"
export ZPWR_TABLE_NAME="LearningCollection"

Migration: the default table name was LearningCollectiion (typo) before the rename. Existing installs: RENAME TABLE root.LearningCollectiion TO root.LearningCollection; or keep the old table with export ZPWR_TABLE_NAME=LearningCollectiion.

---

[0x03] > COMMAND.MATRIX

Write Operations

Command	Args	Description
le	LEARNING	Insert a new learning entry
editl	ID	Open entry by ID in $EDITOR for editing
del	[N]	Delete last N entries (default: 1)
delid	ID	Delete a specific entry by ID

Search Operations

Command	Args	Description
se	[FILTER...]	Search learning column with optional filters
see	[FILTER]	Search with learning + category columns
seee	—	Search with learning + category + date columns
sef	—	Search all entries via fzf (most recent first)

Randomized Recall

Command	Args	Description
ser	[N]	N random entries (default: 100)
sera	—	All entries in random order
qu	[N]	N random entries piped to fzf (default: 100)
qua	—	All entries randomized in fzf

SQL & Redo

Command	Args	Description
re	[ID|FILTER]	Print matching entries with SQL update statements
rsql	[ID|FILTER]	Same as re but opens in vim

Admin

Command	Description
zsh-learn-CreateLearningCollection	Generate DDL and create the learning table
zsh-learn-DropLearningCollection	Drop the learning table

---

[0x04] > KEYBIND.MAP

┌─────────────────────────────────────────────┐
│  MODE          BINDING     ACTION            │
│  ─────────────────────────────────────────── │
│  vim insert    Ctrl+K      zsh-learn-Learn   │
│  vim normal    Ctrl+K      zsh-learn-Learn   │
│  emacs         Ctrl+K      zsh-learn-Learn   │
└─────────────────────────────────────────────┘

bindkey -M viins '^k' zsh-learn-Learn
bindkey -M vicmd '^k' zsh-learn-Learn
bindkey -M emacs '^k' zsh-learn-Learn

---

[0x05] > WORKFLOW.EXAMPLE

# 1. Initialize the database
zsh-learn-CreateLearningCollection

# 2. Store a new learning
le "git rebase -i HEAD~3  # interactive rebase last 3 commits"

# 3. Search your knowledge
se rebase

# 4. Quiz yourself with 50 random entries
qu 50

# 5. Fuzzy search everything
sef

---

[0x06] > PROJECT.STRUCT

zsh-learn/
├── zsh-learn.plugin.zsh     # Main plugin entry point
├── autoload/                 # Lazy-loaded functions
│   ├── zsh-learn-Learn       # Core insert function
│   ├── zsh-learn-Searchl     # Search engine
│   ├── zsh-learn-Get         # Query interface
│   ├── del                   # Delete operations
│   ├── zsh-learn-DeleteId    # Delete by ID (delid alias)
│   ├── qu / qua              # Quiz functions
│   ├── sef                   # fzf search (se/see/seee are plugin aliases)
│   ├── ser / sera            # Random recall
│   └── ...                   # Additional utilities
├── src/                      # Completions
│   └── _se                   # Tab completion for se
└── tests/                    # Test suite
    ├── t-syntax.zsh          # Syntax validation
    ├── t-unit.zsh            # Unit tests
    └── ...                   # Contract + repo hygiene checks

---