Hi all, I am getting very mixed information from the Umbraco docs (and the project template) when it comes to which cache mode to use for SQLite. - https://docs.umbraco.com/umbraco-cms/reference/configuration/connectionstringssettings > Mentions that

Private

mode should be used, and

Shared

is discouraged / deprecated. - https://docs.umbraco.com/umbraco-cms/fundamentals/setup/install/unattended-install#sqlite-example-in-appsettings.json > Mentions that the recommended value is

Shared

. - https://github.com/umbraco/Umbraco-CMS/blob/contrib/templates/UmbracoProject/.template.config/template.json#L147 > The Umbraco Project template is set to use

Shared

. Anyone knows what is the main difference between the two? And what would be recommended? I would guess

Private

, from the information in the first link, but again everywhere else in the docs it mentions

Shared

. 😅 Thanks!

I would recommend creating an isssue for the docs team please! I am not sure myself and it's something we should get the CMS team to advise on properly 🙂

My colleague ended up creating a PR for both the docs and the core (https://github.com/umbraco/Umbraco-CMS/pull/16627) - to adjust every reference from

Shared

to

Private

. Funnily enough (or not) changing all of the connection strings to use

Private

made all the integration tests fail 🫣

MS Docs say to avoid cache=shared if you are using write-ahead logging. https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/connection-strings#basic https://cdn.discordapp.com/attachments/1252963492546351107/1253274218607677533/image.png?ex=66754212&is=6673f092&hm=434071bc45c4da74b289e8a73b041e2896373206ccf18ab730c2faccb5aa5dc8&