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. The core persistence layer spans roughly 600 lines and uses WAL mode, prepared statements, and PRAGMA user_version for schema migrations. A significant bug was discovered post-launch where the iOS widget and the main app were silently writing to two separate database files, causing checkbox taps to disappear without any crash or error. 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 using 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.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in