This. Use a real database. A SQLite DB, fundamentally, is a generic configuration file manipulated with SQL. Its codebase is optimized for compact single file storage and a minimalist library footprint. It is not and never will be suitable for Tag History in any ordinary sense.
If you want maximum utility in a free database, I recommend PostgreSQL. I think MariaDB is also a good choice.