J. Nick Koston

Fix cpu thrashing during purge after all legacy events were removed

1

## Proposed change We now remove the the index of of event ids on the states table when its all NULLs to save space via #89901. The purge path needs...

Remove legacy event lookups from logbook

1

## Breaking change Automation and script traces that include state change events recorded with Home Assistant 2022.5.x or older will no longer display context information for these events in the...

Remove unneeded lambda_stmt in place add in statistics

1

## Proposed change We can generate this entire query in a single lambda_stmt so there is no need to add two which increases the size of the cache key ##...

Guard against selecting all invalid entity_ids in history

2

## Proposed change If all the `entity_ids` that were provided to the API do not exist we would end up passing an empty list of ids downline and the SQL...

Bump bluetooth deps for bleak 0.20

5

## Proposed change Bumps dependencies: * `bleak` to `v0.20.0` [[Compare](https://github.com/hbldh/bleak/compare/v0.19.5...v0.20.0)] [[Release](https://github.com/hbldh/bleak/releases/tag/v0.20.0)] * `dbus-fast` to `v1.84.2` [[Compare](https://github.com/Bluetooth-Devices/dbus-fast/compare/v1.84.1...v1.84.2)] [[Release](https://github.com/Bluetooth-Devices/dbus-fast/releases/tag/v1.84.2)] * `bleak-retry-connector` to `v3.0.1` [[Compare]](https://github.com/Bluetooth-Devices/bleak-retry-connector/compare/v2.13.1...v3.0.1) [[Release]](https://github.com/Bluetooth-Devices/bleak-retry-connector/releases/tag/v3.0.1) * `bluetooth-adapters` https://github.com/Bluetooth-Devices/bluetooth-adapters/compare/v0.15.2...v0.15.3 originally opened by @kiwiz...

Fix websocket back pressure bottleneck

5

## Proposed change This is yet another redux of `Client unable to keep up with pending messages` with some more insight on how it can happen. Our websocket implementation is...

Filter out duplicate updates in esphome state dispatch

1

## Proposed change Filter out duplicate updates in esphome state dispatch About 30% of the state updates I saw (power sensors) were duplicates which was needlessly writing state. ## Type...

## Proposed change changelog: https://github.com/python-zeroconf/python-zeroconf/compare/0.58.2...0.60.0 ## Type of change - [x] Dependency upgrade - [ ] Bugfix (non-breaking change which fixes an issue) - [ ] New integration (thank you!)...

Reduce space needed to store data for MySQL/MariaDB

4

## Proposed change These are the same improvements as #90246 and #91150 but for existing databases instead of only new databases This PR takes care of all the ones that...

Use faster contains check in humidifier

1

## Proposed change same as https://github.com/home-assistant/core/pull/106429 ## Type of change - [ ] Dependency upgrade - [ ] Bugfix (non-breaking change which fixes an issue) - [ ] New integration...