With Belle Nuit Relation, you create relations by importing (CSV, TAB, JSON) or on the fly, then you process them and then you export them. You can visualize steps of the process in the notebook.
|Create relation||insert, data, read, import|
|Process relation||select, project, rename, extend, parse|
|Combine relations||join, union, difference, serialize, deserialize|
|Prepare for output||order, limit|
|Visualize||echo, format, print|
A relation is a sequence of the above instructions. The execution is linear with a stack machine, but each step is executed on a entire relation, therefore a double loop on row and columns.
The linear sequence is sometimes limiting. Relation provides therefore also structures to go further.
|function||define custom functions to extend the built in functions|
|aggregator||define custom aggregators to extend the built in aggregators in project|
|program||encapsulate and use parameters with a sequence of instructions|
|set||define global values and assign inside functions, aggregators and programs|
|if||conditional execution (only inside functions and aggregators)|
|while||conditional loop (only inside functions and aggregators)|
|dup, pop, swap||stack operators|