News for hackers. Stuff that matters.
Re:Show HN: CubeWeaver, a collaborative multidimensional web... by egeria_planning on Wednesday June 03, 2020 @06:39AM (#23401939)
Thank you. It is an Angular 9 SPA frontend with a .NET Core backend and an SQL database (MySQL or SQLITE) as a data store. I use several open source libraries. Handsontable is used to display the grid for example. A complete list is available in the help->about dialog.
Re:Show HN: CubeWeaver, a collaborative multidimensional web... by ar-jan on Wednesday June 03, 2020 @08:09AM (#23402460)
I'm curious, do you translate the multiple dimensions to a fully normalized relational structure, or do you also use complex structures like JSON inside the backend database?
Re:Show HN: CubeWeaver, a collaborative multidimensional web... by egeria_planning on Wednesday June 03, 2020 @08:31AM (#23402609)
The masterdata is stored as JSON to avoid creating/dropping columns and tables as list/columns are added and removed. But an option to have a fully normalized relational structure in an on-premise installation is on my feature list. It could be useful for enterprise clients who could use the data directly for reports and other applications.