Using enums for permission

[berkinanik]

In permission model, action:entity:access fields are string and I know sqlite does not support enums. btw current implementation is nice imo for both typescript support and intellisense.

epic-stack/app/utils/permissions.ts

Lines 62 to 66 in 4fd50cd

	type Action = 'create' | 'read' | 'update' | 'delete'
	type Entity = 'user' | 'note'
	type Access = 'own' | 'any' | 'own,any' | 'any,own'
	type PermissionString = `${Action}:${Entity}` | `${Action}:${Entity}:${Access}`
	function parsePermissionString(permissionString: PermissionString) {

I was just wondering if we could benefit from enums for these fields with postgres etc. And how would the permission parsing be implemented that way.

// File: schema.prisma
enum Action {
  CREATE
  READ
  // ..
}

PS: I was first thinking if there was a way to create Access type dynamically, if access types start to grow for example.

epic-stack/app/utils/permissions.ts

Line 64 in 4fd50cd

type Access = 'own' | 'any' | 'own,any' | 'any,own'

Like:

type Access = AllPossibleUniqueStringCombinations<'own' | 'team' | 'invited' | 'any'>
// would infer all possible string combinations

But ended up thinking about why those weren't enums in the schema earlier

[sergiodxa]

EpicStack uses SQLite, not PostgreSQL, and AFAIK SQLite doesn't support DB-level enums, so the only option is to have them in the code and not the schema.