Postgres for a surfer app?

[chetbaker]

Hello folks,

Brief warning, this may be a very stupid question.

I'm running an 11ty instance locally with a postgres database for tons of data I'm hosting there.

Ideally I would like to host the site in Cloudron (given is a 11ty, probably a Surfer install is the option) but I'm kind of lost what to do with the Posrgres database. I've been reading documentation and discussions here but I'm still lost. I just need to fill up a database in Cloudron for that to be used by the surfer app.

Is that possible? What piece am I missing?
Thanks!

[nebulon]

I am not really familiar with 11ty but looks like a static site generator. If postgres is required during generating the static assets, then this does not have to be on Cloudron. But I don't know the setup you currently have. Maybe with some git push hooks and the site is built on the server as well as served up?

Surfer will do if all assets are static, but it does not execute any code on the server, so a database would not make any sense for it.

[chetbaker]

Thanks @nebulon that's exactly right. It's a static site generator to serve pages based on a postgresdb I'm currently hosting locally that I would love to host in cloudron and not to depend on a third party.

[nebulon]

Since it is a static site generator, I guess you could also generate the assets locally and then push to a surfer instance.

Otherwise, it may be similar to github pages, which build the static assets on git push and then just serve those. For this you would probably build a custom Cloudron app, which knows how to build the assets.