rodwatkins

rodwatkins

Hello,

I am looking for some advice about setting up notifications through channels. Here is what I am designing.
I have a private web site where users work closely together. So I wanted a way to send notifications of (model) changes to all users currently online. Notifications will be saved to the database (as part of a completely audited system).

Here is how I want it to behave. When a user is logged in, they receive notifications whenever a model is changed. As described in the channels chapter in “Programming Phoenix”, I planned to store a last_seen_id so that users can receive only the notifications they missed while disconnected. But I want that last_seen_id to be stored somewhere and not be lost when the user closes their browser or uses a different browser. So the best answer seems to be storing that id in the database.

Thus, when a message is sent successfully, the browser could send a message back with the new last_seen_id and then the server persists that to the database. Then when the client reconnects, the last_seen_id can be retrieved from the channel if it exists or look it up in the db if not.

Does that design makes sense? Or is there a better way.
Cheers
Rod

Showing Posts 1 to 9

OvermindDL1

OvermindDL1

That is precisely what I am doing. The client just sends a ‘seen’ message to the notification channels (I have multiple for different notification types) to indicate that it has seen up to ‘now’.

david

david

Would you mind elaborating on how you structured your notification relationships?

I’m trying to accomplish something similar, Multiple Polymorphic Associations in Ecto, and would be curious how you tracked your model changes in the db.

Thanks!

OvermindDL1

OvermindDL1

In what way? The notifications via broadcasting? The database itself? The helpers that tie them together?

david

david

Hi there!

I was predominantly meaning in the database itself and/or the helpers.

My biggest challenge was:
How do you structure your tables to track the model changes?

  1. A separate notification table for each model) ie model_a_notifications, model_b_notifications.
  2. A many-to-many association with a generalized notification?

Thanks

OvermindDL1

OvermindDL1

I just did it very simple, a table of just ‘topics’, ‘users’, and 'datetime’s as I recall (do not have it in front of me at moment).

josevalim

josevalim

Creator of Elixir

For the notifications case, you can also put all the relevant information in a map, including the user_id, post_id and everything else you may want to show the user. When doing a notification system, it is often best to have all the data you need in a single lookup instead of traversing multiple tables after the information you want. However, do include the source data in case you need to reconstruct the notifications later on.

david

david

Thanks for the advice José! :smile:

rodwatkins

rodwatkins OP

Good idea. That will simplify the approach In was taking. Thanks

OvermindDL1

OvermindDL1

That’s what I do via a PostgreSQL JSONB (Ecto :map) type for my generic notification store. :slight_smile:

— All posts loaded —

Where Next? Top

Trending in Discussions Top

AstonJ
The obligatory hello world thread! Who are you and where are you from? :stuck_out_tongue:
4663 61218 595
New
cblavier
Hey there, It’s been more than a year since we started using LiveView as our main UI library and building a whole library of UI componen...
515 12931 101
New
raa-ziq
Hi everyone :waving_hand: I wanted to share something I’ve been building — NowBlind, a random chat app designed to help people discover ...
New
sntran
In my third year of college, around 2010, I found Erlang. A few years later, I found Elixir. I liked the ideas at once: many small proces...
New
gtcode
I’ve been tinkering with Lynx (by José) via hold_ledger. I used AI to write the code, a separate specification, the tests, and the Lean p...
New
AstonJ
A remark @Garrison made… ..has already inspired a thread for the technical side of reclaiming our internet, but there is of course anot...
New
ManuelGarcia
Hi everyone! I’m the developer of PaperForge, and I’ve been working on something alongside it that I’d like your opinion on. I’m conside...
New

Other Trending Topics Top

dominicletz
Hey there, I haven’t seen a list of useful Elixir specific skills for the popular AI tools yet so I’m starting one here with my first. ...
New
mudasobwa
I fully migrated to my own harness from Anthropic/Gemini and I think it’s time to share it. Welcome DSH, the DeepSeek Harness, fully writ...
New
OndrejValenta
(I just needed to vent somewhere and LinkedIn is full of hope, or hype, I’m not sure which exactly) AI dream has many faces, but general...
New
kip
Localize is the next generation localisation library for Elixir. Think of it as ex_cldr version 3.0. The first version will be released ...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New
mcass19
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews