search

NXdriveBeta / container-workers

0 stars 0 forks source link

Implement workers to write to group database #5

Open NXdriveBeta opened 5 years ago

NXdriveBeta commented 5 years ago

Having UserGroup, UserGroupActivity, UserGroupMember, UserGroupInvitation tables in SystemBase is not enough. Especially when it grows bigger and all groups has to share a single table.

Suggest adding another database called UserGroups. It stores all groups information (each group has several tables), including group invitations, group members, group files, group activities.

NXdriveBeta commented 5 years ago

Discussion: some operations shall be synchronized(make immediate change) like member management, group description, etc. Some are not time-sensitive, like group activities. For those that are not time-sensitive, we can implement workers to write into that additional database.

NXdriveBeta commented 5 years ago

Group index database shall have group-file-system-activities table, group-files table. This will help speed up finding all files from a group, or finding all activities that happened in a group.