Skip to main content

Data Explorer

Data Explorer UI tutorials

Use Data Explorer to manage FairCom databases and explore JSON APIs

Overview

The following sections provide a visual overview of the various tabs available in Data Explorer.

API Explorer

Access our various JSON APIs.

api_explorer.png

Create table

Create a table and define the columns, one at a time. The pop-up builds the create table statement and then executes it once the user is done building it through the UI. This pop-up is accessed by right clicking on the left sidebar Tables node and selecting Create Table.

create_table.png

Query builder

Visually define a SELECT statement, field-by-field, without having to build a statement from scratch in the SQL query or scripts tab. This also allows for building join queries.

querybuilder.png

SQL queries

Run simple SELECT statements only, showing the results in a text area below.

sqlqueries.png

SQL scripts

Execute more complex, multi-statement scripts, such as creating a table, inserting a record, and selecting them for display all in one operation.

sqlscripts.png

Tables details

View the metadata for a table, which includes the table's field names, data types, and constraints.

tables_details.png

Table records

View the records for a selected table. This functionality also enables the user to select a single record to view and update/insert/delete if desired. This record viewer also allows users to open a binary editor and view the contents of a binary payload.

tables_tablerecords.png