Skip to content

How does SQLite with S3 work with ServerlessWP?

Mitch MacKenzie edited this page Apr 13, 2025 · 1 revision
flowchart TD
    A([Request Starts]):::requestNode --> B[Fetch SQLite File from S3]
    B --> C[Store SQLite File Hash]
    C --> D[Handle WordPress Request]
    D --> E{Has DB Changed?}
    E -->|No| F[Request Complete]
    E -->|Yes| G{Does SQLite Hash Still Match?}
    G -->|Yes| H[Upload Updated DB to S3]
    G -->|No| I["Fail WordPress Request<br><small>(another request updated DB during this request)</small>"]:::errorNode
    H --> F
    I --> F
    F --> J([Next Request Starts]):::requestNode
    J --> K{Has SQLite Hash Changed?}
    K -->|Yes| L[Fetch New SQLite File from S3]
    K -->|No| M[Use Cached SQLite File]
    
    classDef requestNode fill:#9370DB,stroke:#7B68EE,color:white,stroke-width:2px
    classDef errorNode fill:#FF6347,stroke:#FF0000,color:white,stroke-width:2px
Loading
Clone this wiki locally