Open VSX currently only supports one database connection pool, which means all queries are routed to it. At high traffic, operators must employ middleware to achieve horizontal scalability. This adds operational complexity and overhead.

Like most sites, the large majority of DB traffic is SELECT statements, which if isolated, can be scaled across a cluster of replicated databases.

Proposal
Add support for read/write splitting (separate connection pools for primary and replicas) so Open VSX can natively route queries. This would reduce reliance on external middleware and improve scalability for large deployments.