Is it possible to run a background process to take action on a list of items from an external database connection? For example, pull all widgets from a SQL Server Database and run an external action (through SQL Database Connector) for each row. I understand how to connect to the database and execute actions, but I can’t figure out how to loop through each row from and external source and execute an action. Hopefully I am just a noob and don’t know something simple! Thx
Are you talking about looping throgh a external Database in bubble backend, i wont suggest that , you can probably do it but it will cost you work unit.
thus i suggest user a intermediatly system like n8n to do all the compuitng and then ping bubble.io backend with the result if you want to store them there or the 3rd part server it self
in bubble.io computing cost ( work unit) is really limit how much we can do if we are cost concious .