History has many duplicate records

Looks like history is stored as JSON file. I presume its not the most efficient way of doing so. I guess others are keeping it in the database. Seems like sqlite would be a decent option allowing us to load & search it with sql directly. I wonder what others are using for it, maybe we could adopt some mature implementation of history management?