Simple History 4.9.0 – faster and better queries (and support for SQLite!)

Version 4.9.0 of Simple History comes with improvements to the SQL queries that the plugin use to fetch events. These optimizations enhance query performance and reliability on both MySQL and MariaDB.

Additionally, the plugin now provides support for SQLite databases.

Full changelog




  • Usage of SQL_CALC_FOUND_ROWS since it’s deprecated in MySQL 8.0.17. Also this should make the query faster. Fixes #312.
  • Columns “rep”, “repeated” and “occasionsIDType” are removed from return value in Log_Query().


  • Stats widget counting could be wrong due to incorrect loggers included in stats query.