search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
34.64k stars 3.74k forks source link

[Feature] Realtime updates support in Firestore integration #3258

Open sharat87 opened 3 years ago

sharat87 commented 3 years ago

One of the major strengths of using Firestore as the data store for applications is it's realtime sync capabilities. Having first-class support for this in Appsmith would make the Firestore integration a lot more useful.

Nikhil-Nandagopal commented 3 years ago

Duplicate of #1647

sharat87 commented 3 years ago

This is not a duplicate. The issue #1647 is about adding support for Firebase's Realtime DB, which is a database offering different from Firestore.

This issue is about Appsmith supporting the realtime updating capability of Firestore itself.

harisbal commented 1 year ago

At the moment, attempting to keep an appsmith application in-sync with the database requires a setInterval mechanism to be implemented link.

Firestore exposes functions which can allow the capturing of changes in the db in real-time.

Although, I understand that this is very specific to Firestore request, it would be extremely useful to enable real-time updates without constatnly polling the database. For Firestore in particular, polling the database can prove a rather costly operation since queries are billed based on the number of queries executed by database.

Nikhil-Nandagopal commented 1 year ago

Thanks for the context @harisbal. cc: @sbalaji1192 @rohan-arthur

tazmaniax commented 1 year ago

I realise not directly related to Firestore, but something similar for Supabase database real-time updates would be nice too! Could there be a unified approach that works for all of these providers of real-time database updates?