DbGate 1-Click deployment on Cloudron now available #1524

Cloudron community package for DbGate

First of all, thank you for DbGate; the amount of ground it covers (thirteen engines, a
proper query editor, real export tooling) in a project this approachable to run is rare.

There is now a community package of DbGate 7.2.3 for Cloudron,
the self-hosting platform, so Cloudron users can run DbGate with managed backups, updates
and single sign-on.

Package repository: https://github.com/OrcVole/dbgate-cloudron

https://forum.cloudron.io/topic/15771/dbgate-community-package-now-available

It is listed on the Cloudron community app store, and installs from this versions URL:
https://raw.githubusercontent.com/OrcVole/dbgate-cloudron/main/CloudronVersions.json

One of the great advantages of deploying using Cloudron is that it greatly eases the burdens of maintenance and keeping the software secure.

What works, all verified on a live installation before publishing: the web UI, the RPC API,
export to CSV/Excel/NDJSON, Cloudron single sign-on via the generic OAuth2 support (mapped
onto Cloudron's OIDC addon), and a generated local login for installs without SSO.

One gap: this packages the community edition only. Team Premium's multi-user
storage-database mode, per-user role-based access control, and the write-capable MCP tools
are commercial features and are not part of this package; the community edition is a single
shared workspace, which the package documents plainly for anyone installing it.

While packaging we kept notes on the few places where a constrained platform differs from the
reference deployment, offered gratefully in case any are useful upstream:
https://github.com/OrcVole/dbgate-cloudron/blob/main/docs/FOR-UPSTREAM.md , the two headline items are that WORKSPACE_DIR works well but is not on the documented environment-variables page, and an environment-variable alternative to --encryption-key would let a platform supply its own wrapping secret without a command-line exposure trade-off.

Happy to answer questions about the package here or on the package repository; application
issues of course belong to DbGate itself, and I redirect Cloudron users accordingly.

If you develop DbGate or would like to see it improved, we hope you might head over to the Cloudron forum and introduce yourself there on the thread. We would love to hear from you!

The Cloudron community announcement, with screenshots and more detail on the install:
https://forum.cloudron.io/topic/15771/dbgate-community-package-now-available