Post by moon125 on Oct 31, 2024 9:36:28 GMT
Do you know where your website content is stored? You need to find a storage location for the information you post on your website. Content (including texts, images, downloadable files) is stored not just on the website, but in a specific location. I will explain without going into the technical details, but in a language you understand.
What is a website database?
A website database is a file or several files that contain data (e.g. media texts, links) displayed on the website pages.
The database can store:
texts of news, articles, comments, links;
names, email addresses and other information about users;
pictures, illustrations, gifs, animations.
The DB is applied to sites shopify website design that support dynamic content changes. That is, when, for example, news and articles are systematically published on the site, and user commenting is provided.
Using a database (hereinafter referred to as DB) allows you to reduce the speed of opening pages and increase the security of the site. It also allows you to add content through the site management system without contacting the developer.
Advantages of the website database:
Information is entered, stored and changed in the database when you fill out a site in the management system.
You can make backup copies, which ensures that the content can be returned if something happens to the site.
The information is recorded in the database and constantly changes (rewritten) depending on how the content on the site changes. To preserve the content, a backup copy is made. For corporate sites, forums, information portals, a backup copy of the database is made once or several times a day. For less active sites, once every couple of days.
In addition to content, the database stores:
list of applications from the site;
data on registered users;
links and site settings;
installed plugins and settings;
media materials;
and other information.
Without a stable connection between the site and the database, you cannot view the pages. The more content and plugins on the website, the greater the weight of the database. This directly affects the speed of loading the site in the browser.
site database in the site work chain
The weight of materials loaded onto the site directly affects the page loading speed. The heavier the database, the slower the pages open.
Recommendations on how not to make your website heavier
To prevent your website's database from growing too quickly, we recommend that you:
Place videos on the site using links to other sources, rather than uploading videos to the site.
Pictures should be published no heavier than 200kb and in jpg format.
Compress pdf file size using online converter.
It is better to convert the folder with files for downloading into the “.zip” format.
Below you will learn where the site content is stored on the site and how to verify that the content is stored in the database.
Where is the site content stored?
If you are not the developer of your site, it is impossible to determine externally whether the site has a database or not. When a site has a database, you have a password and login to enter the management system where the pages are filled. If there is no database, then you cannot enter the site management system.
Often, the content of a website is stored in a database. The content is saved in the database through the site management system when you fill out pages. Also, the content can be stored in the site layout, that is, in the code and does not get into the database.
The difference between storing content in a database and on a website
The content is stored in the website database in the form of structured tables. The website accesses the database, requests the material and displays it on the pages. The manager adds/changes/removes the content through the website management system.
In the site layout, content is stored as lines of code and is immediately displayed on the site. The difference is that the manager will not be able to add/change/delete content in the layout without the help of a technical specialist.
Below we will consider both options for storing content. And how to understand where the content of your site is stored.
Option 1: Content is stored in the site's database
How to understand that the content is saved in the database: when you enter the page through the site management system, you will see fields for filling in text and images.
How the site is filled:
Log in to the site management system.
In the menu, find the page you want to edit and click "edit".
The page opens with fields to fill in, where you change the text and pictures.
Make changes and publish.
Below in the screenshot I show what a page with fields to fill in looks like in the site management system.
The page can be edited
Option 2: content is stored in the layout
How to understand that the content is stored in the layout (in the page code): in the control system for the page there are no fields to fill. In this case, as a place to store the content, for example, html is used (file markup language for viewing web pages of the site in the browser. It is not a database).
Two ways to verify that content is stored in code
Method one, through the control system:
Log in to the site management system by entering your login and password.
In the site menu, find the page you need to edit and open it.
A blank page opens without the ability to edit texts or publish images. That is, without placeholders, as in the screenshot below.
What is a website database?
A website database is a file or several files that contain data (e.g. media texts, links) displayed on the website pages.
The database can store:
texts of news, articles, comments, links;
names, email addresses and other information about users;
pictures, illustrations, gifs, animations.
The DB is applied to sites shopify website design that support dynamic content changes. That is, when, for example, news and articles are systematically published on the site, and user commenting is provided.
Using a database (hereinafter referred to as DB) allows you to reduce the speed of opening pages and increase the security of the site. It also allows you to add content through the site management system without contacting the developer.
Advantages of the website database:
Information is entered, stored and changed in the database when you fill out a site in the management system.
You can make backup copies, which ensures that the content can be returned if something happens to the site.
The information is recorded in the database and constantly changes (rewritten) depending on how the content on the site changes. To preserve the content, a backup copy is made. For corporate sites, forums, information portals, a backup copy of the database is made once or several times a day. For less active sites, once every couple of days.
In addition to content, the database stores:
list of applications from the site;
data on registered users;
links and site settings;
installed plugins and settings;
media materials;
and other information.
Without a stable connection between the site and the database, you cannot view the pages. The more content and plugins on the website, the greater the weight of the database. This directly affects the speed of loading the site in the browser.
site database in the site work chain
The weight of materials loaded onto the site directly affects the page loading speed. The heavier the database, the slower the pages open.
Recommendations on how not to make your website heavier
To prevent your website's database from growing too quickly, we recommend that you:
Place videos on the site using links to other sources, rather than uploading videos to the site.
Pictures should be published no heavier than 200kb and in jpg format.
Compress pdf file size using online converter.
It is better to convert the folder with files for downloading into the “.zip” format.
Below you will learn where the site content is stored on the site and how to verify that the content is stored in the database.
Where is the site content stored?
If you are not the developer of your site, it is impossible to determine externally whether the site has a database or not. When a site has a database, you have a password and login to enter the management system where the pages are filled. If there is no database, then you cannot enter the site management system.
Often, the content of a website is stored in a database. The content is saved in the database through the site management system when you fill out pages. Also, the content can be stored in the site layout, that is, in the code and does not get into the database.
The difference between storing content in a database and on a website
The content is stored in the website database in the form of structured tables. The website accesses the database, requests the material and displays it on the pages. The manager adds/changes/removes the content through the website management system.
In the site layout, content is stored as lines of code and is immediately displayed on the site. The difference is that the manager will not be able to add/change/delete content in the layout without the help of a technical specialist.
Below we will consider both options for storing content. And how to understand where the content of your site is stored.
Option 1: Content is stored in the site's database
How to understand that the content is saved in the database: when you enter the page through the site management system, you will see fields for filling in text and images.
How the site is filled:
Log in to the site management system.
In the menu, find the page you want to edit and click "edit".
The page opens with fields to fill in, where you change the text and pictures.
Make changes and publish.
Below in the screenshot I show what a page with fields to fill in looks like in the site management system.
The page can be edited
Option 2: content is stored in the layout
How to understand that the content is stored in the layout (in the page code): in the control system for the page there are no fields to fill. In this case, as a place to store the content, for example, html is used (file markup language for viewing web pages of the site in the browser. It is not a database).
Two ways to verify that content is stored in code
Method one, through the control system:
Log in to the site management system by entering your login and password.
In the site menu, find the page you need to edit and open it.
A blank page opens without the ability to edit texts or publish images. That is, without placeholders, as in the screenshot below.