Which option do you prefer to go with (considering scalability, and a limited budget):
Technologies in use:
Angular / .NET Core 6
What do we want to achieve?
We want to create simple near-time web notifications, those notifications can be categorized into 2 sections:
-
User notification: which represents user activities and engagements.
-
System notification e.g release notes and maintenance time.
The notification object is too simple just a title, body, userId, notificationStatus, and readAt.
notification status is an enum with 3 values: unread, menuOpened, Read.
Options:
-
use Firebase Realtime Database for user notifications and Microsoft SQL Server for system notifications (maybe using long poling or so to frequently call the getSystemNotification API ).
-
use SignalR to push new notifications along with the SqlServer database and store both user and system into one table (as they almost have the same attributes)
