Datasource to an in-browser analytical DB

posted on March 24th, 2022

Re-Open

ravi asked on March 24, 2022

Hi!
Flexmonster looks very interesting and beautiful while being flexible to customize to a lot of our needs
I'm curious and looking forward to a solution where I'd like to connect the Pivot View to a local in-browser analytical db datasource something like duckdb (via wasm)
The current datasource options need the datasources to be a server side API endpoint to manage the filtering, grouping, aggregation and so.
It will be very helpful to understand if it is possible to achieve this sort of interaction in flexmonster.

Thanks
Ravi

2 answers

Public

Nadia Khodakivska ⋅ Flexmonster ⋅ March 28, 2022

Hello, Ravi,

Thank you for reaching out to us.

To connect to the data source like DuckDB, we recommend one of the following approaches:

The easiest way: writing a script that returns data in a JSON format and passes it to Flexmonster. More information you can find in our documentation: https://www.flexmonster.com/doc/json-data-source/
Implementing your own custom data source API to retrieve data from your database and pass it to Flexmonster. In your case, we recommend sending responses via JavaScript functions. You're welcome to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/r7g06asb/
You can learn more information in our documentation: https://www.flexmonster.com/doc/implement-custom-data-source-api/

Please let us know if it works for you. Feel free to contact us if other questions arise.

Kind regards,
Nadia

Public

ravi ⋅ March 29, 2022

Thanks, that is very helpful.

Changes to Flexmonster Software License Agreement

Datasource to an in-browser analytical DB

2 answers

Please login or Register to Submit Answer