This looks like an awesome library and is exactly what I need. I do have some questions:
-
Does anyone have actual production experience with using separate schemas in PostgresQL for multi-tenancy in a SaaS application (either using Triplex or not)? Have you found that this approach scales well or not eg. for thousands or tens of thousands of tenants or more? (Both in terms of performance and ease of maintenance.)
-
Triplex looks like it will neatly solve the multi-tenancy part of the problem. However, what about sharding to multiple PostgresQL physical server instances to distribute load? How would one go about that together with using Triplex?
!
