Better support for external postgres instance

[kenske]

I'd like to connect splitpro to an existing postgresql instance, instead of having a separate postgres container just for splitpro.

The first issue I encountered is needing to install pg_cron, which is fine, but then the app expects to have full root access to the instance, which is not an option in a multi-tenant instance.

Proposed solution

• App is able to use a regular DB user to set up schema
• pg_cron is replaced by in-app scheduling

[krokosik]

I'll have to research how to set pg_cron in a way that does not require root. I am not that familiar with pg extensions so help is welcome.

The latter option is a definite no go for me.

[stephan-merkli]

Assuming pg_cron is only used for recurring expenses, one option would be to make recurring expenses configurable and allow the feature to be disabled. This would make it possible to run SplitPro on a standard PostgreSQL instance without requiring pg_cron.

That could simplify installation further and may not be a disadvantage for users who do not need recurring expenses functionality.