PostgreSQL

Overview

Although less extensively used than MongoDB, PostgreSQL, a powerful and reliable relational database management system (RDBMS), remains crucial to the UserWise system's operation. PostgreSQL is particularly well-suited for managing structured data and executing complex queries, making it indispensable for specific areas within UserWise.

PostgreSQL powers:

User accounts and authentication
Administrative dashboard access and controls
Management of apps and environments
Definition and storage of attribute structures
Media uploads

Resource Requirements

PostgreSQL instances for UserWise can often be configured with minimal resource allocation.

Monitoring and Maintenance

PostgreSQL can be monitored easily by setting up Monitoring (Prometheus & Grafana)

While PostgreSQL usage is lower than that of MongoDB, it's crucial to proactively monitor your instance and set up appropriate alerts to ensure that its capacity isn't reached. Reaching capacity can lead to service disruptions and downtime.

Consider implementing alerts to notify you when usage approaches critical thresholds. This proactive approach will allow you to take necessary actions, such as scaling Redis resources, to prevent potential issues.