Built for Developers
Easy to use REST API, sleek management studio, language agnostic, quick install, limited database configuration required.
SQL on JSON

Insert JSON, query with performant SQL including JOINS and full CRUD operations.  Enhanced features like built in Math.js and GeoJSON.

Runs Anywhere

HarperDB is a full-featured data management platform that runs from edge to cloud, and anywhere in between. 

Easy Integration

Insert JSON, CSVs, or via SQL with a simple to use, single endpoint REST API. Code examples available in most languages.

 

let needle = require('needle');

let body = {
    operation: "insert",
    schema: "dev",
    table: "dog",
    records: [
        {name: "Harper", breed: "Mutt", id: "1", age: 5},
        {name: "Penny", breed: "Mutt", id: "3", age: 5}
    ]
};

let options = {
    json:true,
    headers: {
        'Authorization': 'Basic SERCX0FETUlOOnBhc3N3b3Jk'
    }
};

needle('post', 'https://hdb-demo.harperdbcloud.com', body, options)
    .then(function(response) {
        console.log(response.statusCode);
        console.log(response.body);
    })
    .catch(function(err) {
        console.error(err);
});

{
  "operation": "sql",
  "sql": "SELECT d.id, d.dog_name, d.owner_name, b.name, b.section 
          FROM dev.dog AS d 
            INNER JOIN dev.breed AS b
              ON d.breed_id = b.id
          WHERE d.owner_name IN ('Kyle', 'Zach', 'Stephen')
            AND b.section = 'Mutt'
          ORDER BY d.dog_name"
}

Query JSON Using SQL

Execute complex, performant, ACID compliant SQL queries on JSON with no data duplication. Utilize joins, complex operations, array functions, GeoJSON and Math.js.

Results Returned as JSON Arrays

Search using JSON filters or SQL queries and return objects that are easy to wire into your application. No ORM required.

[
    {
        "id": 4,
        "dog_name": "Billy",
        "owner_name": "Zach",
        "name": "LABRADOR / GREAT DANE MIX",
        "section": "Mutt"
    },
    {
        "id": 2,
        "dog_name": "HarperDB",
        "owner_name": "Stephen",
        "name": "HUSKY MIX",
        "section": "Mutt"
    },
    {
        "id": 5,
        "dog_name": "Rose Merry",
        "owner_name": "Zach",
        "name": "TERRIER MIX",
        "section": "Mutt"
    }
]

Attribute Level Security

Leverage a dynamic schema with attribute level, role based security. Grant read, insert, update, and delete permissions at an atomic level. Enjoy the flexibility of a NoSQL database with the security of an RDBMS.

ACID Compliant Transactions

HarperDB stores data at an atomic level allowing for a dynamic, flexible schema with ACID compliant transactions.  The flexibility of a NoSQL schema with consistency and durability of a RDBMS in a single storage engine.

Easy to Use Studio

Install, design, cluster, and manage your databases without writing a line of code in a sleek, easy to use management interface. Upload CSVs, execute queries, manage instances, and manage security all in one place with no coding required.

Connect to Anything

HarperDB has a variety of drivers and plugins like ODBC, JDBC, Node-RED, and many more. Consume JSON data in real-time and execute advanced analytics using BI tools like Tableau, PowerBI, and many others.