Hacker News new | ask | show | jobs
by egeria_planning 2205 days ago
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.
1 comments
ar-jan 2205 days 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?
link
egeria_planning 2205 days 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.
link