Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Push based continuous queries #895

Closed
sirinath opened this issue Jun 24, 2021 · 6 comments
Closed

Push based continuous queries #895

sirinath opened this issue Jun 24, 2021 · 6 comments
Labels
C-feature Category: feature

Comments

@sirinath
Copy link

Generally database queries and pull based where the database would poll to see any updates. For ultra low latency high throughput real time applications this is in efficient. Ideally we should have push based continuous queries. Here when data changes the changes are notified to application.
@sirinath sirinath added the C-feature Category: feature label Jun 24, 2021
@sirinath sirinath mentioned this issue Jun 24, 2021
Closed
2 tasks
@jovany-wang
Copy link

Looks interesting! It'd be great if you can share more docs or more details to help us understand it. :)

@sirinath
Copy link
Author

This concept is taken from https://rethinkdb.com/. It is descried in https://rethinkdb.com/blog/realtime-web/.

@sundy-li
Copy link
Member

Sounds like noria, https://www.youtube.com/watch?v=s19G6n0UjsM&t=1934s

@sirinath
Copy link
Author

sirinath commented Jun 24, 2021 •
edited
Loading

Yes. Noria looks similar.

@ChenpiDog
Copy link

Real-time Data Warehouse and real-time ETL can be realized only with SQL. Some commercial data warehouse products have launched this function, such as Alibaba Cloud AnalyticDB PostgreSQL and Alibaba Cloud Hologres. You can refer to the real-time materialized views of these two products.
Alibaba Cloud AnalyticDB PostgreSQL: https://help.aliyun.com/document_detail/253369.html

@ChenpiDog
Copy link

Databend沟通 drawio

@ChenpiDog ChenpiDog mentioned this issue Oct 4, 2022
Closed
4 tasks
@databendlabs databendlabs locked and limited conversation to collaborators Oct 27, 2022
@Xuanwo Xuanwo converted this issue into discussion #8504 Oct 27, 2022

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

Assignees
No one assigned
Labels
C-feature Category: feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@sirinath @sundy-li @jovany-wang @ChenpiDog