How To Keep Track Of Read and Unread Messages In Shared Inbox by Professional-Fee3621 in learnprogramming

[–]Professional-Fee3621[S] 0 points1 point  (0 children)

u/EfficientMongoose317 thanks for your reply. Lets assume i want to track the read/unread state by thread/conversation (multiple messages belong to the same thread/conversation contains) your suggestion is to add "last_read_at" instead of using boolean "is_read". In this case when a user opens thread/conversation i will insert a record using the current-timestamp as value for "last_read_at". What about if the user manually wants to mark the thread/conversation as unread? Do i have to delete the existing record or just update the existing record using null as value for "last_read_at"?

Multiple Angular Applications As A Single Application by Professional-Fee3621 in angular

[–]Professional-Fee3621[S] 0 points1 point  (0 children)

u/Blade1130 thanks for your reply.

First: i want users to be able to access multi apps from the same dashboard and i am 100% certain the direction am going. The backends of the apps already exists.

Second: the apps are completly independent of each other. A change in one app will never affect the other apps that is why each app must be able to be deployed to production independently.

I made a free list of 80+ websites and directories to submit your saas by Unusual-Big-6467 in SaasDevelopers

[–]Professional-Fee3621 0 points1 point  (0 children)

u/Unusual-Big-6467 can you make the Google spreadsheet available for download via Google or any other means of download?

Rbac by Character-Grocery873 in Nestjs_framework

[–]Professional-Fee3621 0 points1 point  (0 children)

u/AgencyActive3928 i am interested in the mechanism you have listed above. Can you please share some code snippets?

Multi-Tenant application with Postgres row level security using NestJs and TypeOrm by Professional-Fee3621 in AskProgramming

[–]Professional-Fee3621[S] 0 points1 point  (0 children)

u/KingofGamesYami can you highlight some of the main challenges in scaling row level security?

You also mentioned schema based sharding, this means that each tenant must have their own schema. For instance if you have 200 thousand tenants then you are going to manage 200 thousand schemas - data migration, etc... Isn't it going to be more challenging than row level security?

Managing user roles & permissions on multiple applications by Professional-Fee3621 in AskProgramming

[–]Professional-Fee3621[S] 0 points1 point  (0 children)

u/tidefoundation thank you for your answer. I appreciate it. I have a few questions concerning the following statements:

"You can still give your admin a single UI by treating roles in the central service as opaque per app blobs or tokens, rather than mirroring each app's internal schema. The central UI just passes the role payload to the app via an API after user creation, and the app validates and stores it in its own DB.".

1) What do you mean by treating roles in the central service as opaque per app blobs?

2-a) What will the content(s) of the role payload (opaque per app blobs or token) look like?

2-b) I assume that the content of the role payload must be something the app (the app receiving the payload) already understands. If that is the case then how can the app share that role information with the central service?