Databend for OLTP web applications.

[ansarizafar]

Is there a plan to make databend suitable for OLTP web applications?

[BohuTANG]

Is there a plan to make databend suitable for OLTP web applications?

Hi,

What's the OLTP web applications requirements?
If it's data-intensive applications(OLAP-based) i think it's no problem.

[Xuanwo]

@BohuTANG Let's move question alike issues to the discussion Q&A instead.

[Xuanwo]

I think all issues under C-quesion should be moved either.

Here is the query: https://github.com/datafuselabs/databend/issues?q=is%3Aopen+is%3Aissue+label%3AC-question

[ansarizafar]

OLTP enables the real-time execution of large numbers of transactions by large numbers of people, whereas online analytical processing (OLAP) usually involves querying these transactions (also referred to as records) in a database for analytical purposes. https://www.oracle.com/database/what-is-oltp/

Currently, databend can't be used to update or delete rows. Documentation shows only select and insert statement under data manipulation language section. My understanding is that databend is for data analytics only like clickhouse and not suitable for using as a general purpose RDMS,. Am I right?

Let me rephrase my question, Is it possible to replace mysql or postgres with databend for using as a main back end data store for an eCommerce or ERP web application?

[ansarizafar]

I am waiting for a reply.

[Xuanwo]

Hi, thanks for waiting.

We have not plan to support OLTP workload so far. It's possible to use databend if your application is data-intensive, but it's not the main goal of this project.

Databend is an elastic and reliable Cloud Data Warehouse.