groue/GRDB.swift

GRDB is a Swift library for SQLite that provides a comprehensive toolkit for local data persistence, including full-text search, JSON handling, and real-time value observation. It offers a modern, type-safe query interface and supports complex database relationships, migrations, and encryption via SQLCipher. The system also includes extensive tooling for performance benchmarking, crash testing, and integration verification across various build environments.

23 changes.

This period focused on modernizing the GRDB codebase to support Swift 6.1 and recent iOS/macOS versions, while introducing a new QueryInterface API and native Codable support for records. The team also expanded feature coverage with Full-Text Search, CGFloat support, and various concurrency utilities, accompanied by comprehensive test coverage and project structure reorganization.

28 changes.

This period focused on a comprehensive internal refactoring of the SQL query interface, introducing support for Common Table Expressions and aggregate functions on associations. Concurrently, the project significantly expanded its test coverage by establishing dedicated test suites for SQLCipher 3 and 4, as well as creating new performance benchmarks and platform-specific integration tests.

15 changes.

This period focused on improving thread safety and concurrency support through the refactoring of ValueObservation observers and the introduction of Swift concurrency-compatible reducers. The release also expanded the API with new JSON column types, SQL functions, and database dump utilities, while establishing robust testing and tooling infrastructure for Swift 6 and modern Xcode versions.

GRDB now supports converting CoreGraphics CGFloat values to and from database values on non-Darwin platforms (such as Linux). Previously, this conversion was likely restricted to Darwin/macOS environments. The change introduces a conditional import of the Foundation framework on non-Darwin platforms to ensure CGFloat is available, and implements the DatabaseValueConvertible protocol for CGFloat, allowing seamless storage and retrieval of floating-point values in SQLite databases across all supported operating systems.

GRDB/Core/Support/CoreGraphics · high confidence

Added C/C++ header files and module maps for both the GRDBSQLite and GRDBSQLCipher targets. The GRDBSQLite shim exposes missing SQLite3 APIs (such as pre-update hooks) and provides inline wrappers for variadic C functions that are not directly callable from Swift. The GRDBSQLCipher target includes a corresponding header and module map to support SQLCipher integration.

Sources · high confidence

Added a new SwiftLint configuration file (Scripts/swiftlint.yml) that disables several rules (e.g., for\_where, redundant\_self\_in\_closure) and enables various opt-in rules for the GRDB directory. Additionally, a new Ruby script (Scripts/destination.rb) was introduced to parse and display simulator device information, and a shell script (Scripts/swiftlint.sh) was added to support SwiftLint installation via Homebrew on Apple Silicon.

Scripts · medium confidence

A new MyPlayground example has been added to the Documentation/Playgrounds directory. It demonstrates how to configure a database queue, define a Codable record type, and perform basic create, read, and count operations using the GRDB library.

Documentation/Playgrounds/MyPlayground.playground · high confidence

A new Xcode workspace file (contents.xcworkspacedata) was added to the .swiftpm/xcode/package.xcworkspace directory. This change establishes the workspace configuration for the Swift Package Manager, enabling the project to be opened and built within Xcode.

.swiftpm · high confidence

The GRDBCustom Xcode project configuration now includes a privacy manifest, ensuring compliance with Apple's privacy requirements for app store submissions.

GRDBCustom.xcodeproj · high confidence

Added the GRDBCustom.xcodeproj workspace files (contents.xcworkspacedata, IDEWorkspaceChecks.plist, and WorkspaceSettings.xcsettings) to establish the Xcode workspace structure for the GRDBCustom project.

GRDBCustom.xcodeproj/project.xcworkspace · high confidence

The library introduces a new \CommonTableExpression\ struct to support Common Table Expressions (CTEs) in the query interface, allowing users to define named subqueries for use in \WITH\ clauses. Additionally, the internal request architecture is refactored by introducing \QueryInterfaceRequest\ and \RequestProtocols\ to better organize query building and selection logic, while also closing the \FetchRequest\ protocol to prevent external conformance.

GRDB/QueryInterface/Request · high confidence

The GRDB library adds new files under GRDB/ValueObservation/Reducers to support Swift concurrency. This includes the core ValueReducer protocol and specific reducer types: Fetch, Map, RemoveDuplicates, and Trace. These components enable ValueObservation to operate safely across concurrency boundaries, allowing database fetches and value transformations to be performed in a thread-safe manner.

GRDB/ValueObservation/Reducers · high confidence

