-
Notifications
You must be signed in to change notification settings - Fork 163
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