Lightweight, easy to use, and powerful. Worry about your app, let HarperDB worry about your database.
HarperDB offers fully featured NoSQL with features that are unique to HarperDB like joins on SQL query, 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 provide both NoSQL and SQL capability do this using a concept called multi-model. Multi-model either duplicates your data or it utilizes significant amounts of RAM to do transformations in memory. This is expensive from a capital resource perspective. HarperDB’s single model means there is no transformation of data required and as a result, significant savings on storage and 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 being Schema-less means that it is flexible enough to ingest unstructured data while at the same time providing complex SQL capability.
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.