Developer ships Mac/iOS task app using raw SQLite C API, skipping Core Data and ORMs

A developer released KinetTask, a local-first task management app for Mac and iOS, built entirely on the SQLite3 C API in Swift 6.1 without using Core Data, SwiftData, or any ORM layer. The entire persistence layer spans roughly 600 lines of code, using WAL mode, prepared statements, and PRAGMA user_version for schema migrations. A significant bug was discovered post-launch where widget checkbox taps were silently lost because the main app and the widget were writing to two separate SQLite files in different sandboxed containers. The fix involved unifying both processes to a single App Group database file, enabling busy_timeout, and adding a snapshot-reconciliation pass to prevent stale in-memory cache from overwriting widget changes. The app also includes on-device AI features powered by Apple's foundation model or a GGUF model via llama.cpp, with an anti-filler gate added to prevent the model from generating unnecessary task structure.