MySQL and Postgresql as standalone apps

[ChristopherMag]

@Lanhild Fyi, for me long term I think implementing PostgREST as a cloudron app is what I will eventually be aiming for as for me I am focused on postgresql and this app would eliminate the need for any code maintained by me in the cloudron app and just have my code in postgresql itself with the app dynamically building rest endpoints based on the code in postgresql.

The tcp proxy solution if possible would be useful separately as it would allow us access to MySQL, Mongodb, Postgresql, Redis, etc. directly via proxying the respective cloudron app service.

[eddowding]

Nudge on this! It looks like there are some good solutions which can easily add a lot of value!

[canadaduane]

Would love to see this. Self-hosted database makes n8n much more powerful.

[robi]

Does PocketBase fill that gap?

[canadaduane]

Does PocketBase fill that gap?

PocketBase is interesting, but I wouldn't reach for it first for core application state. Postgres is "boring technology" which is great for reliability, well-known, well-understood etc. That said, I'm sure PocketBase fills an important niche.

[robi]

@canadaduane Postgres doesn't have to be boring.

It can be a full stack system all-in-one!

Why bother with other things when it all comes down to the DB.
Have it do it!

See https://github.com/shouryashashank/pg-fullstack

[DualOSWinWiz]

I was also looking for this option but too lenghty to make a custom app on cloudron and due to these limitation i deployed portainer on intranetwork and proxy the portainer gui with cloudron app proxy as its on a seperate ubuntu and i have PG, MSSQL and MongoDB their

[msbt]

A standalone, fully customizable PostgreSQL would be nice indeed, I have a use-case where the timescaledb extension is required, has anyone tried that before?

[chmod777]

+1 for this. would make database testing/administration much easier!

@lanhild - i just saw you archived the git repository for the cloudron psql. is the code still usable/"up to date" or should i look elsewhere?

With Cloudron supporting custom apps soon, it would be nice to have this available somehow

[Lanhild]

@chmod777 Archived because I don't maintain it anymore. The core of the app itself works (check through the branches first).