Database / BetterDB Interview questions
What are the storage backends supported by BetterDB Monitor?
BetterDB Monitor persists audit trail, analytics, captures, and anomaly data to one of four pluggable backends, chosen with the STORAGE_TYPE environment variable.
Which one to pick depends mostly on whether the deployment needs to survive a restart and whether it's serverless.
| Backend | Use case |
| memory | Testing / ephemeral environments; Docker default; lost on restart |
| postgres | Production; STORAGE_TYPE=postgres + STORAGE_URL |
| turso | Production / serverless SQLite over libsql; works in Docker |
| sqlite | Local development / CLI; native module stripped from the Docker image |
Only memory throws data away on restart; the other three are all meant to keep history around, they just differ in whether that history lives in a traditional Postgres instance, a serverless libsql database, or a local file.
More Related questions...