ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #sqlite
K3s uses SQLite by default to reduce the memory overhead of etcd. Learn when to stick with SQLite for edge devices and when to migrate to an external database for high availability.
Zend\Db\TableGateway is a single-table wrapper, not an ORM. Here is a worked SQLite configuration, the point where you should switch to Zend\Db\Sql, and the mistakes that leak data.
Learn how SQLite’s Write‑Ahead Logging (WAL) mode eliminates "database is locked" errors in multi‑threaded apps. Enable WAL, monitor checkpoints, and balance disk usage for optimal concurrent read/write performance.
Guide to adopting SQLite STRICT mode: decision, constraints, option table, trade‑offs, and a strict‑table example with verification steps.
If your mobile app hits “database is locked” errors, Write‑Ahead Logging (WAL) may be the fix. This post explains what WAL is, how to enable it, the performance trade‑offs, and how to verify the change.
Learn why SQLite’s WAL mode can boost read/write performance, how to enable it, and what pitfalls to avoid. A hands‑on example shows the setup, and a checklist helps you decide if WAL is right for your app.
Architecture note on K3s’ embedded SQLite datastore: requirements, minimal design, trust boundaries, operational checks, failure modes, and when to switch to an external store.
Learn when to use K3s' embedded SQLite datastore versus external options like MySQL or etcd, including performance limits and verification steps for small clusters.
Stop fighting with native C++ bindings. Learn how Bun's built‑in sqlite module eliminates installation overhead and improves local persistence performance through synchronous execution.
k3s
kubernetes
zend
bun