NOTICE: PGSQL extensions required
Ensure to enable this: CREATE EXTENSION btree_gist;
Ensure to enable this: CREATE EXTENSION btree_gin;
These will allow us to create indices on varchar[] & date ranges
What we can do:
- create recurring event using RRule, multi-tenancy support
- update that event, including meta & period
- remove an event
- list events by tenant within a given time frame, including filtering by tags & hosts/participants
Roadmap
- subscribe to events
- unsubscribe from event
- send "notification" to subscribers when event changes
- support pagination by events or add max time frame to prevent extreme database load