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 that cannot be removed. This table includes all the users who have access to your application, with their respective roles.

Adding new datasources

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 + button on the left-hand panel when you're on the Data tab, as seen in the image below.

Adding a datasource

Adding a datasource

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.

Choose a datasource

Choose a 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.

What’s Next

Now that you understand the basics of data sources, you might want to dive into these pages next