|
How to make a full backup and restore with all the data as well?
|
|
20
|
36022
|
October 26, 2025
|
|
Migrate InfluxDB data to HA long term statistics
|
|
2
|
290
|
October 22, 2025
|
|
Recover data from corrupted sqlite3 db? sqlite3: command not found
|
|
1
|
323
|
October 9, 2025
|
|
Time Series Databases and Stacks in 2025: InfluxDB+Telegraf vs Prometheus+Exporters (Node and cAdvisor)
|
|
8
|
3098
|
October 4, 2025
|
|
State history not available for any sensor
|
|
1
|
161
|
September 30, 2025
|
|
How to keep Energy Data when switching Device
|
|
1
|
148
|
September 21, 2025
|
|
Is the contect ID in a script trace related to the contect_id_bin in the database?
|
|
0
|
62
|
September 14, 2025
|
|
Reduce more than 90% your SQLite DB with DuckDB
|
|
6
|
1289
|
September 9, 2025
|
|
Migrated to timescaledb // schema updates every boot, unique key constraints after time
|
|
0
|
99
|
September 6, 2025
|
|
Database wiped when migrating maridaDB location
|
|
1
|
204
|
August 31, 2025
|
|
How I tackled a bloated home-assistant_v2.db file
|
|
3
|
2264
|
July 29, 2025
|
|
Home Assistant Recorder Database Editor
|
|
0
|
743
|
July 17, 2025
|
|
MariaDB database growth is > than SQLite
|
|
17
|
746
|
July 12, 2025
|
|
Energy dashboard historic data lost, maybe after OS upgrade or new sensor addition
|
|
1
|
637
|
July 11, 2025
|
|
History logs and Recorder, which 3rd party db introduction - newbies guide?
|
|
1
|
221
|
July 6, 2025
|
|
Can each version of home assistant have the ability to re-correct the database structure required by this version?
|
|
2
|
125
|
June 24, 2025
|
|
Backup is growing rapidly without a special reason - from 2 to 4.1GB in 12 days
|
|
8
|
413
|
June 22, 2025
|
|
Anyone use sql to grab energy data from the statistics database?
|
|
0
|
118
|
June 21, 2025
|
|
Extract production data from SQlite3 database HA
|
|
11
|
727
|
June 17, 2025
|
|
How Adjust total usage for specific sensor (Bambulab X1C)
|
|
2
|
277
|
June 16, 2025
|
|
Long term statistics on a separate database
|
|
30
|
8435
|
June 15, 2025
|
|
"Replace sensor or entity" workflow that keeps history and helps the user
|
|
1
|
316
|
June 12, 2025
|
|
Relational Database Management Systems in 2025
|
|
0
|
444
|
May 28, 2025
|
|
Possible to analyze historical data with LLM?
|
|
1
|
295
|
June 1, 2025
|
|
Data loss after recorder auto_purge and auto_repack
|
|
13
|
346
|
May 22, 2025
|
|
Excluding sensors from the recorder. What's the point?
|
|
14
|
833
|
May 20, 2025
|
|
How to control how often SQL commands execute?
|
|
2
|
172
|
May 16, 2025
|
|
Sensor MariaDB size not working
|
|
17
|
9262
|
May 12, 2025
|
|
MariaDB exited with code 256
|
|
4
|
183
|
May 3, 2025
|
|
How to query database to get unique values from a sensor?
|
|
2
|
1067
|
May 1, 2025
|