It is a pure Javascript database running on the user’s browser that supports the industry.standard SQL language close to the '99 specification.
IIts unique features make it particularly a suitable solution for the Cloud. It fact it was designed with that purpose in mind.
The database is created when the html page is loaded and destroyed when the page is closed.. During its creation process a comprehensive schema is created with a lot of tables representing almost all entities of Jira Core Software and Service Manager (issues, projects, boards, sprints, SLA, queues, etc).
All the built-in tables have no data. They are empty and populated in real-time to answer the users' queries: all the data are fetched over the Jira public REST API sharing the same user’s http session: in other words, all the queries run in the calling user’s context honoring the Jira permissions. Therefore, it does not require any users nor permissions configuration as they are implicitly inherited from Jira.
The installation process is 1-click from the Atlassian Marketplace and it is ready to run out-of-the-box with no further configuration.
In addition, it supports the Atlassian JQL language to search for issues in SQL queries taking advantage of the best of both languages working together with no limits.
Its major tech features:
Dynamic tables: empty tables populated in real-time
Asynchronous engine: the engine s able to pause waiting for the remote web services and continue when the data are received over the network.
Scalable architecture: it grows up with the user base running on the user’s local hardware lacking a third-party server acting as bottleneck.
Data privacy & security: no data are shared with any third-party server and the user base and permissions are inherited from the Jira configuration.
Outstanding integration: it looks and feel like a real relational database. Just like the missing JIra database in cloud environments.
Multi datasource: it supports Jira and other data sources like Google sheets, CSV, XML, etc.
Industry-standards: it brings all the power of the SQL language to the enterprise.
...
