Hello, and thanks for your post. Unfortunately, as it is, FactorySQL is a standalone application, and there are not currently plans on changing this. That said, I have 2 observations/comments:
The benefit of our database-centric system is that any application can interact with the data store. Perhaps you could simply interact with the database, going as far as to create action item triggers where necessary.
The plugin system: we are very interested in expanding the number of ways an interested third party could interact/modify FactorySQL in the form of plugins. Currently, we have a basic API that allows you to expose functions to Action Items scripts. Perhaps you could encapsulate your business logic into a set of functions, and in combination with database interaction, accomplish your desired goal? The API provides a good deal of flexibility on how the referenced assemblies are accessed and objects instantiated. You could, for instance, create a plugin class that is set to instantiate only once on the server (a singleton). You could then have multiple groups passing data to this item through action item function calls, and other groups querying the item to either get data and/or determine trigger status.
This may or may not be useful to you, but I just wanted to point out that capability.
Ultimately, we would like to expand the plugin system to allow users to create more tightly integrated objects, such as custom groups (including visual configuration elements), or items. Unfortunately, though, I can’t give you a solid timeframe for this, as demand for this type of functionality has been rather low.
Please feel free to followup/comment, we’re always happy to explore & discuss new ideas.