Budibase can store your data inside the native internal database (CouchDB). This is the default datasource unless you opt to connect another datasource to Budibase.
Budibase supports connection to a range of remote datasources including:
- MS SQL Server
- MySQL / MariaDB
More information about connecting Budibase to each of these datasources is nested in this section of the documentation.
Furthermore, if a datasource you want to use is missing, it is possible to build a custom datasource.
Upon creation of an app, Budibase will provide some sample data to allow new users to explore the various Data types available, and quickly build an app for learning purposes. Whilst it is a BudibaseDB source, it will be kept separate to the BudibaseDB tables that you create.
If you do not need this data, it can easily be removed in the same way as other additional datasources. Simply click on the ellipsis to the right of the sample data source and click Delete.
It is also worth noting that you can choose not to add the sample data when creating an app. Simply toggle
Include sample data off.
When Fetching tables from external SQL databases, Budibase will attempt to match the external data types to the internal Budibase DB types. These default types can be changed by clicking the pencil icon beside the table columns:
For other basic datasources and Custom queries, the schema will be determined by selecting types in the query output.
The schema is important, as it will affect how sorting and filtering is applied in the design section.
When connecting to an external datasource you must allow Budibase access to your datasource. Normally datasources will be protected by a firewall and you will need to open firewall access to your datasource from the Budibase cloud or from your self-hosted Budibase. Port numbers and user management differ across each type of datasource so if you have difficulty connecting you should speak to the Database Administrator for your organisation.
Updated about 2 months ago