Hi everyone,

I’m building a real-time application using Next.js, and I need to implement a feature where users receive notifications (e.g., updates or messages) in real-time. The notification content is stored in a table in my database.

I’m using Neon (Postgres) as my database, but so far, I haven’t found a good solution for implementing this feature with it.

Is there a recommended approach or best practice for achieving real-time notifications in this setup? Ideally, I’d like to notify users immediately when a new record is inserted or updated in the database.

Any help, examples, or suggestions would be greatly appreciated. Thank you!