[BUDI-7704] JSON Support - Postgres/MySQL

[shogunpurple]

Depends on https://github.com/Budibase/budibase/issues/3381

When I'm working with a plus datasource that has support for a JSON field, I want to be able to leverage the JSON types available in that database inside budibase, so that I can perform JSON specific CRUD operations against that database without performing any additional processing in JS/Handlebars.

COS

• Account for the JSON type in postgres and mysql data source plus type generation
• Account for JSON type in custom datasources for mysql and postgres
• Ensure that the same UX that occurs for https://github.com/Budibase/budibase/issues/3381 is used for these SQL sources. Note - we will still need to generate a schema from these fields, until we have entirely dynamic JSON support later on

_BUDI-7704

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[chaoticefx]

Hi! Could I check in to see if this is still in the roadmap or if it's been done but I'm not seeing it somewhere? I see above that it was added to "November 21" in "Roadmap 2022" but I don't see it in "Roadmap 2022". I just started a POC for my company and am really loving Budibase so far, being able to natively interact with the JSON in PG/MySQL would be a great addition!

[aderici]

If you don't support this, how can one implement multi file uploads into s3 and save those into a record in mysql? also can you add a native attachment field type so that attachments (saved into s3 or somewhere else) can be nicely previewed in table list view? Like the internal db attachments,

[stale[bot]]

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

[andz-bb]

we'll discuss this with engineers in bug grooming on the 1st

[Athik321]

i am using mysql datasource now in a table i want to add attachment in field type column how can i do it

[ConorWebb96]

@Athik321,

You might want to look into custom plugins there is a plugin that allows you to attach attachments to rows within Budibase for external datasources.

[Athik321]

When I upload an image using the Budibase File Upload plugin and the data gets stored in your MySQL table as a long text (base64 encoded string), it takes up a lot of space. To handle this efficiently, what can i do ?

[ConorWebb96]

@Athik321,

Thats just the way the plugin works. Feel free to ask on the plugin's Github repository if you have any questions related to the plugin.

[Athik321]

The data being stored is very long; can I shorten it? And where was the uploaded image stored?