Create MySQL database programmatically

My application is a SaaS solution and we use separate databases for each tenant. What I would like to be able to do is create a database via the web application when a new user subscribes. This isn't currently possible using the MySQL CREATE DATABASE command, are there any plans for the Control Panel API support this?

 

MySQL CREATE DATABASE is typically disabled by default on a shared database server (even if there is no limitation on the number of databases you can use). I don't know of any plans for an API addition for MySQL. I can bring it up at our next planning meeting and see if it is a possibility. Generally speaking I think the preference is to keep those kinds of functions in Control Panel so we have an event log. But it's not out of the question.

 

I spoke to the developers and there is currently no plan to make MySQL database creation available via the API. There hasn't been any demand for it outside of this post, so the API work isn't really justified at this point. We can revisit the idea in the future if that demand changes.

 

Hi,
this feature could be nice for me as well. I'd like to create an umbraco multisite system. However, Umbraco needs a new database for each site. As I can get an unlimited number of mssql databases for 5$/month this could be a way forward but only if I can create the databases automatically. Optimally I'd like to use a mssql database for each umbraco instance e.g. in .sdf format as can be done on a localhost using visual studio.

Can this, or similar, be done within discountasp?

 

Not at this time.