Where to put SQLite database file in Azure App Service?
<p><strong>Q1</strong>: Where do you think is the right place to put a <strong>SQLite</strong> database file (<code>database.sqlite</code>) in <strong>Azure Web App</strong> file system? For example:</p>
<ol>
<li><code>D:\home\data\database.sqlite</code></li>
<li><code>D:\home\site\database.sqlite</code></li>
<li><code>D:\home\site\wwwroot\database.sqlite</code></li>
<li>other?</li>
</ol>
<p><strong>Q2</strong>: What else should be taken into consideration in order to make sure that the database file won't be accessible to public users as well as not being accidentally overwritten during deployments or when the app is scaled up/down? (The Web App is configured for deployments from a Local Git Repository)</p>
<p><strong>Q3</strong>: Where to learn more about the file system used in Azure App Service, the official source URL? E.g. how it's shared between multiple VMs within a single Web App, how does it work when the App is scaled up/down, what's the difference between <code>D:\home</code> (persistent) vs <code>D:\local</code> (non-persistent)...</p>
<p>Note that <strong>SQLite</strong> does not work in <strong>Azure Blob Storage</strong>, so that one is not an option. Please, don't suggest alternative storage solutions, this question is specifically about <strong>SQLite</strong>.</p>
<h3>References</h3>
<ul>
<li><a href="https://www.sqlite.org/whentouse.html" rel="noreferrer">Appropriate Uses For SQLite</a></li>
</ul>