Three screens from the runtime: a native SQL console showing a key-indexed lookup returning in 2 milliseconds against a full scan of the same 1,344,450-record file at 3,665 milliseconds; a vendor lookup window drawn over a live purchase-order entry form; and a vendor maintenance screen showing the character-level field editor with dotted templates, insert mode and masked input.
┌──────────────────────────────────────────────────────────────────────────────┐
│ NATIVE SQL CONSOLE ubb-sql 1.0 CO 01 │
├──────────────────────────────────────────────────────────────────────────────┤
│ ubb-sql> SELECT CUSTNO, NAME, TERMS, BALANCE FROM ARCUST │
│ -> WHERE CUSTNO = '100482'; │
│ │
│ PLAN KEY SEEK ARCUST key 0 (CUSTNO) 3 index nodes 0 scanned │
│ CUSTNO NAME TERMS BALANCE │
│ 100482 ATLAS SUPPLY GROUP INC 2% 10 NET 30 58,749.72 │
│ 1 row 2 ms │
│ │
│ ubb-sql> SELECT CUSTNO, NAME FROM ARCUST WHERE PHONE = '717-555-0142'; │
│ PLAN FULL SCAN no key on PHONE 1,344,450 records read │
│ 1 row 3,665 ms │
│ ubb-sql> │
└──────────────────────────────────────────────────────────────────────────────┘
CLI ubb-sql HTTP POST /sql KEY-INDEX AWARE PLANNER 1 TABLE, NO JOINS
┌──────────────────────────────────────────────────────────────────────────────┐
│ PURCHASE ORDER ENTRY POE110 CO 01 │
├──────────────────────────────────────────────────────────────────────────────┤
│ P/O NUMBER P0044812 ORDER DATE 08/15/26 WHSE 001 HARRISBURG PA │
│ VENDOR V10044 FASTENAL SUPPLY CO │
│ SHIP VIA UPS GROUND ┌ VENDOR LOOKUP ──────────────────────────────────┐ │
│ BUYER R. DELUCA │ V10041 ACME GASKET CO INC MN NET 30 │ │
├─────────────────────────│ V10042 BRIDGEPORT TOOL WORKS CT 2% 10 │──┤
│ LN ITEM ORDERED │ V10043 DELTA ABRASIVES INC OH NET 45 │ │
│ 01 HX-4420-BLK 600 │ V10044 FASTENAL SUPPLY CO PA NET 30 │ │
│ 02 WSH-38-ZP 1,200 │ V10045 GRAINGER INDUSTRIAL IL NET 30 │ │
│ 03 │ F2=SELECT F4=PRIOR ESC=CANCEL 4 OF 1,208 │ │
│ └─────────────────────────────────────────────────┘ │
├──────────────────────────────────────────────────────────────────────────────┤
│ ENTER LINE # TO CHANGE, 0 TO ACCEPT: │
└──────────────────────────────────────────────────────────────────────────────┘
WINDOW 2 51x8 SAVED WITH ATTRIBUTES POP RESTORES CHARS AND COLOR STATE
┌──────────────────────────────────────────────────────────────────────────────┐
│ VENDOR MASTER MAINTENANCE APF910 CO 01 │
├──────────────────────────────────────────────────────────────────────────────┤
│ 1. VENDOR NO V10044.... │
│ 2. NAME FASTENAL SUPPLY CO............ │
│ 3. ADDRESS 2001 THEURER BLVD............. │
│ 4. CITY/ST/ZIP WINONA.............. MN 55987-.... │
│ 5. PHONE (507) 454-5374 │
│ 6. FED ID 41-0 ...... template 00-0000000 │
│ 7. TERMS CODE 30 NET 30 DAYS │
│ 8. A/P ACCOUNT 2000-000-00 │
│ 9. 1099 VENDOR N │
│ 10. PORTAL PIN ****** masked input, never echoed │
├──────────────────────────────────────────────────────────────────────────────┤
│ FIELD 06 INSERT ON BKSP DEL HOME END LEFT RIGHT ACTIVE │
└──────────────────────────────────────────────────────────────────────────────┘
CHARACTER-LEVEL FIELD EDITOR DOTTED TEMPLATES INSERT MODE MASKED INPUT