[FEATURE] Replace MongoDB with an ORM layer with SQLite support

[timlrx]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

Suggest to replace MongoDB and mongoose with a generic ORM layer and use SQLite as part of the official docker build

Is your feature request related to a problem/limitation?

MongoDB uses a restrictive proprietary license that includes restrictions on the use of service (clause 13). This restricts adoption and broader usage.

Describe the solution you'd like

1. Use an ORM layer for flexibility so the database of choice can be determined by the end user. For backward compatibility, my preference would be to use an ORM which supports both SQL and non-SQL e.g. Prisma or Typeorm. More research probably needs to be done to see what works best with the current setup.
2. Use SQLite as the default choice for packaged builds:
   • Included with most systems
   • Extremely battle tested
   • Small dependency
   • Public domain
   • Easy to switch out to Postgres / MySQL or your favourite SQL compatible DB

Alternatives

No response

Additional Context

No response

Related Issues/PRs

No response