The library now provides default implementations of Swift's \Codable\ protocol for types that conform to \DatabaseValueConvertible\. This allows developers to seamlessly encode and decode complex types, such as nested dictionaries or arrays, by automatically converting them to and from JSON strings stored in the database. The implementation handles the conversion of simple scalar types directly and delegates complex structures to a JSON encoder/decoder, ensuring that \Decodable\ types can be read from the database without manual mapping.

GRDB/Core/Support/StandardLibrary · high confidence

A new demo application has been added at Documentation/DemoApps/GRDBDemo/GRDBDemo, showcasing the use of the GRDB library for iOS. The app implements a complete player management workflow, including database persistence with automatic migrations, an observable list model that tracks changes in real-time, and SwiftUI views for creating, editing, and deleting player records. The demo also includes supporting assets, localization strings, and a shared database instance for the application.

Documentation/DemoApps/GRDBDemo/GRDBDemo · high confidence

A new interactive playground named 'Associations' has been added to the Documentation folder. It demonstrates how to define and query one-to-many and many-to-one relationships between Author and Book records using GRDB's association features, including fetching related data and building composite records.

Documentation/Playgrounds/Associations.playground · high confidence

Adds a new \JSONColumn\ type and \SQLJSONExpressible\ protocol to provide convenient Swift APIs for accessing JSON subcomponents at the SQL level. It also introduces a suite of SQLite JSON1 functions (e.g., \json\, \jsonArray\, \jsonExtract\, \jsonInsert\, \jsonReplace\, \jsonSet\) as static methods on \Database\, enabling direct manipulation and querying of JSON data within SQL queries.

GRDB/JSON · high confidence

The QueryInterface module introduces a modernized API for building database queries. TableRecord now provides fluent methods like .all(), .select(), and .matching() to construct requests. Full-text search is supported via .matching() for FTS3 and FTS5 patterns. SQL interpolation is enhanced to support table names, column selections, and literal SQL strings. Associations (belongsTo, hasMany, hasOne) are decoupled from the database table, allowing explicit ForeignKey definitions for complex relationships. The new API replaces older patterns, offering a more consistent and type-safe way to interact with SQLite.

GRDB/QueryInterface · high confidence

The GRDB library introduces new internal components for SQL generation, including SQLColumnGenerator, SQLGenerationContext, SQLIndexGenerator, SQLQueryGenerator, SQLTableAlterationGenerator, SQLTableGenerator, and TableAlias. These classes handle the creation of SQL statements for table definitions, index creation, and query building, supporting features like common table expressions (CTEs) and table aliases. The changes also include a fix for a failing test related to rowid optimization in Database.recordingSelectedRegion.

GRDB/QueryInterface/SQLGeneration · high confidence

Added new methods to \Database\ and \DatabaseReader\ for exporting database content and schema. Users can now use \dumpSQL\, \dumpRequest\, \dumpTables\, \dumpContent\, and \dumpSchema\ to print query results, table data, and schema definitions to a text stream. The \dumpContent\ method explicitly excludes internal SQLite/GRDB schema objects and SQLite shadow tables (starting with SQLite 3.37+). A new \DumpFormat\ protocol and several built-in formats (debug, JSON, line, list, quote) allow users to control the output style.

GRDB/Dump · high confidence

Added new dump formats to the GRDB library, including DebugDumpFormat for simple line-based debugging output, JSONDumpFormat for exporting data as JSON arrays, LineDumpFormat for key-value style listings, ListDumpFormat for pipe-separated values, and QuoteDumpFormat for SQL literal exports. These formats allow users to easily export database contents in various human-readable and machine-parseable formats, with each format supporting custom separators, headers, and NULL value representations.

GRDB/Dump/DumpFormats · high confidence

Added new SVG illustrations for the Associations documentation, including schema diagrams for BelongsTo, HasMany, HasOne, and HasManyThrough relationships, as well as a diagram for ambiguous foreign keys.

Documentation/Images · high confidence

A new Swift playground, TransactionObserver, has been added to the Documentation/Playgrounds directory. It demonstrates how to use the TransactionObserver protocol to monitor database changes, including handling table modifications, commit, and rollback events within the GRDB framework.

Documentation/Playgrounds/TransactionObserver.playground · high confidence

GRDB introduces \SharedValueObservation\ to allow multiple subscribers to share a single underlying database observation, reducing resource usage. The \ValueObservation\ API now supports cancellation via the new \DatabaseCancellable\ protocol and \AnyDatabaseCancellable\ type, allowing users to explicitly stop observations. Additionally, the \SharedValueObservationExtent\ enum lets users control whether the shared observation persists for the lifetime of the object or while it has active subscriptions.

GRDB/ValueObservation · high confidence

