Since 2022, when this idea became the focus of my masterโs thesis (๐๐ผ๐ป๐๐ฒ๐ฟ๐๐ฎ๐๐ถ๐ผ๐ป๐ฎ๐น ๐๐ฐ๐ฐ๐ฒ๐๐ ๐๐ผ ๐ฅ๐ฒ๐น๐ฎ๐๐ถ๐ผ๐ป๐ฎ๐น ๐๐ฎ๐๐ฎ ๐๐ ๐ฝ๐น๐ผ๐ถ๐๐ถ๐ป๐ด ๐๐๐ ๐), Iโve been working relentlessly to make it real. What started as a research project has grown into a commercial mission: to transform how we interact with data and how we, as developers, build dashboards and present information.
The concept seemed simple at first. But as we dove deeper into connecting local databases like ๐ ๐๐ฆ๐ค๐, ๐ฃ๐ผ๐๐๐ด๐ฟ๐ฒ๐ฆ๐ค๐ or wider business DBMS such as ๐ข๐ฟ๐ฎ๐ฐ๐น๐ฒ or ๐ฆ๐ค๐๐ฆ๐ฒ๐ฟ๐๐ฒ๐ฟ, and integrating remote APIs and stock information, we realized that the technical and security challenges were immense.
Ensuring the tool could run in the browser, without any installation, was another major hurdle.
After countless nights of debugging and rethinking approaches, weโve built something that works. It is based on Angular frontend and Nodejs middleware: nothing more, nothing less.
๐งช Hereโs how:
- ๐ก๐ผ ๐๐ฒ๐ฐ๐ต๐ป๐ถ๐ฐ๐ฎ๐น ๐๐ธ๐ถ๐น๐น๐ ๐ฟ๐ฒ๐พ๐๐ถ๐ฟ๐ฒ๐ฑ: You can speak your request, and the system will generateย charts,ย widgets, andย tablesย instantly. Nothing is hardcoded.
- ๐๐บ๐ฏ๐ฒ๐ฑ๐ฑ๐ฎ๐ฏ๐น๐ฒ ๐๐ถ๐ฑ๐ด๐ฒ๐๐: Easily integrate custom-made widgets into a website or even a company-size project, with all the necessary information gathered on the fly.
- ๐๐น๐ฒ๐ ๐ถ๐ฏ๐น๐ฒ ๐ฐ๐ผ๐ป๐ป๐ฒ๐ฐ๐๐ถ๐ผ๐ป๐: Whether itโsย MySQL,ย Oracle,ย SQLServer,ย PostgreSQL, local files,ย APIs,ย open data, websites, or stock and news info โ this tool can handle it all.
- ๐ญ๐ฒ๐ฟ๐ผ ๐ถ๐ป๐๐๐ฎ๐น๐น๐ฎ๐๐ถ๐ผ๐ป๐: It runs directly in your browser while securely accessing local data sources.
Throughout this process, we have constantly grappled with challenges, balancing ๐ฑ๐ฎ๐๐ฎ ๐ฎ๐ฐ๐ฐ๐ฒ๐๐๐ถ๐ฏ๐ถ๐น๐ถ๐๐, ๐๐ฒ๐ฐ๐๐ฟ๐ถ๐๐, and the desire to create something that anyone can use. We have now reached a point where the tool is ๐ฐ๐ผ๐๐-๐ฒ๐ณ๐ณ๐ถ๐ฐ๐ถ๐ฒ๐ป๐ (1โฌ/250 widgets), with ๐ป๐ผ ๐ฑ๐ฎ๐๐ฎ ๐๐ต๐ฎ๐ฟ๐ถ๐ป๐ด involved (whatโs called โdata agnosticismโ).
However, there is still much to be doneโฆ ๐ก๐ฒ๐ ๐ ๐๐๐ฒ๐ฝ๐:
- Integrateย ๐ฒ๐ฑ๐ด๐ฒ ๐ฐ๐ผ๐บ๐ฝ๐๐๐ถ๐ป๐ด ๐๐๐ ๐ย to make the tool 100% free and privacy-focused (frontier development).
- Expand its use for developers as aย ๐ฏ๐ฎ๐ฐ๐ธ๐ฒ๐ป๐ฑ ๐๐ผ๐น๐๐๐ถ๐ผ๐ปย or through APIs.
- Introduceย ๐ฐ๐ผ๐น๐น๐ฎ๐ฏ๐ผ๐ฟ๐ฎ๐๐ถ๐๐ฒ ๐บ๐ผ๐ฑ๐ฒย and integration withย PowerBIย andย Tableau.
Specific information and technical analysis have been reported in the ๐๐ต๐ถ๐๐ฒ๐ฝ๐ฎ๐ฝ๐ฒ๐ฟ linked below โฌ๏ธ.
What started as a thesis has grown into something much bigger. This project is still a challenge (huge thanks to collaborators Gianni Bellorio, Daniele Martini and Alessia Bogoni), but letโs push it forward.
