Databases - calculated column types #60

Open
opened 3 years ago by garrettmills · 0 comments
Owner

Add 2 types of calculated columns:

Basic Equation Column

This will use a basic compiled equation to calculate the value of a cell. Should be able to interpolate other columns into the equation. Do NOT use eval for this. Not sure whether calculations should be evaluated on server-side or client-side, so write the code for evaluating them very generally so it can be ported over.

Plugin Calculated Column

Using the plugins system, allow the user to specify a plugin node that will be used to calculate the given column. For the plugin tag, use something like system.database.{database id}.column.{column id}.calculated.

This plugin should provide the database ID and row data. The value of the cell is what is returned by the plugin.

Add 2 types of calculated columns: ## Basic Equation Column This will use a basic compiled equation to calculate the value of a cell. Should be able to interpolate other columns into the equation. Do NOT use eval for this. Not sure whether calculations should be evaluated on server-side or client-side, so write the code for evaluating them very generally so it can be ported over. ## Plugin Calculated Column Using the plugins system, allow the user to specify a plugin node that will be used to calculate the given column. For the plugin tag, use something like `system.database.{database id}.column.{column id}.calculated`. This plugin should provide the database ID and row data. The value of the cell is what is returned by the plugin.
Sign in to join this conversation.
Loading…
There is no content yet.