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
Added
- Support for SQLite Database. Tested with the WordPress SQLite Database Integration feature plugin. See Let’s make WordPress officially support SQLite and Help us test the SQLite implementation for more information about the SQLite integration in WordPress and the current status. Fixes #394 and #411.
- Support for plugin preview button that soon will be available in the WordPress.org plugin directory. This is a very nice way to quickly test plugins in your web browser. Read more in blog post “Plugin Directory: Preview button revisited” and follow progress in trac ticket “Add a Preview in Playground button to the plugin directory”. You can however already test the functionality using this link: preview Simple History plugin.
- IP addresses are now shown on occasions.
- Helper functions
get_cache_group(),clear_cache().
Changed
- Better support for MariaDB and MySQL 8 by using full group by in the query. Hopefully fixes multiple database related errors. Fixes #397, #409, and #405.
- Misc code cleanup and improvements and GUI changes.
This includes adding a note that the number of days the log is kept can be changed using a filter or an add-on.
Removed
- Usage of
SQL_CALC_FOUND_ROWSsince 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().
Fixed
- Stats widget counting could be wrong due to incorrect loggers included in stats query.