⚙️ VBA RUNE DIFFICULTY: Apprentice Structural

The Proxy Pattern in VBA

Erect a phantom intermediary to defer the painful summoning of heavy objects until the very last moment.

✧ GANG OF FOUR LINEAGE & ARCANUM ✧
GOF DESIGN PATTERN: Proxy
ARCANUM SCHOOL: Abjuration // Spreadsheet Necromancy
SCRIBE / ARCHON: Joshua Edward McLaughlin Cox
CANONICAL REGISTRATION:
// VBA PATTERN //
' Interface: IDatabaseConnection (Class Module)
Public Sub ExecuteQuery(sql As String)
End Sub

' Class: HeavyDBConnection (Class Module)
Implements IDatabaseConnection
Private Sub Class_Initialize()
    ' Expensive initialization, opening ADODB connections over network
    Debug.Print "Establishing dark tether to the remote Abyss..."
End Sub

Private Sub IDatabaseConnection_ExecuteQuery(sql As String)
    Debug.Print "Executing: " & sql
End Sub

' Class: DBConnectionProxy (Class Module)
Implements IDatabaseConnection
Private pRealConn As HeavyDBConnection

Private Sub IDatabaseConnection_ExecuteQuery(sql As String)
    ' Lazy initialization
    If pRealConn Is Nothing Then
        Set pRealConn = New HeavyDBConnection
    End If
    pRealConn.ExecuteQuery sql
End Sub

' Client
Public Sub QueryData()
    Dim db As IDatabaseConnection
    Set db = New DBConnectionProxy
    
    ' The real connection is only summoned here
    db.ExecuteQuery "SELECT * FROM Souls"
End Sub

The Proxy: The Phantom Sentinel

Some incantations—like connecting to a distant, decaying SQL server or opening a monolithic external workbook—are incredibly costly. If the user never actually requests data during their session, paying this cost upfront is a waste of vital essence.

The Proxy pattern provides a lightweight stand-in. It implements the exact same interface as the heavy object but defers its creation until a method is actually invoked. This lazy initialization acts as a phantom sentinel, guarding the execution thread from unnecessary delays and preserving application responsiveness.

Runic Tags: #vba #proxy #structural #spreadsheet-necromancy