Enhancing Interactivity with Realtime Comments

In the last chapter, you learned how to conquer remote procedure calls (RPCs) and edit row data, and gave your application a first touch of post-ticket-creation interactivity by allowing the user the ability to change assignees.

But what if your application could become more dynamic, interactive, and in tune with the real-time web? Imagine a scenario where updates happen live, without the need to hit the refresh button. This isn’t just a convenience – it’s becoming an expectation in modern web applications.

Welcome to Chapter 10, where we leap into the integration of the Realtime service of Supabase. Along this path, you’ll be designing a comments table that automates more values than any other table we’ve created so far, and learn yet another method to optimize RLS by using custom functions.

After having implemented the creation and view of comment data, you’ll also learn how to complement...