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

·4 views

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.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Daminion Finds Image Optimization Is a Workflow Issue, Not Just a Format Choice

While rebuilding the Daminion website, the team initially assumed switching to WebP would fix inconsistent image sizes across pages. Testing revealed that compression results varied wildly depending on source type, dimensions, and visual complexity, with reductions ranging from 27% to 95% using the same quality settings. The team concluded that no single format or compression rule works universally, and that the real fix was standardizing the publishing process itself. They adopted a repeatable pipeline — master, crop, resize, optimize, review, and publish — treating AI-generated images the same as designer master files rather than publishing them directly. Format selection, whether WebP, SVG, PNG, AVIF, or JPEG, now depends on the specific asset, workflow, and destination rather than a one-size-fits-all rule.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why Judgment-Based Software Advice Matters More Than Coding Rules

Software advice broadly falls into two categories: practical rules like 'write small functions' and judgment-based principles that require interpretation based on context. Practical advice is easy to teach, verify, and enforce through linters and code reviews, making it widely adopted early in developers' careers. Judgment-based advice, such as 'the wrong abstraction is more costly than duplication,' offers no clear checklist and demands experience to apply correctly. The danger of relying solely on practical rules is conflating adherence to good practices with actually becoming a skilled engineer. Deeper software wisdom only becomes truly useful after a developer has lived through both the successes and failures that give abstract principles real meaning.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Notifio adds desktop alerts that batch listings to avoid notification overload

Notifio, a rental search monitoring app, has implemented desktop notifications after the feature was listed but never built. The system fires alerts locally before emails are even sent, eliminating network delays that can cost users a rental opportunity. To prevent notification fatigue, each search cycle triggers at most one banner, grouping multiple new listings with the first three previewed in the body. Clicking the notification opens the listing directly in the user's default browser, preserving their existing login session rather than routing them through the app's internal browser. These design choices — deduplication, batching, and smart handoff — were prioritised to ensure users keep the alerts enabled rather than switching them off.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why DNS for Multi-Tenant Fintechs Needs State Reconciliation, Not API Commands

A technical analysis argues that DNS management for fintech platforms serving multiple tenants should be modeled as a continuous reconciliation loop rather than a series of one-off API write commands. The core principle is that a system must compare its intended DNS record set against a fresh, authoritative observation of current state before declaring convergence, since a successful write does not guarantee the desired state is actually live. Platforms must maintain a strict ownership boundary, reconciling only the records they explicitly manage and leaving customer-controlled records untouched to avoid accidental deletions. Race conditions — such as a stale reconciliation job overwriting a newer DNS update during a tenant migration — are neutralized when workers reload the latest desired state and recompute a fresh plan instead of blindly executing queued commands. The distinction between platform-owned and customer-owned zones also demands different automation risk tolerances, with customer zones requiring verification steps and more cautious, report-before-repair workflows.

0 comments Read more at DEV Community