LogoLogo
Studio
4.2
4.2
  • HarperDB Docs
  • Getting Started
  • Developers
    • Applications
      • Caching
      • Defining Schemas
      • Debugging Applications
      • Define Fastify Routes
      • Example Projects
    • Components
      • Installing
      • Writing Extensions
      • Operations
      • Google Data Studio
      • SDKs
      • Drivers
    • REST
    • Operations API
      • Quick Start Examples
      • Databases and Tables
      • NoSQL Operations
      • Bulk Operations
      • Users and Roles
      • Clustering
      • Custom Functions
      • Components
      • Registration
      • Jobs
      • Logs
      • Utilities
      • Token Authentication
      • SQL Operations
      • Advanced JSON SQL Examples
    • Real-Time
    • Clustering
      • Requirements and Definitions
      • Creating A Cluster User
      • Naming A Node
      • Enabling Clustering
      • Establishing Routes
      • Subscription Overview
      • Managing Subscriptions
      • Things Worth Knowing
      • Certificate Management
    • Security
      • JWT Authentication
      • Basic Authentication
      • Configuration
      • Users & Roles
      • Certificate Management
    • SQL Guide
      • SQL Features Matrix
      • SQL Date Functions
      • SQL Reserved Word
      • SQL Functions
      • SQL JSON Search
      • SQL Geospatial Functions
  • Administration
    • Best Practices and Recommendations
    • Logging
      • Standard Logging
      • Audit Logging
      • Transaction Logging
    • Clone Node
    • Jobs
    • HarperDB Studio
      • Create an Account
      • Log In & Password Reset
      • Organizations
      • Instances
      • Query Instance Data
      • Manage Schemas / Browse Data
      • Manage Charts
      • Manage Clustering
      • Manage Instance Users
      • Manage Instance Roles
      • Manage Functions
      • Instance Metrics
      • Instance Configuration
      • Instance Example Code
      • Enable Mixed Content
  • Deployments
    • Configuration File
    • HarperDB CLI
    • Install HarperDB
      • On Linux
    • Upgrade a HarperDB Instance
    • HarperDB Cloud
      • IOPS Impact on Performance
      • Instance Size Hardware Specs
      • Alarms
      • Verizon 5G Wavelength
  • Technical Details
    • Reference
      • Analytics
      • Architecture
      • Content Types
      • Data Types
      • Dynamic Schema
      • HarperDB Headers
      • HarperDB Limits
      • Globals
      • Resource Class
      • Transactions
      • Storage Algorithm
    • Release Notes
      • HarperDB Tucker (Version 4)
        • 4.2.8
        • 4.2.7
        • 4.2.6
        • 4.2.5
        • 4.2.4
        • 4.2.3
        • 4.2.2
        • 4.2.1
        • 4.2.0
        • 4.1.2
        • 4.1.1
        • 4.1.0
        • 4.0.7
        • 4.0.6
        • 4.0.5
        • 4.0.4
        • 4.0.3
        • 4.0.2
        • 4.0.1
        • 4.0.0
      • HarperDB Monkey (Version 3)
        • 3.3.0
        • 3.2.1
        • 3.2.0
        • 3.1.5
        • 3.1.4
        • 3.1.3
        • 3.1.2
        • 3.1.1
        • 3.1.0
        • 3.0.0
      • HarperDB Penny (Version 2)
        • 2.3.1
        • 2.3.0
        • 2.2.3
        • 2.2.2
        • 2.2.0
        • 2.1.1
      • HarperDB Alby (Version 1)
        • 1.3.1
        • 1.3.0
        • 1.2.0
        • 1.1.0
  • More Help
    • Support
    • Slack
    • Contact Us
Powered by GitBook
On this page
  • Select
  • Body
  • Response: 200
  • Insert
  • Body
  • Response: 200
  • Update
  • Body
  • Response: 200
  • Delete
  • Body
  • Response: 200
  1. Developers
  2. Operations API

SQL Operations

Select

Executes the provided SQL statement. The SELECT statement is used to query data from the database.

  • operation (required) - must always be sql

  • sql (required) - use standard SQL

Body

{
    "operation": "sql",
    "sql": "SELECT * FROM dev.dog WHERE id = 1"
}

Response: 200

[
    {
        "id": 1,
        "age": 7,
        "dog_name": "Penny",
        "weight_lbs": 38,
        "breed_id": 154,
        "owner_name": "Kyle",
        "adorable": true,
        "__createdtime__": 1611614106043,
        "__updatedtime__": 1611614119507        
    }
]

Insert

Executes the provided SQL statement. The INSERT statement is used to add one or more rows to a database table.

  • operation (required) - must always be sql

  • sql (required) - use standard SQL

Body

{
    "operation": "sql",
    "sql": "INSERT INTO dev.dog (id, dog_name) VALUE (22, 'Simon')"
}

Response: 200

{
    "message": "inserted 1 of 1 records",
    "inserted_hashes": [
        22
    ],
    "skipped_hashes": []
}

Update

Executes the provided SQL statement. The UPDATE statement is used to change the values of specified attributes in one or more rows in a database table.

  • operation (required) - must always be sql

  • sql (required) - use standard SQL

Body

{
    "operation": "sql",
    "sql": "UPDATE dev.dog SET dog_name = 'penelope' WHERE id = 1"
}

Response: 200

{
    "message": "updated 1 of 1 records",
    "update_hashes": [
        1
    ],
    "skipped_hashes": []
}

Delete

Executes the provided SQL statement. The DELETE statement is used to remove one or more rows of data from a database table.

  • operation (required) - must always be sql

  • sql (required) - use standard SQL

Body

{
    "operation": "sql",
    "sql": "DELETE FROM dev.dog WHERE id = 1"
}

Response: 200

{
    "message": "1 of 1 record successfully deleted",
    "deleted_hashes": [
        1
    ],
    "skipped_hashes": []
}
PreviousToken AuthenticationNextAdvanced JSON SQL Examples

Last updated 1 year ago