BVegter

3 ms·

1.
What's Wrong with SQL?(colbert.nl)
3 points by BVegter 2y ago|1 comments
2.
by BVegter 2y ago
Not much. In fact, SQL is a powerful language for gaining insights from your data. The concept of a view serves as an efficient, dynamic mechanism to define how insights are derived without the need for copying or moving data. However, ther
3.
Conceptual Foundations of Formulas Stored in Database Fields(colbert.nl)
1 points by BVegter 2y ago|1 comments
4.
by BVegter 2y ago
In a previous article titled 'Executing Formulas Stored in Database Fields with (Almost) Standard SQL,' we introduced the concept of storing formulas in database fields. This article delves into the underlying concept that makes i
5.
by BVegter 3y ago
Thank you for your interest! We'll make sure to keep you in the loop about any new articles we post on our website about Colbert if you subscribe on our mail-form at https://www.colbert.nl/mail-form/
6.
by BVegter 3y ago
With 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. Fu
7.
by BVegter 3y ago
Apparently, people are shocked by the title 'Execute formulas stored in database fields', which they associate with bad experiences involving scripting, SQL generation, stored procedures, SQL injections, and other vulnerabilities.
8.
Execute formulas stored in database fields with almost standard SQL(colbert.nl)
22 points by BVegter 3y ago|21 comments