MySQL and Postgresql as standalone apps
-
@ChristopherMag Thanks for sharing
I've made a very simple custom app to deploy a psql DB using the Cloudron addon @ https://github.com/Lanhild/postgresql-cloudron
@Lanhild neat
so you just connect to that custom app as you would normally to a remote hosted postgres db ? -
@Lanhild neat
so you just connect to that custom app as you would normally to a remote hosted postgres db ?@timconsidine Exactly, spin up the app, grep the environment variables for the DB credentials and connect to it
-
Definitely worth adding to the AppStore.
Not much additional maintenance associated with having it there. -
wrote on Mar 11, 2024, 3:50 PM last edited by
@Lanhild If you want to take this a step further an option I wanted to explore but am not sure whether it would work would be to use something like node-tcp-proxy as the application itself with 5432 as source and destination port such that someone could connect to the app's name on port 5432 and the app would proxy that tcp session back to the postgresql database on port 5432.
There might be issues with this as I cannot think of another app example on cloudron that uses tcp without http on top so there may be some proxy stuff being done by cloudron itself before the connection makes it to the app that prevents this from working but it was on my list of things to try at some point.
-
wrote on Mar 11, 2024, 3:54 PM last edited by ChristopherMag Mar 11, 2024, 3:55 PM
@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.
-
wrote on Jan 27, 2025, 10:04 AM last edited by
Nudge on this! It looks like there are some good solutions which can easily add a lot of value!
-
wrote on Feb 22, 2025, 9:46 PM last edited by
Would love to see this. Self-hosted database makes n8n much more powerful.
-
wrote on Feb 23, 2025, 11:50 PM last edited by
Does PocketBase fill that gap?
-
wrote 20 days ago last edited by
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.
-
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.
wrote 20 days ago last edited by robi 19 days ago@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! -
wrote 20 days ago last edited by
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
-
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?