Elasticsearch Was Never a Database

Elasticsearch, designed as a search engine atop Apache Lucene, is often misused as a primary database. This leads to issues like lack of atomic transactions, complex schema migrations, limited query capabilities, and reliability problems during failures. While excellent for fast, flexible searching, Elasticsearch lacks fundamental database guarantees such as transaction boundaries, isolation levels, and consistent data operations. Using it as both search engine and primary datastore increases complexity rather than simplifying systems.