Hi everyone,
I'm planning to build an architecture where multiple users (clients) can connect to an OpenLCA server, work on their own projects using a shared .zolca database (predefined dataset), and perform LCA calculations based on specific stages and allowed input/output variables that I define.
Here’s the core idea:
Each user will work on their own project.
I want to expose only specific variables and life cycle stages via a frontend or client interface.
Calculations should be executed on the server side (OpenLCA backend or API).
The results (LCI/LCIA or custom KPIs) should be stored in a MariaDB database for further analysis.
I'm evaluating whether the Collaboration Server is suitable for this, or if it’s better to use OpenLCA’s API and build a fully custom backend.
Has anyone implemented something similar?
Is it possible to intercept/trigger OpenLCA calculations via REST or programmatically, and extract structured results to store them in a SQL database?
Any insights, best practices, or architectural tips would be greatly appreciated!
Thanks in advance!
