Support Attachments in External Data Sources

[daawaan4U]

Describe the feature request Since attachments are stored as their metadata in the form of JSON objects in the underlying CouchDB for BudibaseDB, external data sources should be able to store it as well. Some of the external data sources that have been integrated into Budibase already natively support storing JSON and the remaining datasources can fall back to storing the JSON objects as texts/varchar/string instead

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity.

[hotemetoot]

This would be a great feature yes. Right now the Budibase DB offers attachments but no relationship filtering, which is a key feature in many scenarios. A SQL based database offers support for relationship filtering, but no attachments. Having both features in a single DB would be fantastic.

[jmlaurenti]

Hi, I totally agree with @hotemetoot and @daawaan : there are so many scenarios in real life where using an external SQL DB is mandatory, that having the ability to store attachments (invoice PDF for instance) is more than useful, especially as the S3 component does not currently work with embedded minIO...

Anything we can do to have this enhancement to be considered ? :-)

[lburtwistle]

Agree with @jmlaurenti @hotemetoot @daawaan. I have a client that wants to keep their data in SQL but also loves the idea of having the application itself hosted in the cloud. Attachment control for SQL is a must for me, so I can keep all their data within one approved data source.

[sergey-vin]

+1, Really need this feature. "S3 file upload" doesn't seem to work as a replacement of Attachments, and there's no other way to manage image galleries easily other by using attachments. But attachments are not available for external DBs.

[melohagan]

Closing as duplicate of: https://github.com/Budibase/budibase/issues/4302