Browsing Data

With a table or view selected in the sidebar, the Data tab shows the contents of that entity.

Moving around

By default, Base shows 100 rows in the table at a time (you can change this in the app settings).

To page through the rows, use the left () and right () arrow buttons below the table. To jump directly to a row offset, click the row numbers between the arrows.

Filtering data

To show or hide the filter editor, click the button below the table.

Once visible, you can build a filter by adding or removing rules. As the filter changes, the rows in the table above will be limited to those matching the filter.

If you would like to work with the filter as code, clicking the "Send to SQL" button will open it as a query in the SQL tab.

Editing data

Adding and removing rows

To add a row, click the add () button below the table. To remove selected rows, use the remove () button.

Note

Views can't have rows added or removed directly, you need to change the underlying tables

Editing existing data

Double-click on a table cell to edit it. Changes will be applied when you select another row.

The row editor

Some values can be too large to conveniently edit directly in the data table. You can choose at what size this cutoff is made in the app settings under Long text threshold.

When you try to edit a cell with content larger than this value, the row editor sheet will be shown.

This sheet provides a larger editor for text or numbers, as well as a preview for BLOB data like images or other files. Changes will only be applied when you click the Update button.