top | item 23401939

(no title)

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.

discuss

ar-jan|5 years ago

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?

egeria_planning|5 years ago

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.