This release took some time to be released but it's finally here and comes with lot's of new features.
- All project dependencies were upgraded to their latest version, as usual with a new release ;
- RootDB require now PHP 8.2 ;
- Lot's of bug fixes in the UI and changes under the hood from api side.
New features
- There's a new view info, allowing you to copy/past text & image, in order to add some context to a report. You can also associate a request to get data from the database and use it in your text. Same thing for the input report parameters.
- A new view metric. With this one you can highlight important metrics for your report. One or more metrics can be displayed, with custom color / icon.
- Cache system is in place, read just below.
Cache system
There are two types of cache.
Cache job
You can define several jobs for the same report, using several sets of parameters, automatically refreshed at different frequencies (every x minutes, hours, days, etc.) If the report contains parameters with drop-down lists, for example, the system will generate cache for all combinations of parameters.
User cache
All type of users (admin, dev or viewer) can store current report's results in a temporary cache in order to be able to show to someone else these results without loosing time - if it's a long running report.
New docker images
Docker images have been simplified, please refer to the documentation.
TLDR : the rootdb image now contains directly a nginx proxy, php-fpm and supervisor, allowing you to install it more easily in your docker environment.
New installation update / script
On the github repository you'll find a brand new bash script to install / update more easily RootDB in a VPS environment, for instance. This script check if all dependencies are met, auto-configure the frontend and api environment files and allow you to roll-back easily to a previous version of RootDB.
What's coming next
We will focus on documentation :
- the main documentation website will be updated in the coming days ;
- a youtube channel will be created to make how-to videos and help people to install, use RootDB, demonstrating all possibilities.
Functionalities :
- Report auto-refresh ;
- Chart.js - configuration module, to prevent you to write javascript for common setup use-case ;
- New connector for Microsoft SQL server.
That's all for now, please stay tuned.
