Azure File Storage

[JoshTango]

I would like to use Orchard Core as a mult-tennant application and I want to save SQLite files to drive for each tennant. I would prefer Orchard Core save these and access them in Azure File Storage. That way if I use the docker container the container does not fill up with all the database files. The same if I use a VM. Does Orchard Core support this ability and if so is there guidance or documentation somewhere? Also I noticed you published a docker container recently. Will there be a way to configure that container to save the database files externally such as with Axure File Storage?

[carlwoodhouse]

In terms fo your db; In azure docker containers you can mount a storage fileshare at any given path (https://docs.microsoft.com/en-us/azure/app-service/containers/how-to-serve-content-from-azure-storage) , it's possible to set the path of appdata in your container using ORCHARD_APP_DATA env variable.

If that helps ...

that been said id seriously consider the limitations of sqllite and look at sql azure instead ..

[JoshTango]

Well what if I expect thousands of people to sign up and create a 1000 little SQLite databases files? Orchard core can spawn multiple threads and talk to several SQLite files in parallel can it not? And with caching turned on why should I care about the limitations of SQLite?

[carlwoodhouse]

For sure :) just a suggestion; i might be worried about the concurrent write limitations of those tenants if the users of them are out of your control! but by all means it would work :)

…

On Tue, 1 Oct 2019 at 14:51, JoshTango ***@***.***> wrote: Well what if I expect thousands of people to sign up and create a 1000 little SQLite databases files? Orchard core can spawn multiple threads and talk to several SQLite files in parallel can it not? And with caching turned on why should I care about the limitations of SQLite? — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#4431?email_source=notifications&email_token=AADRUEFDS7RKPWQLSJFWHUTQMNIW5A5CNFSM4I3N7HF2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEABKX4A#issuecomment-537046000>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AADRUEBWZRKHTNC6SR7VJC3QMNIW5ANCNFSM4I3N7HFQ> .

[JoshTango]

The link you provided was helpful

[JoshTango]

@carlwoodhouse If I were to get a managed sql instance I could then create thousands of tenants databases inside of that yes? that's what you mean? the prices seems very expensive to start? probably cheaper to start with a single database and use prefixes on the table names

[carlwoodhouse]

Yup :) plus you get all the benefits of sql azure; automated backup; etc

…

On Tue, 8 Oct 2019 at 16:44, JoshTango ***@***.***> wrote: If I were to get a managed sql instance I could then create thousands of tenants databases inside of that yes? that's what you mean? The cost is not much more than File Storage it seems. — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#4431?email_source=notifications&email_token=AADRUEGQ7UWMK36BNHSKHO3QNSTEXA5CNFSM4I3N7HF2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEAUUKMY#issuecomment-539575603>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AADRUEGTASDYYWBNECA4KK3QNSTEXANCNFSM4I3N7HFQ> .

[Piedone]

For those stumbling on this now: currently, you can store Media files in Blob Storage (see https://docs.orchardcore.net/en/latest/reference/modules/Media.Azure/) and even the whole App_Data elsewhere, like on an Azure Files file share: https://docs.orchardcore.net/en/latest/reference/core/Configuration/#orchard_app_data-environment-variable.