search

FlowFuse / flowfuse

Connect, collect, transform, visualise, and interact with your Industrial Data in a single platform. Use FlowFuse to manage, scale and secure your Node-RED solutions.
https://flowfuse.com
Other
278 stars 63 forks source link

SQLite support as back-end FlowFuse DB #3779

Open zackwasli opened 6 months ago

zackwasli commented 6 months ago

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 commented 6 months ago

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 ?