DEV Community

Discussion on: PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

Collapse
 
rish_0_0 profile image
Rishabh Anand

Why not create a REST API with a rate limit of say: 1 request every 10 minutes, and make something call the REST API periodically.

Collapse
 
patarapolw profile image
Pacharapol Withayasakpunt

I still don't know the answer, other than that PostgreSQL driver also support listening for changes.

About set interval, it is not really real time, and it can be quite heavy if the traffic is low; and too light, if the traffic is high.