IA Ignition has an internal SQLite database good f...
# umh-support
d
IA Ignition has an internal SQLite database good for 7 days, but you have to connect to an external DB for storing history beyond that timeframe. Postgres is one of the DB types you can connect to, and I've read that - if you turn off the IA table management functions - it will work with TimescaleDB (built on top of Postgres) as well. IA breaks up their tables into month-long chunks, but without the benefits of a hypertable in vanilla Postgres. They have internal tools that let you query across chunks, but if you write custom queries, you have to manage spanning the chunks manually. So I was thinking, if I migrate our Postgres IA Historian to TimescaleDB anyway, could I also add in the extra features of UMH, e.g. Grafanna, Node-Red etc., at the same time?