3 ms·
https://www.dolthub.com/ https://www.dolthub.com/ So I get what you're saying, but at the same time that means your business data can't ever include formulas.
by bloaf 3y ago
https://www.dolthub.com/ https://www.dolthub.com/
So I get what you're saying, but at the same time that means your business data can't ever include formulas.
I've worked in areas where the formulas were business data (i.e. modeling). You could hard-code all your models/correlations/aggregation functions. But then it becomes much harder to make UIs that do things like "find all formulas that involve this thermometer reading" or allow a technician to make temporary edits without risking them screwing up your entire application.
- BVegter 3y agoWith our approach in Colbert, you can provide your table that holds a formula field with a corresponding tag field and apply formulas to your data using a WHERE clause on the tag field. This allows you to safely test different scenarios. Furthermore, in Colbert, you have the capability to inquire about the parameters used in each formula. For example, you can test the appearance of a specific parameter by querying: SELECT * FROM Employees WHERE params bonus contains 'Birthdate'