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.
With the FairCom server running, open the browser-based menu (https://localhost:8443/) to access the FairCom graphical user interfaces.
Open Data Explorer and use the API Explorer to access the various JSON APIs.
API Explorer
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.
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.
SQL queries
Run simple SELECT statements only, showing the results in a text area below.
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.
Tables details
View the metadata for a table, which includes the table's field names, data types, and constraints.
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.
