ByteBrief

Best read upright.

We're a portrait publication through and through. Turn your phone back and your briefing picks up right where you left it.

(We tried widescreen once. It wasn't us.)

ByteBrief

ChipsXDAabout 3 hours ago

PostgreSQL swap speeds up Home Assistant history

1 min read

Home Assistant's default SQLite database slows history rendering to 5-10 seconds with 50+ devices. Swapping to PostgreSQL makes the smart home feel snappy. The bottleneck is the single-file database, not CPU or Wi-Fi.

Level

Hype check

Tap to vote and see what everyone thinks.

#home assistant #postgresql #sqlite

Read full story

More to chew on!

AIabout 24 hours ago

SQLite compressed text-history prototypes

Tech4 days ago

Concurrency vs. Throughput: why more parallelism can make databases slower

AI6 days ago

Database Migration Service automates SQL Server to PostgreSQL translation

Summary by ByteBrief