Database fit for purpose or do i need an external db?

Configuration
, ,
1

so ive recently started using HA, got some sensors setup and smart plugs etc all seems good in the world, then someone recently told me that the history im recording and expecting to use for analysis isnt going to be there after 10 days as HA doesnt store that?

i want to be able to do some analysis for different things in the future and review old data captured, so my question is there a limitation in HA, and if there is what should i configure? (mariadb?)

if there isnt a limitation is the built in DB still useful for my goals or will it over time become a problem and really need a different DB location?

as its early days it feels like now is the time to make those tough decisions so i get the correct setup for the future

2

Hello,

There are many solution but I personally like influxdb.

I am running about 50 sensors for more than 2 years without any retention issue.

If the home assistant db becomes huge it can create issue or slow down.

At beginning of my journey I have read this post: https://community.home-assistant.io/t/how-to-keep-your-recorder-database-size-under-control/295795

Depending on what you want to achieve keep in mind the purge default time here the docs: https://www.home-assistant.io/integrations/history/#:~:text=By%20default%2C%20the%20recorder%20stores,is%20taken%20from%20the%20recorder.