I am new to OpenCms. My Question is, if I create a template in OpenCms VFS (virtual file system) as a
Yes, the content is stored in the database, blobs (binary large objects) are stored in
CMD_OFFLINE_CONTENTS. The other tables are for metadata (i.e.
Difference between the OFFLINE and ONLINE/regular tables are for the mode: the term
OFFLINE in context of OpenCms refers to the unpublished (authoring) sites, while
ONLINE is the published site.
Actual content is stored in the tables mentioned under (1), while meta data is stored elsewhere.
Note that it is possible to configure OpenCms in a way that it exports certain file types as static content to the RFS (real file system), in order to deliver faster. But in any case, it's primarily stored in the database.