LogoLogo
4.1
4.1
  • Developer Documentation
  • Install HarperDB
    • On Linux
  • Getting Started
  • Full API Documentation
  • HarperDB Studio
    • Create an Account
    • Log In & Password Reset
    • Resources (Marketplace, Drivers, Tutorials, & Example Code)
    • 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
  • HarperDB Cloud
    • IOPS Impact on Performance
    • Instance Size Hardware Specs
    • Alarms
    • Verizon 5G Wavelength
  • Security
    • JWT Authentication
    • Basic Authentication
    • Configuration
    • Users & Roles
  • Clustering
    • Requirements and Definitions
    • Creating A Cluster User
    • Naming A Node
    • Enabling Clustering
    • Establishing Routes
    • Subscription Overview
    • Managing Subscriptions
    • Things Worth Knowing
  • Custom Functions
    • Requirements and Definitions
    • Create a Project
    • Define Routes
    • Define Helpers
    • Host A Static Web UI
    • Using NPM and GIT
    • Custom Functions Operations
    • Restarting the Server
    • Debugging a Custom Function
    • Custom Functions Templates
    • Example Projects
  • Add-ons and SDKs
    • Google Data Studio
  • SQL Guide
    • SQL Features Matrix
    • Insert
    • Update
    • Delete
    • Select
    • Joins
    • SQL Date Functions
    • SQL Reserved Word
    • SQL Functions
    • SQL JSON Search
    • SQL Geospatial Functions
      • geoArea
      • geoLength
      • geoDifference
      • geoDistance
      • geoNear
      • geoContains
      • geoEqual
      • geoCrosses
      • geoConvert
  • HarperDB CLI
  • Configuration File
  • Logging
  • Transaction Logging
  • Audit Logging
  • Jobs
  • Upgrade a HarperDB Instance
  • Reference
    • Storage Algorithm
    • Dynamic Schema
    • Data Types
    • Content Types/Data Formats
    • HarperDB Headers
    • HarperDB Limits
  • Support
  • Release Notes
    • HarperDB Tucker (Version 4)
      • 4.1.0
      • 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
Powered by GitBook

© HarperDB. All Rights Reserved

On this page
  • Manage Schemas and Tables
  • Manage Table Data
  • Browse Table Data
Export as PDF
  1. HarperDB Studio

Manage Schemas / Browse Data

Manage instance schemas/tables and browse data in tabular format with the following instructions:

  1. Navigate to the HarperDB Studio Organizations page.

  2. Click the appropriate organization that the instance belongs to.

  3. Select your desired instance.

  4. Click browse in the instance control bar.

Once on the instance browse page you can view data, manage schemas and tables, add new data, and more.

Manage Schemas and Tables

Create a Schema

  1. Click the plus icon at the top right of the schemas section.

  2. Enter the schema name.

  3. Click the green check mark.

Delete a Schema

Deleting a schema is permanent and irreversible. Deleting a schema removes all tables and data within it.

  1. Click the minus icon at the top right of the schemas section.

  2. Identify the appropriate schema to delete and click the red minus sign in the same row.

  3. Click the red check mark to confirm deletion.

Create a Table

  1. Select the desired schema from the schemas section.

  2. Click the plus icon at the top right of the tables section.

  3. Enter the table name.

  4. Enter the primary key.

    The primary key is also often referred to as the hash attribute in the studio, and it defines the unique identifier for each row in your table.

  5. Click the green check mark.

Delete a Table

Deleting a table is permanent and irreversible. Deleting a table removes all data within it.

  1. Select the desired schema from the schemas section.

  2. Click the minus icon at the top right of the tables section.

  3. Identify the appropriate table to delete and click the red minus sign in the same row.

  4. Click the red check mark to confirm deletion.

Manage Table Data

The following section assumes you have selected the appropriate table from the schema/table browser.

Filter Table Data

  1. Click the magnifying glass icon at the top right of the table browser.

  2. This expands the search filters.

  3. The results will be filtered appropriately.

Load CSV Data

  1. Click the data icon at the top right of the table browser. You will be directed to the CSV upload page where you can choose to import a CSV by URL or upload a CSV file.

  2. To import a CSV by URL:

    1. Enter the URL in the CSV file URL textbox.

    2. Click Import From URL.

    3. The CSV will load, and you will be redirected back to browse table data.

  3. To upload a CSV file:

    1. Click Click or Drag to select a .csv file (or drag your CSV file from your file browser).

    2. Navigate to your desired CSV file and select it.

    3. Click Insert X Records, where X is the number of records in your CSV.

    4. The CSV will load, and you will be redirected back to browse table data.

Add a Record

  1. Click the plus icon at the top right of the table browser.

  2. The Studio will pre-populate existing table attributes in JSON format.

    The primary key is not included, but you can add it in and set it to your desired value. Auto-maintained fields are not included and cannot be manually set. You may enter a JSON array to insert multiple records in a single transaction.

  3. Enter values to be added to the record.

    You may add new attributes to the JSON; they will be reflexively added to the table.

  4. Click the Add New button.

Edit a Record

  1. Click the record/row you would like to edit.

  2. Modify the desired values.

    You may add new attributes to the JSON; they will be reflexively added to the table.

  3. Click the save icon.

Delete a Record

Deleting a record is permanent and irreversible. If transaction logging is turned on, the delete transaction will be recorded as well as the data that was deleted.

  1. Click the record/row you would like to delete.

  2. Click the delete icon.

  3. Confirm deletion by clicking the check icon.

Browse Table Data

The following section assumes you have selected the appropriate table from the schema/table browser.

Browse Table Data

The first page of table data is automatically loaded on table selection. Paging controls are at the bottom of the table. Here you can:

  • Page left and right using the arrows.

  • Type in the desired page.

  • Change the page size (the amount of records displayed in the table).

Refresh Table Data

Click the refresh icon at the top right of the table browser.

Automatically Refresh Table Data

Toggle the auto switch at the top right of the table browser. The table data will now automatically refresh every 15 seconds. Filters and pages will remain set for refreshed data.

PreviousQuery Instance DataNextManage Charts

Last updated 1 year ago