GRDB introduces several new utility types to support Swift concurrency and improve internal architecture. A new \CaseInsensitiveIdentifier\ struct provides case-insensitive string comparison. The \Inflections\ struct and its English extension are added to handle string pluralization and singularization. A new \Refinable\ protocol allows types to be easily modified via a \with\ closure. Additionally, new concurrency-safe utility classes are introduced: \Mutex\ and \ReadWriteLock\ for thread-safe state management, \OnDemandFuture\ for lazy Combine publisher creation, \OrderedDictionary\ for maintaining key order, and \Pool\ for managing reusable objects. These changes enhance the library's support for modern Swift features and internal thread safety.

GRDB/Utils · high confidence

Records can now be encoded to and decoded from database rows using Swift's standard Encodable and Decodable protocols. This introduces EncodableRecord and FetchableRecord protocols that provide default implementations for encoding and decoding, allowing developers to leverage standard library features like JSON encoding strategies and user info for database column mapping. The change adds new files for EncodableRecord, FetchableRecord, and their extensions, enabling seamless integration of Swift's coding infrastructure with GRDB's persistence layer.

GRDB/Record · high confidence

GRDB now supports creating and querying SQLite Full-Text Search virtual tables. You can create FTS3, FTS4, and FTS5 tables using the new \FTS3\, \FTS4\, and \FTS5\ module types. The library provides type-safe pattern builders (\FTS3Pattern\, \FTS5Pattern\) and tokenizers (\FTS3TokenizerDescriptor\, \FTS5TokenizerDescriptor\) to construct search queries and handle text tokenization. This includes support for custom FTS5 tokenizers, external content table synchronization for FTS4/FTS5, and various tokenizer options like \remove\_diacritics\ and \tokenchars\.

GRDB/FTS · high confidence

GRDB now supports storing and loading several Foundation types directly, including Date, Decimal, Data, URL, UUID, and NSUUID. These types adopt DatabaseValueConvertible and StatementColumnConvertible, allowing them to be stored as text, blobs, or numbers as appropriate. For example, Date is stored as a formatted string or Unix timestamp, while Data is stored as a blob. This enables seamless integration of common Swift and Foundation types with the database.

GRDB/Core/Support/Foundation · high confidence

A new IDEWorkspaceChecks.plist file was added to the GRDB workspace configuration. This file sets the IDEDidComputeMac32BitWarning flag to true, which is a standard configuration for Xcode 9.3+ workspaces to handle 32-bit architecture warnings.

GRDB.xcworkspace/xcshareddata · high confidence

The internal SQL query interface has been completely restructured, introducing new types such as SQLExpression, SQLRelation, and SQLSelection to represent SQL components. This refactoring improves the handling of associations, subqueries, and ordering, and introduces support for features like Common Table Expressions (CTEs) and the ESCAPE clause in LIKE operators. The change also includes the addition of new SQL functions (e.g., COALESCE, CAST, EXISTS) and operators, alongside the removal of deprecated methods and the adoption of Sendable for improved concurrency safety.

GRDB/QueryInterface/SQL · high confidence

DatabasePool.write now wraps changes in a transaction, ensuring that eventual concurrent readers do not see any changes until all changes are executed. This behavioral change prevents concurrent readers from observing intermediate states during write operations.

GRDB/Core · high confidence

This update introduces several breaking changes to the GRDB API, including the removal of deprecated methods, the removal of \DatabaseFuture\, and the removal of \concurrentRead\ from \DatabasePool\. The library now requires macOS 10.15+, iOS 13+, tvOS 13+, and watchOS 7+. Additionally, the project structure has been modernized by removing legacy configuration files (\GRDB.xcconfig\, \GRDB-Bridging.h\, \fts3\_tokenizer.h\) and adding a \PrivacyInfo.xcprivacy\ manifest for iOS app store compliance. A \Fixits.swift\ file is provided to help migrate from the removed APIs.

GRDB · high confidence

The GRDBDemo project has been upgraded to support Xcode 26, as indicated by the LastUpgradeCheck and LastSwiftUpdateCheck attributes in the project file. This update ensures compatibility with the latest Xcode toolchain and aligns the demo application with the new Swift 6.1 minimum version requirement.

Documentation/DemoApps/GRDBDemo/GRDBDemo.xcodeproj · medium confidence

The internal observers for ValueObservation (ValueConcurrentObserver and ValueWriteOnlyObserver) have been refactored to improve thread safety and concurrency handling. The code now explicitly manages database access and notification callbacks with distinct locking mechanisms, ensuring that cancellation and error states are handled correctly across threads. Additionally, the ValueObservationScheduler has been converted into a protocol, and the observers now utilize dispatch queues for reducing values before notification, preventing potential deadlocks and improving performance in concurrent database environments.

