Data Source
Options in the select list column can be imported and synced from external databases.
To do this, administrators must first establish a connection to a database. A connection with the following databases can be established:
MySQL
PostgreSQL
Oracle SQL
Microsoft SQL Server
REST API
To create a connection, go to Manage apps → STAGIL Tables & Checklists → Data sources. Click the ‘Add data source’ button on the' Data sources' page.
Data source connection settings
Name: Choose a unique and descriptive name for your configuration to easily identify it later.
Description. Add a comment to the connection.
Data source type: Select the appropriate database type from the available options.
Hostname/IP: Specify the connection endpoint by providing the server address or IP number.
Port. Enter the database port number.
Database name. Enter the name of the specific database you intend to connect to.
Table/view. Indicate the exact database table or view you want to sync with. This defines the source of your data within the database.
Username. Input the username of an authorized user with access to the specified database. This is required for authentication.
Password. Provide the corresponding password for the authorized database user.
Excellent note. Here’s the revised section with a more neutral, explanatory tone, suitable for documentation — no directive language, no dev-story phrasing:
🔄 Behaviour when switching data sources
When changing the Data source configuration of a select list column, existing values in your tables are validated against the new source. The system applies clean-up rules depending on the transition type to ensure consistency and prevent orphaned values.
From custom values to a SQL source
All values currently stored in the table are checked against the connected SQL source.
Any values that still exist in the external source are preserved.
Values that are no longer present in the external source are removed from the table.
Before saving, a warning will be displayed: “Existing values that do not exist in the data source will be cleared.
From a SQL source to custom values
Values already used in the table remain intact.
These values are validated only against the newly defined custom list.
Values not found in the current custom options will be discarded.
Before saving, a warning will be displayed: “Existing values that do not exist in the list above will be cleared.”
From one SQL source to another
Values present in both the current table and the new data source are retained.
Where matches are found, new option IDs are assigned automatically to reflect the updated source.
Values not found in the new data source are removed.
Before saving, a warning will be displayed: “Existing values that do not exist in the list above will be cleared.”
🛑 Out of scope
The following features are not supported with data source-connected select lists:
Table export/import
Row templates using external options
Column default values
Cascading select lists
📎 Notes for database admins
STAGIL Tables does not copy or cache SQL tables into the app’s database.
Connections remain live and are queried as needed.
Ensure your SQL sources are stable and performant to avoid latency in option loading.