Databases - calculated column types #60

New Issue

garrettmills · 2021-01-14T01:29:51Z

garrettmills commented

2021-01-14 01:29:51 +00:00

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.

garrettmills added the

Scope: Plugins

Feature Request

Scope: Databases

labels 2021-01-14 01:29:51 +00:00

Sign in to join this conversation.