aep000/reactivedb

Database that allows you to model derived data transforms

reactivedb's Issues

Testing Suite

Be able to test transforms and actions on deployment

Clients

• Rust
• Python
• JavaScript/TypeScript

Updating

Primary complication is having a way to identify the derived table entries resulting from an updated source.

Solution
Id field in every table and source_id field in derived tables that can be used on update. This becomes a problem with unions.

Custom search for array EntryValues?

When deleting, if you attempt to delete all with an empty root an error is raised

Actions

"Serverless" style actions that can be executed from an HTTP api.

In addition actions will be the super set of a future API generation function

Aggregations

Enable the aggregation of rows by a given column

• Expensive Aggregations (Re-Calc every time)
• Memoization
• Special Functions

Listening

Confirmed features:

• Listen for new and updated entries
• Listen for deletes
• Condition Listens

Unconfirmed features:

• Composing multiple listen queries into one

Caching

Currently caching datablocks without cache size limit. Completed version will have a configurable upperbound

There are additional opportunities for caching at other levels in the DB (Btree and table)

Dynamic table updating

This would be the ability to create new tables outside of a config.