DBMS > HarperDB
HarperDB System Properties
Please select another system to compare it with HarperDB.
|Editorial information provided by DB-Engines|
|Description||A distributed database focused on speed and ease of use. It has an intuitive REST API, and supports NoSQL and SQL including joins. HarperDB leverages standard interfaces, and users can be up and running in minutes.|
|Primary database model||Document store|
|Current release||3.1, August 2021|
|License Commercial or Open Source||commercial free community edition available|
|Cloud-based only Only available as a cloud service||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||Linux|
|Data scheme||dynamic schema|
|Typing predefined data types such as float or date||yes JSON data types|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no|
|SQL Support of SQL||SQL-like data manipulation statements|
|APIs and other access methods||JDBC|
RESTful HTTP/JSON API
|Supported programming languages||.Net|
|Server-side scripts Stored procedures||Custom Functions since release 3.1|
|Partitioning methods Methods for storing different data on different nodes||A table resides as a whole on one (or more) nodes in a cluster|
|Replication methods Methods for redundantly storing data on multiple nodes||yes the nodes on which a table resides can be defined|
|MapReduce Offers an API for user-defined Map/Reduce methods||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||Atomic execution of specific operations|
|Concurrency Support for concurrent manipulation of data||yes|
|Durability Support for making data persistent||yes, using LMDB|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes|
|User concepts Access control||Access rights for users and roles|
|More information provided by the system vendor|
HarperDB is the first distributed database with hybrid SQL & NoSQL functionality & a REST API. Known as a structured object store with SQL capabilities, or NewSQL. HarperDB is focused on speed, ease of use, & flexibility. As a distributed database, HarperDB leverages a logical structure enabling ACID compliant efficient storage & retrieval without inconsistency, race conditions, or utilizing in-memory indexing. HarperDB is fully indexed & runs on any device from edge to cloud. HarperDB Cloud is their database-as-a-service offering.
HarperDB's unique storage algorithm built on top of LMDB enables HarperDB to ingest JSON documents & relational data in a single product.
SQL & NoSQL
Insert JSON, query with performant SQL including joins & full CRUD operations. Regardless of how data is ingested, data is stored according to the HarperDB data model & can be queried via SQL or NoSQL.
Ingest any type of data at scale. The schema reflexively creates attributes on ingest, creating new database fields as they are sent. Users can ingest unstructured data & retain SQL functionality.
Clustering & Replication
HarperDB leverages a publish/subscribe model to move data between instances. This enables configurable bi-directional, table-level replication. HarperDB’s clustering is fault tolerant, peer-to-peer, provides table level replication, has a globally shared schema, & enables distributed computing.
All database operations are available via a single endpoint HTTP API with a stateless microservices architecture. See API documentation in our Postman Collection.
The HarperDB Studio enables users to manage both self-hosted & HarperDB Cloud managed instances. The Studio includes Marketplace & resources like SDKs, connectors, drivers, example code, & video tutorials.
HarperDB is cross-platform, running natively on Linux, MacOS & Microsoft WSL2. It can be deployed via Docker container, & is available for download via npm or as a managed service via HarperDB Studio.
The HarperDB Studio is web-based & can be accessed via anything with a web browser.
Role Based Security
HarperDB uses a Role-Based Access Control (RBAC) framework to manage access to HarperDB instances. Visit the documentation.
HarperDB is fully ACID compliant allowing users to follow the universal standard of SQL query language at the standards of atomicity, consistency, isolation, & durability.
Industry Standard Interfaces & Drivers
HarperDB leverages standard interfaces and provides numerous drivers.
By combining the functionality of the best SQL, NoSQL, and NewSQL products on the market into one powerful tool, HarperDB makes data management easier and more cost effective. Effectively enabling SQL on JSON, users no longer have to choose a database based on the structure of their data. With HarperDB’s speed, flexibility, and customization, you can reduce time spent on database maintenance and reduce the number of systems needed to achieve your end goal. HarperDB is allowing developers from relational backgrounds to use their existing knowledge with SQL with a database that also allows their team to use NoSQL from the same data model (and vice versa).
On average, HarperDB was 37X faster than MongoDB, 6.8X faster than InfluxDB on writes, and 581% faster than SQLite. HarperDB scales out-of-the-box for concurrent operations, & has simplified work on database administration & maintenance. See the benchmarks.
|Typical application scenarios|
Use cases where HarperDB is a better fit than other solutions include:
HarperDB enables developers and technology leaders to:
A few highlighted customers include: US Army, US Airforce, Chelan PUD, TATA, & Lumen.
Over 26K total HarperDB users:
|Licensing and pricing models|
HarperDB follows a freemium/premium model. A database is only as powerful as it is flexible, so we created a simple pricing model based on the memory of a machine. Pricing is per instance and is based on provisioned memory. For self-hosted instances, HarperDB will restrict itself to use only the RAM afforded by its license.
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Recent citations in the news|
Jaxon Repp on HarperDB Distributed Database Platform
HarperDB Releases HarperDB Cloud
Build a Hacker News Clone using React and HarperDB
HarperDB: An underdog SQL / NoSQL database
Jaxon Repp's InfoQ Profile
provided by Google News
Sales & Customer Success Engineer
Cloud Platform Software Engineer
Share this page