At Avni, we use the RLS feature of Postgres to handle multitenancy. This is an experience report of the design decisions that we took along the way, the impact of these decisions and the intricacies of Postgres that we learnt the hard way.

The focus will be on some high level design where we talk about entire application design, and then dig deeper into database design.