Database
========

Configuring the database for Django Sage Blog involves setting up your database in the Django settings file. This section will guide you through configuring SQLite and PostgreSQL.

SQLite Configuration
--------------------

SQLite is the default database engine used by Django for development purposes. It is lightweight and easy to set up. To configure SQLite, add the following settings to your `settings.py` file:

.. note::

    SQLite is perfect for development and small-scale applications due to its simplicity and zero-configuration setup.

PostgreSQL Configuration
------------------------

PostgreSQL is a powerful, open-source relational database that offers advanced features and performance benefits. Using PostgreSQL with Django Sage Blog is recommended for better search capabilities and scalability. To configure PostgreSQL, add the appropriate settings to your `settings.py` file.

.. important::

    PostgreSQL provides enhanced search features through built-in extensions such as `pg_trgm`. This extension significantly improves search functionality in Django Sage Blog.

Other Databases
---------------

Django Sage Blog supports other databases as well. If you prefer to use MySQL, Oracle, or any other supported database, you can configure them similarly by setting the appropriate `ENGINE` and connection details in the `DATABASES` setting.

.. warning::

    While other databases are supported, PostgreSQL is highly recommended for its superior search capabilities and overall performance benefits.

Checking Database Configuration
-------------------------------

Before running your application, it's a good practice to check the database configuration. Django provides a management command to validate your setup:

.. tip::

    Use the command `python manage.py check` to check the entire Django project for potential issues, including database configuration.

Running the Server
------------------

When you run the Django development server using the command to start the server, Django Sage Blog will perform a series of checks to ensure that the database is properly configured. This includes verifying the presence of necessary extensions if PostgreSQL is used.

.. important::

    If PostgreSQL is detected, Django Sage Blog checks for the presence of the `pg_trgm` extension. If the extension is missing, an error will be raised with a hint to install the extension by running the appropriate SQL command in your PostgreSQL database.

.. note::

    If any operational errors occur during this check, they will be reported to ensure that you are aware of any issues that might prevent the application from running smoothly.

.. warning::

    If the database engine is not PostgreSQL, a warning will be issued to inform you about the benefits of using PostgreSQL, though it indicates that PostgreSQL is not mandatory.

By following these steps, you can ensure that your database is properly configured and optimized for the best performance with Django Sage Blog.