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 (Browse Add Button) 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 (Browse Remove Button) 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 (Browse Add Button) at the top right of the tables section.
  3. Enter the table name.
  4. Enter the hash attribute.
    The hash attribute defines the unique identifier for each row in your table. In a traditional RDBMS this would be called a primary key.
  5. Click the green check mark.

 

Delete a Table

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

  1. Select the desired schema from the schemas section.
  2. Click the minus icon (Browse Remove Button) 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 (Browse Magnifier 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 (Studio 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 (Browse Add Button) at the top right of the table browser.
  2. The Studio will pre-populate existing table attributes in JSON format.
    The hash_attribute 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 and 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 and they will be reflexively added to the table.
  3. Click the save icon (Studio Record 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 (Studio Record Delete Icon).
  3. Confirm deletion by clicking the check icon (Studio Record Delete Confirmation).

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 (Refresh Icon) at the top right of the table browser.

 

Automatically Refresh Table Data

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