How would you store roles with up to 64 permissions?

• CanCanCan

  19 5,508 2.2 Ruby

  The authorization Gem for Ruby on Rails.

  

Would you do : 1. a roles table with the name of the role and 64 booleans? 2. A roles table with one JSON field? (using rails json data type) 3. A roles table and a permissions table, similar do what is suggested in the cancancan developpers guide:

• activerecord-typedstore

  2 435 3.8 Ruby

  ActiveRecord::Store but with type definition

I guess it depends on how frequently the roles or flags change, but we use https://github.com/byroot/activerecord-typedstore and a jsonb field. We add flags as needed and cache them, but also things like role limits, without the need for db migrations or a hefty load of columns.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project