If I open a Sitecore content item in Sitecore Page Editor, does it run on the master database or on web database?
Answers here are a good start but the database the page/experience editor is using is configurable in the
<site name="shell"> node of this website.
On Sitecore 8.0 and older, in your web.config file. On Sitecore 8.1+, in the
The default configuration is:
<site name="shell" virtualFolder="/sitecore/shell" physicalFolder="/sitecore/shell" rootPath="/sitecore/content" startItem="/home" language="en" database="core" domain="sitecore" loginPage="/sitecore/login" content="master" contentStartItem="/Home" enableWorkflow="true" enableTracking="false" analyticsDefinitions="content" xmlControlPage="/sitecore/shell/default.aspx" browserTitle="Sitecore" htmlCacheSize="10MB" registryCacheSize="15MB" viewStateCacheSize="1MB" xslCacheSize="25MB" disableBrowserCaching="true" />
In this configuration we see that the default database used by the Sitecore admin tools (shell) is the master database due to the
Well it depends on which database you are working on. Default a content editor opens an experience editor and page editor on the master database. From there the changes will be saved and published towards the web database.
Working directly on the CD web database is not recommended as your change will be overwritten on the next publish action.
While Dan's suggestion is true for single instance Sitecore installations, the answer is not so straight forward in a distributed environment (i.e. separate CM and CD servers).
When configuring a CD environment, Sitecore recommends removing all references to the master database (using the SwitchMasterToWeb config patch), allowing the application only to access the web database.
If you have not removed/restricted access to the Sitecore client on the CD server your editors will be able to open the Experience Editor, and thus work on the web database.