Bump sqlite3_connection_pool to 0.2.9 for GrapheneOS compatibility

[laurens-pilot]

Hi! sqlite_async currently declares sqlite3_connection_pool: ^0.2.7. Versions before 0.2.9 allocate executable-memory FFI callback trampolines when opening connection pools, causing release/AOT Flutter apps to abort on GrapheneOS when the per-app Dynamic code loading from memory restriction is enabled.

This was tracked in simolus3/sqlite3.dart#396 and fixed by simolus3/sqlite3.dart#397. The fix is available in sqlite3_connection_pool 0.2.9.

Would you be open to bumping the minimum dependency to ^0.2.9 and publishing a new sqlite_async release so consumers reliably pick up the fix? Thanks!

[simolus3]

Thanks for the report! We generally don't release versions just to bump dependencies we're already compatible with. Since we depend on ^0.2.7, this package is compatible with ^0.2.9 and you should be able to get that version with dart pub upgrade.

If you want to ensure you're on that version (e.g. if you don't commit your pubspec.lock), you can add an explicit dependency on sqlite3_connection_pool: ^0.2.9.