Databases

Changed

* Drop support for Python 3.7 and add support for Python 3.12 ([583][583])
* Add support for SQLAlchemy 2+ ([540][540])
* Allow SSL string parameters in PostgresSQL URL ([575][575]) and ([576][576])

[583]: https://github.com/encode/databases/pull/583
[540]: https://github.com/encode/databases/pull/540
[575]: https://github.com/encode/databases/pull/575
[576]: https://github.com/encode/databases/pull/576

Added

* Allow SQLite query parameters and support cached databases ([561][561])
* Support for unix socket for aiomysql and asyncmy ([551][551])

[551]: https://github.com/encode/databases/pull/551
[561]: https://github.com/encode/databases/pull/546

Changed

* Change isolation connections and transactions during concurrent usage ([546][546])
* Bump requests from 2.28.1 to 2.31.0 ([562][562])
* Bump starlette from 0.20.4 to 0.27.0 ([560][560])
* Bump up asyncmy version to fix `No module named 'asyncmy.connection'` ([553][553])
* Bump wheel from 0.37.1 to 0.38.1 ([524][524])

[546]: https://github.com/encode/databases/pull/546
[562]: https://github.com/encode/databases/pull/562
[560]: https://github.com/encode/databases/pull/560
[553]: https://github.com/encode/databases/pull/553
[524]: https://github.com/encode/databases/pull/524

Fixed

* Fix the type-hints using more standard mode ([526][526])

[526]: https://github.com/encode/databases/pull/526

Fixed

* Fixed breaking changes in SQLAlchemy cursor; supports `>=1.4.42,<1.5` ([513][513])
* Wrapped types in `typing.Optional` where applicable ([510][510])

[513]: https://github.com/encode/databases/pull/513
[510]: https://github.com/encode/databases/pull/510

Changed

* Pinned SQLAlchemy `<=1.4.41` to avoid breaking changes ([520][520])

[520]: https://github.com/encode/databases/pull/520

Fixed

* Improve typing for `Transaction` ([493][493])
* Allow string indexing into Record ([501][501])

[493]: https://github.com/encode/databases/pull/493
[501]: https://github.com/encode/databases/pull/501

* Dropped Python 3.6 support ([458][458])

[458]: https://github.com/encode/databases/pull/458

Added

* Add \_mapping property to the result set interface ([447][447])
* Add contributing docs ([453][453])

[447]: https://github.com/encode/databases/pull/447
[453]: https://github.com/encode/databases/pull/453

Fixed

* Fix query result named access ([448][448])
* Fix connections getting into a bad state when a task is cancelled ([457][457])
* Revert 328 parallel transactions ([472][472])
* Change extra installations to specific drivers ([436][436])

[448]: https://github.com/encode/databases/pull/448
[457]: https://github.com/encode/databases/pull/457
[472]: https://github.com/encode/databases/pull/472
[436]: https://github.com/encode/databases/pull/436