# New release: GRDB 5.0.0-beta

**URL:** <https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107>\
**Category:** GRDB\
**Created:** [May 3, 2020, 9:25am UTC](https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107 "2020-05-03T09:25:40Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![gwendal.roue](https://sea2.discourse-cdn.com/swift/user_avatar/forums.swift.org/gwendal.roue/32/13992_2.png) [@gwendal.roue](https://forums.swift.org/u/gwendal.roue)\
**Post date:** [May 3, 2020, 9:25am UTC](https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107/1 "2020-05-03T09:25:40Z")

</div>

Hello Swift Community,

[GRDB](https://github.com/groue/GRDB.swift), the "toolkit for SQLite databases, with a focus on application development" has been upgraded to version 5.0.0-beta.

It comes with the version 1.0.0-beta of its companion libraries [GRDBCombine](https://github.com/groue/GRDBCombine) and [RxGRDB](https://github.com/RxSwiftCommunity/RxGRDB).

* * *

The new features are:

- **Support for subqueries**

- **Simplified handling of SQLite error codes**

- **Simplified switch between system SQLite, SQLCipher, and custom SQLite builds**

* * *

GRDB 5.0 beta comes with breaking changes as well. The [Migrating From GRDB 4 to GRDB 5](https://github.com/groue/GRDB.swift/blob/master/Documentation/GRDB5MigrationGuide.md) guide is there to describe them, and help you upgrade.

The active help of beta testers is much welcomed! Do you experience any difficulty or bug during the upgrade? Please chime in this forum, in a [GitHub issue](https://github.com/groue/GRDB.swift/issues), or on [Twitter](http://twitter.com/groue).

- [Release notes](https://github.com/groue/GRDB.swift/blob/master/CHANGELOG.md#500-beta)
- Migration Guides: [GRDB](https://github.com/groue/GRDB.swift/blob/master/Documentation/GRDB5MigrationGuide.md), [GRDBCombine](https://github.com/groue/GRDBCombine/blob/master/Documentation/GRDBCombine1MigrationGuide.md), and [RxGRDB](https://github.com/RxSwiftCommunity/RxGRDB/blob/master/Documentation/RxGRDB1MigrationGuide.md)

Happy [GRDB](https://github.com/groue/GRDB.swift)!

---

<div class="post-metadata">

**Author:** ![gwendal.roue](https://sea2.discourse-cdn.com/swift/user_avatar/forums.swift.org/gwendal.roue/32/13992_2.png) [@gwendal.roue](https://forums.swift.org/u/gwendal.roue)\
**Post date:** [May 11, 2020, 5:14pm UTC](https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107/2 "2020-05-11T17:14:18Z")

</div>

Hello,

GRDB 5.0.0-beta.2 has shipped today, with:

- More robust support for subqueries, in particular subqueries can now refer to other tables.
- The ability to check if the database schema is too recent (as suggested by @remcopoelstra [here](https://forums.swift.org/t/detect-future-database-migrations/36315)).
- Another breaking change: the (hopefully rare) applications that define custom requests on top of the `FetchRequest` protocol are warmly encouraged to use regular query interface requests or SQL requests instead.

More details in the [Release notes](https://github.com/groue/GRDB.swift/blob/master/CHANGELOG.md#500-beta2).

As always, write a message here or in a [GitHub issue](https://github.com/groue/GRDB.swift/issues) if you have any question.

Happy beta testing!

---

<div class="post-metadata">

**Author:** ![gwendal.roue](https://sea2.discourse-cdn.com/swift/user_avatar/forums.swift.org/gwendal.roue/32/13992_2.png) [@gwendal.roue](https://forums.swift.org/u/gwendal.roue)\
**Post date:** [June 1, 2020, 6:39pm UTC](https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107/3 "2020-06-01T18:39:06Z")

</div>

Hello,

GRDB 5.0.0-beta.3 is out! It contains bug fixes, as well as (new!) an API to measure the duration of executed database queries.

More details in the [Release notes](https://github.com/groue/GRDB.swift/blob/master/CHANGELOG.md#500-beta3).

Thanks for upgrading your apps!

---

<div class="post-metadata">

**Author:** ![gwendal.roue](https://sea2.discourse-cdn.com/swift/user_avatar/forums.swift.org/gwendal.roue/32/13992_2.png) [@gwendal.roue](https://forums.swift.org/u/gwendal.roue)\
**Post date:** [June 6, 2020, 3:00pm UTC](https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107/4 "2020-06-06T15:00:01Z")

</div>

Hello,

We have three releases today:

- GRDB 5.0.0-beta.4: [Release notes](https://github.com/groue/GRDB.swift/blob/master/CHANGELOG.md#500-beta4)
- GRDBCombine 1.0.0-beta.2: [Release notes](https://github.com/groue/GRDBCombine/blob/master/CHANGELOG.md#100-beta2)
- RxGRDB 1.0.0-beta.2: [Release notes](https://github.com/RxSwiftCommunity/RxGRDB/blob/master/CHANGELOG.md#100-beta2)

GRDBCombine and RxGRDB apis are simplified, GRDB has learned a few SQLite date functions, and it is easier to identify the various SQLite connections when one wants to, for debugging purposes.

---

<div class="post-metadata">

**Author:** ![gwendal.roue](https://sea2.discourse-cdn.com/swift/user_avatar/forums.swift.org/gwendal.roue/32/13992_2.png) [@gwendal.roue](https://forums.swift.org/u/gwendal.roue)\
**Post date:** [June 15, 2020, 6:26pm UTC](https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107/5 "2020-06-15T18:26:57Z")

</div>

Hello,

GRDB 5.0.0-beta.5 is out: [Release notes](https://github.com/groue/GRDB.swift/blob/master/CHANGELOG.md#500-beta5)

In this release:

- (Breaking) Enhancements for WAL checkpointing.
- `Database.maximumStatementArgumentCount` helps you chunking big lists in order to avoid SQLite errors.
- An optimization when you observe a database value: GRDB can now avoid some useless fetches.
- New query interface apis that provide access to the primary key.
- A well-deserved update of the [Demo Application](https://github.com/groue/GRDB.swift/blob/master/Documentation/DemoApps/GRDBDemoiOS), which more closely follows the [Good Practices for Designing Record Types](https://github.com/groue/GRDB.swift/blob/master/Documentation/GoodPracticesForDesigningRecordTypes.md).
- New [FAQ: Associations](https://github.com/groue/GRDB.swift/blob/master/README.md#faq-associations).

Happy download!

---

<div class="post-metadata">

**Author:** ![gwendal.roue](https://sea2.discourse-cdn.com/swift/user_avatar/forums.swift.org/gwendal.roue/32/13992_2.png) [@gwendal.roue](https://forums.swift.org/u/gwendal.roue)\
**Post date:** [June 29, 2020, 6:34am UTC](https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107/6 "2020-06-29T06:34:49Z")

</div>

Hello,

GRDB 5.0.0-beta 6 is out: [Release notes](https://github.com/groue/GRDB.swift/blob/master/CHANGELOG.md#500-beta6).

In this release:

- (Breaking) **Embedded Combine support** : remove your dependency on the companion library GRDBCombine. Documentation available in the new [GRDB ❤ Combine](https://github.com/groue/GRDB.swift/blob/master/Documentation/Combine.md) guide.
- [Debugging operators](https://github.com/groue/GRDB.swift/blob/master/README.md#valueobservation-operators) for ValueObservation.
- A new [demo app](https://github.com/groue/GRDB.swift/blob/master/Documentation/DemoApps/GRDBCombineDemo/README.md) for GRDB + Combine + SwiftUI
- Faster decoding of Date and DateComponents.

And of course, GRDB works perfectly on Xcode 12 beta 🏗 😄

Happy upgrade!

---

<div class="post-metadata">

**Author:** ![gwendal.roue](https://sea2.discourse-cdn.com/swift/user_avatar/forums.swift.org/gwendal.roue/32/13992_2.png) [@gwendal.roue](https://forums.swift.org/u/gwendal.roue)\
**Post date:** [July 14, 2020, 7:24pm UTC](https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107/7 "2020-07-14T19:24:26Z")

</div>

Hello Swift community,

Today is Bastille Day, a perfect opportunity for releasing GRDB 5.0.0-beta 7 🥳

[Release notes](https://github.com/groue/GRDB.swift/blob/master/CHANGELOG.md#500-beta7)

---

<div class="post-metadata">

**Author:** ![gwendal.roue](https://sea2.discourse-cdn.com/swift/user_avatar/forums.swift.org/gwendal.roue/32/13992_2.png) [@gwendal.roue](https://forums.swift.org/u/gwendal.roue)\
**Post date:** [July 24, 2020, 7:16am UTC](https://forums.swift.org/t/new-release-grdb-5-0-0-beta/36107/8 "2020-07-24T07:16:12Z")

</div>

Hello,

A big thank you to beta testers who report their issues and questions regarding the migration to GRDB 5! Beta 9 has just shipped.

[Release notes](https://github.com/groue/GRDB.swift/blob/master/CHANGELOG.md#500-beta9)
