ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #sqlite
Stop fighting 'database is locked' errors in SQLite. Learn how Write-Ahead Logging (WAL) enables concurrent reads and writes to boost application performance.
How Write-Ahead Logging separates reads and writes in SQLite, when it helps, and what to watch out for.
SQLite WAL mode enables concurrent readers and writers without blocking, boosting write throughput while preserving ACID. Covers enabling WAL, checkpoint tuning, pitfalls, and production verification.
SQLite WAL mode lets readers coexist with a single writer by appending changes to a -wal file and coordinating via -shm. See how to enable it safely and what trade-offs to expect with checkpoints and multi-file layout.
Guide to choosing between SQLite, etcd, and external SQL for K3s. Compare quorum requirements, failure domains, and implementation steps for high-availability state management.
Learn how K3s uses SQLite to eliminate etcd overhead for edge computing, when to stick with the default storage, and how to verify your backend configuration.
SQLite’s Write‑Ahead Logging (WAL) lets readers run while writers commit, reducing lock contention. Learn how to enable WAL, verify it works, and manage checkpoints to keep the WAL file from growing uncontrollably.
Learn how Bun’s built‑in SQLite module removes native‑dependency friction, see a minimal worked example, and weigh the trade‑offs of runtime coupling and synchronous execution.
An architecture note outlining the minimal design for offline SQLite persistence using Titanium's Ti.Database, including DAO abstraction, transaction handling, encryption, trust boundaries, operational checks, failure modes, and evolution triggers.
k3s
kubernetes
bun
javascript
titaniumsdk