What does HackerNews think of doris?
Apache Doris is an easy-to-use, high performance and unified analytics database.
To be fair, these are the only examples I can think of and I only learned of these as I'm standing up new data infra using starrocks.
Don't know if OP Jun Zhang gets to see this, but this is a nice (and interesting) technical writeup but imo you have 2 blogposts in one here.
- https://github.com/apache/doris
In fact, a large part of the work of many emerging database systems, including Doris, is to supplement the missing functions compared with the traditional databases(Like Oracle), so as to help users smoothly migrate from the original system to the new system. Such as the CTE mentioned by zX41ZdbW.
At the same time, most of projects are emphasizing their performance and cost-effectiveness, because this is the first factor for user selection. For example, Doris and SelectDB (Doris Commercial Company) also participated in Clickbench to reflect their performance advantages. But the implementations of various projects are actually converging (Doris' execution engine also refers to Clickhouse, thanks for open source), so we can only look for advantages in specific scenarios, such as high concurrency, time series, etc.
On the other hand, performance and cost-effectiveness do not really solve users' problems, so we are also thinking about what users really need besides technology.
Another interesting point is the trend of "de-distribution". Like Clickhouse and DuckDB, they can run well on a single machine with a multi-core, and can also meet the needs of many users. The reliability, availability, and scalability problems solved by "distribution" can all be solved in the PaaS of cloud vendors.