Introduction to data

The data section in the Budibase UI is where you add and manage your data. Budibase apps rely on data and it is strongly advised to create your data structure before designing your web application. Your data structure will involve tables, columns, rows, and views - these are the building blocks that hold and present your data in a structured manner.

Predefining the data structure also greatly helps in building the UI as the UI can be automatically generated based on the data structure, as well as any logic, filtering, and sorting.

Within Budibase we have a single built-in Datasource and several external datasources. When using a self-hosted instance of Budibase, an external datasource can still live on the same device, just not within the Budibase container.

Getting started with data

By default, every Budibase application will start with a Budibase DB datasource. This database contains a Users table which is considered a special table. This table includes all the users who have access to your application, with their respective roles.

This table is not removable as the functioning of your application depends on it. Any further BudibaseDB tables will also be added to this same source.

Adding new datasources

You can easily add new datasources to any Budibase application. There are a broad set of available external datasources you can connect to right from the Budibase UI.

You can add new data sources by clicking the Add source button on the top left of the screen when you're in your app on the Data tab, as seen in the image below.

Once you've clicked the Add source button, you'll see a modal presented with the available datasources. Pick your datasource of choice, and you will be presented with a configuration screen to connect to your remote datasource.

You can add as many datasources as you need following the same process.

To know more about a particular datasource, look at the relevant documentation page in the menu.