7.0.0-beta.2

A new release of the Swift toolkit for SQLite databases.

GRDB 7 beta is Xcode 16 and Swift 6 ready!

To upgrade, please follow the migration guide.

Raising the Swift concurrency checkings of Swift 6 can create compiler warnings. The new Swift Concurrency and GRDB guide is there to help you use GRDB from your Swift 6 code.

If you are looking for inspiration, the demo app was rewritten from scratch in a brand new Xcode 16 project.

What's Changed

• Breaking Change: Bump requirements by @groue in #1598 and #1634
• Breaking Change: Enhance ergonomics of record methods that insert/save/upsert and fetch by @groue in #1599
• Breaking Change: Rename the CSQLite module to GRDBSQLite, and stop exporting the C SQLite functions by @groue in #1600
• Breaking Change: Perform all writes with immediate transactions by default by @groue in #1602
• Breaking Change: Remove DatabasePool.concurrentRead by @groue in #1603
• Breaking Change: Coding strategies depend on the column by @groue in #1606
• Breaking Change: Add missing Sendable conformances by @groue in #1607 and #1639
• Breaking Change: Async database accesses honor Task cancellation by @groue in #1610
• Breaking Change: Prefer Collection over Sequence for filter(keys:) and related APIs by @groue in #1617
• Breaking Change: MainActor ValueObservation scheduling by @groue in #1633
• Breaking Change: Prefer any DatabaseReader and DatabaseWriter by @groue in #1635
• New: Sendable database accesses by @groue in #1618
• New: DatabaseCursor has a primary associated type by @groue in #1605
• Fix: Update .spi.yml by @finestructure in #1643

New Contributors

• @finestructure made their first contribution in #1643

Full Changelog: v6.29.3...v7.0.0-beta.2

6.29.3

A new release of the Swift toolkit for SQLite databases.

What's Changed

• Avoid SQLite misuse when releasing memory on a closed database connection by @groue in #1613

Full Changelog: v6.29.2...v6.29.3

6.29.2

A new release of the Swift toolkit for SQLite databases.

What's Changed

• README.md: Fix sample code by @mingchen in #1593
• Enhance imports for strcmp by @groue in #1595

New Contributors

• @mingchen made their first contribution in #1593

Full Changelog: v6.29.1...v6.29.2

6.29.1

A new release of the Swift toolkit for SQLite databases.

What's Changed

• Modernize the demo apps by @groue in #1579
• Update README to highlight deployment issue with CocoaPods by @SagarSDagdu in #1584
• Fix compilation issue with Xcode 16 beta 5 due to a missing import. by @noremac in #1589

New Contributors

• @SagarSDagdu made their first contribution in #1584
• @noremac made their first contribution in #1589

Full Changelog: v6.29.0...v6.29.1

6.29.0

A new release of the Swift toolkit for SQLite databases.

What's Changed

• Support for single value decoding by @sroebert in #1574
• Show comments when tracing expanded statements by @Jason-Abbott in #1575

New Contributors

• @sroebert made their first contribution in #1574
• @Jason-Abbott made their first contribution in #1575

Full Changelog: v6.28.0...v6.29.0

6.28.0

A new release of the Swift toolkit for SQLite databases.

• New: #1570 by @groue: Support single-value encoding
• New: Added QueryInterfaceRequest.deleteAndFetchIds(_:) which returns the set of deleted ids.
• New: Added Set methods union, formUnion, intersection and formIntersection that accept a cursor.
• New: DatabaseUUIDEncodingStrategy is Sendable.

6.27.0

A new release of the Swift toolkit for SQLite databases.

• Fixed: #1533 by @groue: Fix a bug in Decodable support
• Documentation Update: #1534 The Single-Row Tables guide was updated with guidance about default configuration values.
• Documentation Update: #1535 The ValueObservation Scheduling documentation chapter explains the default behavior of ValueObservation fetches, and explains how to make sure they are never performed on the main thread.

6.26.0

A new release of the Swift toolkit for SQLite databases.

• New: #1503 by @simba909: Conform Database.ColumnType to Sendable
• New: #1510 by @groue: Add Sendable conformances and unavailabilities
• New: #1511 by @groue: Database schema dump
• New: #1515 by @groue: Support for the CAST SQLite function
• Fixed: #1508 by @groue: Fix ValueObservation mishandling of database schema modification
• Fixed: #1512: Decoding errors are now correctly reported when decoding NULL into a non-optional property of type Data or Date.

6.25.0

A new release of the Swift toolkit for SQLite databases.

• New: #1496 by @danielepantaleone: Add privacy manifest file.

  A PrivacyInfo.xcprivacy resource was added to the GRDB SPM package and Xcode projects. It declares that GRDB does not collect anything.

6.24.2

A new release of the Swift toolkit for SQLite databases.

• Documentation Update: #1485: The Sharing a Database guide was updated with a new recommendation for databases shared between multiple processes. Writers should always perform IMMEDIATE transactions in order to avoid the SQLITE_BUSY error that can occur when transactions overlap. The new recommendation fits in a single line of code: configuration.defaultTransactionKind = .immediate.
• New: Associations that involve views instead of tables were already supported, with an explicit ForeignKey in their definition. When the foreign key is missing, a clear diagnostic message is now emitted, instead of an unhelpful "no such table" runtime error.

Changes from 6.24.1 and 6.24.0:

• Fixed: #1477: Remove shadow tables from database dump
• New: #1466 by @barnettben: Add schema name option to database introspection methods