Upcoming Changes: Enhancements to Multi-Database Support. Dropping support for SQLite3 and older ActiveRecord versions

[seuros]

Hello everyone,

As part of our ongoing efforts to improve the with_advisory_lock gem, we are planning some significant changes in the upcoming release, which we wanted to share with you in advance to help you prepare for the transition.

Enhanced Multi-Database Support
This update aims to provide cleaner implementation by injecting the need code into the adapters directly.

Dropping Support for SQLite3
We have decided to drop support for SQLite3 in the next major release of with_advisory_lock. PostgreSQL and MySQL provide the capability natively, and this will allow us to simplify the codebase.

Single-node SQLite consumers can substitute this library with a mutex.

Support for ActiveRecord 7+
With the incoming release of a new Rails version and bi g refactoring going on in rails/rails, it will be more beneficial to drop support for legacy version.

Action Required
If you are currently using SQLite3 with with_advisory_lock, we recommend transitioning to a supported database system such as PostgreSQL or MySQL before the next release or lock the version.

We understand that these changes may require adjustments in your applications, and we are here to help.

Best regards,
Seuros

cc @mceachen