Interfacing with HarperDB is done through a simple to use REST API. HarperDB has a single end point with a consistent JSON object model that allows you to simply and explicitly interact with your data.
HarperDB offers full NoSQL CRUD with features that are unique to HarperDB like joins, advanced math, and multiple conditions. HarperDB offers full CRUD operations via SQL like any traditional RDBMS which is intended to accommodate application and BI use cases. This allows ingestion of data via standard SQL INSERT & UPDATE as well as offering complex SQL queries with no performance impact on unstructured data. Joins, multiple operators, and multiple conditions are possible in sub-second time.
While any product can be fully indexed, HarperDB is fully indexed without utilizing RAM or increasing the storage footprint. No configuration is required. This allows HarperDB to have equally fast performance on searching any attribute in the database without replicating data or utilizing expensive RAM.
Most products that can provide full ANSI SQL capability with joins and multi-conditions require schema management. This means tables, columns, data types, & indices must be defined, and significant configuration is required which often slows down integration. It also means these solutions have difficulty ingesting unstructured data as that data can change from insert to insert. HarperDB having a dynamic schema means that it is flexible enough to ingest unstructured data while at the same time providing complex SQL capability.