search

risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.
https://go.risingwave.com/slack
Apache License 2.0
6.79k stars 560 forks source link

Database transaction #10933

Closed ChenpiDog closed 1 year ago

ChenpiDog commented 1 year ago

Is your feature request related to a problem? Please describe.

Does RisingWave support Database transaction? For example: READ UNCOMMITTED, READ COMMITTED.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

I am currently using an HTAP database that does not have stream processing capabilities. I am looking for a database that has stream processing capabilities and can cover my original business scenarios.

liurenjie1024 commented 1 year ago

Hi, @ChenpiDog Risingwave doesn't provide acid guarantees like oltp databases. We do support begin/commit/rollback statement to be compatible with some tools, but isolation is not guaranteed.

ChenpiDog commented 1 year ago

@liurenjie1024 What are the considerations for the future, and are there any plans to support transaction isolation?

liurenjie1024 commented 1 year ago

@liurenjie1024 What are the considerations for the future, and are there any plans to support transaction isolation?

Currently we don't see strong requirements for this, so currently no plan for that. But we are working transaction consistency when importing cdc data from upstream oltp databases.

fuyufjh commented 1 year ago

I am currently using an HTAP database that does not have stream processing capabilities. I am looking for a database that has stream processing capabilities and can cover my original business scenarios.

@ChenpiDog Thanks for your interest! However, RisingWave is not designed to be a substitute of HTAP databases. I would recommend using RisingWave as the downsteram of your primary database to run streaming processing.