rideshare icon indicating copy to clipboard operation
rideshare copied to clipboard

Talk: SaaS on Rails on PostgreSQL

Open andyatkinson opened this issue 1 year ago • 1 comments

This PR has code samples and examples from the Posette Conf talk "Saas on Rails on PostgreSQL"

https://www.citusdata.com/posette/speakers/andrew-atkinson/

Some of the tech examples:

  • Row Level Security
  • Composite primary keys
  • Active Record Horizontal Sharding
  • Citus, row-based and schema-based sharding

andyatkinson avatar May 20 '24 20:05 andyatkinson

you should checkout PgRLS it probably solve this by just creating a RLS table and passing the tenant, but i would never recommend adding a RLS implementation for CACHE, just an extra layer of logic, i would recommend using DB sharding for cache

Dandush03 avatar Aug 25 '25 14:08 Dandush03