dynamic database name | Appsmith | Page 1

spice dagger Oct 12, 2022, 11:39 PM

#

When creating a datasource I have several dupes of the same schema for different customers I want to be able to have a control where you select the customer (drop down or something) and the datasource changes to use a different connection. everything is the same between them other then the connection info. The only way I can figure to do this now is to clone the apps and edit the datasources but as the number of customers grows and updates to the apps occurs that could be a large and daunting task

narrow prismBOT Oct 13, 2022, 4:34 AM

#

Hi! What datasource are you using?

spice dagger Oct 13, 2022, 2:52 PM

#

MySQL

spice dagger Oct 13, 2022, 3:38 PM

#

was able to get this to work by creating a JS function that returned the name of the schema. That function can be updated and use the store context (storeValue etc). we can then use that in our queries {{getSchemaName()}}.TableName

narrow prismBOT Oct 13, 2022, 3:52 PM

#

Ok, I am glad the issue is fixed. Thank you for sharing this solution.

narrow prismBOT Oct 14, 2022, 7:11 AM

#

Could you also share the piece of code you have used in your JS function for
reference for our community?

low creek Nov 30, 2022, 4:21 PM

#

We have the same use-case, that we need a variable database host for MySQL. Our DB basically exists with the same tables multiple times. The best would be if we could override it per query.

narrow prismBOT Nov 30, 2022, 6:13 PM

#

Are you saying that instead of separate tables, you're using separate databases?

low creek Nov 30, 2022, 7:46 PM

#

Yes, because we deploy our app to multiple instances and our app has always the same tables, but the instances are hosted even in different regions.

narrow prismBOT Nov 30, 2022, 7:51 PM

#

Do you think the solution to this issue could be applied to your use case?

https://github.com/appsmithorg/appsmith/issues/2836

GitHub

[Feature] Multiple Environments · Issue #2836 · appsmithorg/appsmith

Summary Applications need to hit different API URLs with varying parameters when run during production and when run as staging. A way globally configure the correct parameters within the applicatio...

low creek Nov 30, 2022, 9:55 PM

#

Yes, but it would be way harder for you guys to implement this. For my case just a simple "Override DB Host" input field on Queries like in Retool would completely suffice. And the sooner Appsmith has it, the sooner our company can start to pay you guys. :-)
Right now not being able to dynamically address different databases with the same queries is a complete showstopper/dealbreaker.
Example from Retool:

narrow prismBOT Nov 30, 2022, 9:59 PM

#

I agree, but I believe that issue is already in our pipeline :) I don't have a
timeline for this, but if you comment your use case on that issue they will take
it into account when building the feature.

#dynamic database name