Practical best practices for using SQLite on edge devices — WAL mode, batch inserts, thread safety, schema design, and storage management, drawn from real embedded deployments.