SQLite support as back-end FlowFuse DB

[zackwasli]

Description

Today we support PostgreSQL as the default back-end database for FlowFuse. We should expand this support to include SQLite as an option.

Which customers would this be available to

Enterprise Tier Only (EE)

Requested by:

https://app-eu1.hubspot.com/contacts/26586079/record/0-2/10135626714

[knolleary]

Our code already supports both SQLite and Postgres. What we would need to know is what install type they are using - docker or k8s?

Given sqlite is based on access to a 'local' file, I'm not sure it makes sense in a k8s install. In a docker install - it would need a persistent volume to be mounted to the right bit of the docker setup. Unless I'm missing something, that would fairly simple to do. But the question is why do they want a different database technology when its an entirely internally managed component ?