The Data page in OrbisDB allows users to visually explore and manage the content of their OrbisDB instance. This interface provides a comprehensive view of the tables, views, and their respective data entries, enabling efficient data management and analysis while also allowing users to perform custom SQL queries.

Features

• Tables List: Displays all the tables within the OrbisDB instance, allowing users to quickly navigate through their data.
• Views List: Shows all the views created for more customized data queries and visualizations.
• Data Table: Provides a detailed view of the data within the selected table.
• SQL Editor: A built-in SQL editor for performing custom queries or creating views directly within the OrbisDB interface.

User Interface

Tables and Views

• Tables List: This section lists all the tables available in the OrbisDB instance. Clicking on a table name will display its data in the Data Table section.
• Views List: This section lists all the views available. Views are customized representations of the data based on specific queries and are either defined by the user or by presets.

Data Table

The Data Table displays the contents of the selected table. Each row in the table represents a data entry, and each column represents a field in the data model.

Users can navigate through the data using pagination controls and can refresh or filter the data as needed.

Editor

At the top of the Tables and Views list, users can access the Editor by clicking the "Open Editor" button. Our editor allows users to perform custom SQL or GraphQL queries and also to create specific views (using SQL) for more advanced data manipulation and analysis.

SQL Editor

…