GRDB.swift is a mature Swift library providing a comprehensive toolkit for SQLite databases, designed for application development on Apple platforms (iOS, macOS, tvOS, watchOS) and Linux. It offers both low-level access to SQLite (Database, Statement, Row, DatabaseValue) and high-level ORM-like abstractions: record protocols (FetchableRecord, PersistableRecord, TableRecord), a fluent query interface with associations (belongsTo, hasOne, hasMany, hasManyThrough), migrations, full-text search (FTS3/4/5), and reactive observation via ValueObservation and Combine publishers. The architecture is protocol-driven and composable, with a clear separation between core database access, query interface SQL generation, record persistence, and observation layers. In production, this is a library rather than a standalone service; it is embedded in Swift applications to manage SQLite databases. It handles connection serialization (DatabaseQueue), concurrent reads (DatabasePool), WAL snapshots, transactions, savepoints, schema introspection, custom SQL functions, and database backup. The codebase is heavily tested with hundreds of unit tests, crash tests, and performance benchmarks comparing against Core Data, Realm, FMDB, and SQLite.swift. The library is actively maintained (v7.11.1, Swift 6.1+, Xcode 16.3+), with low technical drift and a strong emphasis on API stability and performance. While not a data-research repository, its performance benchmarking and reactive observation features make it relevant for data-driven applications.
Swift Paperless is a native iOS client for Paperless-ngx, a self-hosted document management system. The app provides a rich SwiftUI interface for browsing, filtering, viewing, editing, and sharing documents stored on a remote Paperless-ngx server. It supports offline-first caching via GRDB (SQLite), multi-server connections, OIDC login with PKCE and TOTP, mTLS client certificates, deep links, and a share extension for importing documents from other apps. The architecture is modular, with separate Swift packages for networking (ApiRepository, wire types), data models (FilterState, SyncPlan), persistence (GRDB migrations, records, observation), and shared UI components. The app uses a repository pattern with a caching decorator (CachingRepository) that provides offline reads, delta sync with watermarks, and write-through cache consistency. A sync engine orchestrates per-server synchronization phases (elements, reconcile, fill) with progress reporting and throttle support. Key features include a customizable filter bar with saved views, custom field filtering with logical operators, a PDF viewer with text search, document scanning via VisionKit, barcode ASN extraction, and a tip jar for donations. The codebase is well-tested with unit tests for networking, persistence, data models, and concurrency patterns. CI/CD pipelines build and deploy to TestFlight, and localization is managed via Crowdin across 8 languages.
Clipy is a macOS clipboard extension app that lives in the menu bar. It provides clipboard history management, text snippet storage and quick paste, OCR for image-based clipboard content, and customizable global hotkeys to trigger history menu, snippet editor, or paste actions. The app monitors NSPasteboard using a timer, deduplicates entries, and stores them in a local SQLite database (via GRDB wrapper SQLiteData), with a legacy Realm database still present for migration. UI is built with a mix of SwiftUI (settings panes) and AppKit (snippet editor, menu). Dependency injection via swift-dependencies and reactive storage via swift-sharing are used throughout. The architecture is well-modularized with repository and service layers, extensive unit tests, and a migration system for both database schema and user defaults. However, the project shows signs of drift: legacy Realm code and XIB files persist, localization strings may be out of sync, and the last commit date is anomalous (future date) suggesting the project may be unmaintained despite a large user base.