Database Configuration with PostgreSQL and Redis Integration for Caching

[kossvat]

Description:

This task focuses on setting up PostgreSQL as the primary database for the Django application and integrating Redis to enhance performance through caching. The objective is to ensure efficient data storage and retrieval, alongside optimizing response times for frequently accessed data.

Acceptance Criteria:

1. PostgreSQL Configuration:

• Django is configured to connect to a PostgreSQL database.
• Connection strings and credentials are managed via environment variables or a secure configuration management system to ensure security.
• The database schema is optimized for the application's data access patterns, considering indexes, data types, and constraints.

2. Redis Integration:

• Redis is integrated into the Django application as a caching backend.

• Define a caching strategy that identifies which data to cache. Potential candidates include:

  • User session data to reduce database queries for user authentication.
  • Frequently accessed threads and replies to decrease load times for popular content.

[VitalikMatvieiev]

here should be described the algorithm and the data you will store in redis, and also here should be requirements for redis

[VitalikMatvieiev]

for DB you should use Postgres