[Dbix-class] Multi-tennant application/data and dbix-class

Thomas Sibley trsibley at uw.edu
Wed Jan 3 21:19:24 GMT 2018


Which RDBMS?  If Pg, I’d suggest using row-level ACLs directly in the database rather than pushing the ACL logic into the ORM/app code.


> On Jan 3, 2018, at 12:37 , Aaron Trevena <aaron.trevena at gmail.com> wrote:
> 
> Hi All,
> 
> I was wondering if anyone can share any success, tips and problems of
> using dbix-class in a multi-tenant application.
> 
> I'm looking at using tenant id in the main tables, and thinking best
> approach will be to add logic to a resultset base class or role to
> hook in forcing queries to restrict by tenant id, but would really
> like to hear what anybody who's done this stuff already did and what
> worked or not and any gotchas,
> 
> Thanks,
> 
> A.
> 
> -- 
> Aaron J Trevena, BSc Hons
> http://www.aarontrevena.co.uk
> LAMP System Integration, Development and Consulting
> 
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk




More information about the DBIx-Class mailing list