Michael has some draft SQL. We need SQL for both the extension and the subscriber table.
See https://www.mediawiki.org/wiki/User:MHolloway_(WMF)/Drafts/Push_DB_Schema as a starting point.
Expected database queries per second, performance plan, and so on need to be considered.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | LGoto | T146032 Define and implement a common push notification architecture | |||
| Resolved | • Mholloway | T163116 Define persistence backends for Push Notification Service | |||
| Resolved | sbassett | T251190 Security Request For Service - Push Notifications | |||
| Resolved | • Mholloway | T262936 Enable app push notifications in production | |||
| Resolved | MSantos | T246716 DBA review for Echo push notification subscription tables | |||
| Resolved | • Gilles | T246707 Performance review of push notifications infrastructure | |||
| Resolved | sbassett | T246712 Security Readiness Review for push notifications infrastructure | |||
| Declined | None | T251442 Add PushNotifications extension to release branch cut | |||
| Declined | None | T251596 Document PushNotifications extension on mediawiki.org | |||
| Resolved | • Mholloway | T251437 Create MediaWiki extension for Push Notifications | |||
| Resolved | • Mholloway | T251431 Create .sql for Push Notifications tasks |