GRDB/ValueObservation/Observers · medium confidence

The association types (BelongsTo, HasOne, HasMany, and their 'through' and 'Join' variants) have been refactored to be decoupled from their origin database table, now conforming to the DerivableRequest protocol. This change enables the addition of aggregate functions (count, isEmpty, average) on associations, allowing users to perform SQL aggregations like Team.players.count or Team.players.average(Column('score')) directly in their queries.

GRDB/QueryInterface/Request/Association · high confidence

The schema definition API has been restructured into dedicated types: \ColumnDefinition\, \ForeignKeyDefinition\, \IndexDefinition\, \TableDefinition\, and \TableAlteration\. This change introduces a more fluent and type-safe way to define tables, columns, and constraints. Notably, \TableDefinition.primaryKey\ now enforces a NOT NULL constraint by default for non-integer primary keys, and the API supports defining compound primary keys and foreign keys with greater clarity. The \TableAlteration\ class now explicitly handles column additions, renames, and drops, with \drop(column:)\ availability-gated to SQLite 3.35.0+. Virtual table creation is also supported via the \VirtualTableModule\ protocol.

GRDB/QueryInterface/Schema · high confidence

The migration system now offers precise control over foreign key constraint enforcement during schema changes. The \DatabaseMigrator\ exposes a \ForeignKeyChecks\ enum with \deferred\, \immediate\, and \disabled\ states, allowing developers to choose when foreign keys are validated. The \disablingDeferredForeignKeyChecks()\ method returns a migrator that disables deferred checks for all newly registered migrations, while individual migrations can be configured with specific foreign key behaviors. This change ensures that migrations can be executed with immediate or disabled foreign key checks, or deferred checks that validate constraints before committing, providing greater flexibility and performance control for database schema evolution.

GRDB/Migration · medium confidence

The GRDBCustomSQLite build system has been reorganized to improve customization and clarity. A new 'SQLiteCustom' directory now houses the custom SQLite build configuration, including dedicated xcconfig files (GRDB.xcconfig, GRDBCustomSQLite-Testing.xcconfig) that manage build flags and Swift versions. Header files (GRDB.h, GRDB-Bridging.h) and a configuration header (grdb\_config.h) have been added to the SQLiteCustom folder, with the latter providing C wrappers for SQLite configuration functions. The module map has been moved and updated to include the new header. Additionally, USER template files (.example) are provided to allow users to easily add custom SQLite compilation flags.

SQLiteCustom · medium confidence

The GRDB.xcworkspace has been reorganized to group related files and projects. Playgrounds are now located in a dedicated 'Playgrounds' group pointing to the Documentation/Playgrounds directory, and include samples for Tour, TransactionObserver, Associations, and MyPlayground. The workspace also references documentation files (BRAG.md, CHANGELOG.md, README.md, TODO.md, ReleaseProcess.md), a Makefile, the main GRDB.xcodeproj, a GRDBCustom.xcodeproj, a performance profiling project (GRDBProfiling), and a demo app project (GRDBDemo).

GRDB.xcworkspace · high confidence

The Support directory now contains extracted configuration files (GRDB.xcconfig, GRDBDeploymentTarget.xcconfig, GRDBTests.xcconfig) that define build settings such as Swift 6.1, iOS 13/macOS 10.15/tvOS 13/watchOS 7+ deployment targets, and SQLite feature flags. Header files (GRDB.h, grdb\_config.h, SQLCipher\_config.h, module.modulemap) have been moved into Support, with GRDB.h updated to import Foundation as a framework and Info.plist updated to use the PRODUCT\_BUNDLE\_IDENTIFIER variable.

Support · high confidence

The Tour playground has been updated to use modern closure syntax for database configuration and query building, and the playground is now configured to build under Xcode 12 by adding the buildActiveScheme setting.

Documentation/Playgrounds/Tour.playground · medium confidence

The GRDB Xcode project has been updated to object version 70, reflecting compatibility with newer Xcode versions. The project structure has been reorganized: test files are now grouped under a 'Tests' directory with a dedicated 'Crash' subfolder for crash tests, and the 'Supporting Files' group has been renamed to 'Support'. Additionally, new configuration files (GRDB.xcconfig, GRDBTests.xcconfig, GRDBDeploymentTarget.xcconfig) and a modulemap have been added to the project, and the workspace checks plist was added.

GRDB.xcodeproj · high confidence

The GRDBCustom Xcode scheme was updated to enable parallel execution of tests, allowing the test suite to run more efficiently. The configuration also ensures that the primary framework and the test bundle are built with appropriate flags for testing and running.

