RootDB

RootDB is a self-hosted webapp allowing you to make reports using the full power of the SQL language. It's easy to use for users who just need to view report but the report development interface is designed for developers above all.

It is designed for associations, companies or start-ups that need:

• to easily view and navigate their data.
• to keep control over their data using an affordable self-hosted solution.
• to integrate reports into their back-office.

Features :

• Several reports can be opened in the same tab of your web browser.
• You can configure and use multiple database connections for your reports. (MySQL / MariaDB and PostgreSQL, but more are planned, like Microsoft SQL Server.)
• Simple and practical dynamic table configuration.
• Text, and metric views available to display context to your report.
• Create links to other reports.
• Full access to the three most popular charting libraries: Chart.js, D3.js and Apache ECharts, without any limitations.
• Javascript code, with sample SQL query, ready to use, for different chart models: the developer is guided.
• Practical keyboard short-cuts are available to limit the use of the mouse.
• Report parameters - use default parameters or easily create your own to filter the data in your reports.
• Create user groups, if necessary, to easily limit access to your reports. It is also possible to limit access to a report to one or more users.
• Integrate your reports into external websites in just a few clicks.
• Access to a real SQL console, to view and list the tables of your databases.
• Create as many drafts as you want to test your SQL queries.
• Enjoy auto-completion wherever you need to type SQL.
• Interface heavily use websocket to refresh its interface and get results from data views.
• Powerful cache system. Cache you long report periodically, with different sets of parameters or cache temporary current results to share then with other people quickly.