GRDBCustom.xcodeproj/xcshareddata · high confidence

The project has been upgraded to Xcode 26 (build system version 2600). The GRDB test scheme has been renamed from 'GRDB Tests' to 'GRDBTests', and the scheme configuration has been updated to enable code coverage and parallelizable test execution. Additionally, the scheme no longer builds the GRDB framework for testing, and the macro expansion for the framework has been removed from the test action.

GRDB.xcodeproj/xcshareddata · high confidence

Add unit tests for GRDBDemo app database and view model; Added SPM integration test for SQLite version reporting; Added Swift 6 migration test suite with concurrency-focused test cases; Added Xcode project for testing SPM integration; Added Xcode scheme configurations for performance tests; Added Xcode scheme for GRDBProfiling tests; Added Xcode test schemes for GRDB and encrypted GRDB tests; Added a standalone performance test target for GRDB; Added comprehensive test coverage for the new Cursor API and concurrency primitives; Added crash tests for GRDB database operations; Added iOS and macOS test projects for SPM; Added iOS test apps for CocoaPods integration; Added iOS test project for dynamic library testing; Added macOS app template for testing custom SQLite builds; Added manual install test app; Added performance benchmarking and reporting infrastructure; Added performance tests for GRDB; Added test infrastructure for SQLCipher4 integration; Added test project for custom SQLite builds; Added test workspace configurations for SQLCipher 3 and 4; Added test workspaces for CocoaPods integration; Expanded test coverage for GRDB with SQLCipher 3; Expanded test coverage for GRDB/SQLCipher4; Performance tests extracted to dedicated Xcode project; Updated GRDBProfiling Xcode project for modern Swift and Xcode compatibility.

The GRDB package now requires Swift 6.1 and updates minimum platform versions to iOS 13.0, macOS 10.15, tvOS 13.0, and watchOS 7.0. The Swift Package Manager configuration exposes GRDBSQLite as a system library and includes a privacy manifest file. Additionally, the package supports FTS5 by default and provides test configurations for CocoaPods and performance comparisons with libraries like FMDB, Realm, and SQLite.swift.

(dependencies) · high confidence

Written by watchdog.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

• First survey — no prior run to compare against. CAI 65.

• Code Health 96
• Architecture 96
• Maturity 54
• Readiness 100
• Security 68
• Domain Modelling 67

• 300 commits — 271 feature/other, 29 fixes

• GRDB/Core — 78 commits
• (repo) — 57 commits
• Tests/GRDBTests — 46 commits
• (root) — 37 commits
• GRDB/QueryInterface — 28 commits
• GRDB/Record — 12 commits
• GRDB/Documentation.docc — 7 commits
• Documentation/DemoApps — 5 commits
• GRDB/Migration — 5 commits
• .github/workflows — 4 commits
• GRDB/FTS — 3 commits
• GRDB/Utils — 3 commits
• Documentation/AssociationsBasics.md — 2 commits
• Documentation/CustomSQLiteBuilds.md — 2 commits
• GRDB/ValueObservation — 2 commits
• Tests/CocoaPods — 2 commits
• .vscode/settings.json — 1 commit
• Documentation/Playgrounds — 1 commit
• GRDB.xcodeproj/project.pbxproj — 1 commit
• GRDB/JSON — 1 commit

• fix: Failing regression test for #1820
• fix: Fix #1820
• fix: Fix Base image link
• fix: Fix Swiftlint warning
• fix: Fix Swiftlint warnings
• fix: Fix Swiftlint warnings
• fix: Fix a compiler error
• fix: Fix a warning in Version 27.0 beta
• fix: Fix failing test for #1838 by reseting all prepared statements before retrying
• fix: Fix failing test for merged migration that merges itself
• fix: Fix failing test for upsert in a table WITHOUT ROWID
• fix: Fix race condition regarding Task cancellation
• fix: Fix race condition: prevent cancellation from cancelling other database accesses after database accesses has completed
• fix: Fixed DatabaseSnapshotTests on non-darwin platforms
• fix: Fixed UUID fromDatabaseValue for non-Darwin platforms
• fix: Fixed databaseValue build for non-Darwin platforms.
• fix: Fixed fromDatabaseValue build under non-Darwin platforms
• fix: Fixed import in CGFloatTests.swift to work under non-Darwin platforms.
• fix: Fixed some linker errors caused by WAL absence on Linux.
• fix: Fixed the tests in DatabaseQueueTests.swift
• …and 280 more

Written by watchdog.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

groue/GRDB.swift was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point a surveyor at a repository you know and see whether you agree with it.