[ANN] project-m36 v1.0.1 now available

1 view
Skip to first unread message

A.M.

unread,
Jul 14, 2024, 11:49:50 AM7/14/24
to proje...@googlegroups.com
Hello List!

Project:M36 v1.0.1 adds support for aggregate functions which can be
applied to relations with more than one attribute. The new TutorialD
syntax supports referencing attributes of subrelations. For example:

TutorialD (master/main): :showexpr (s group ({all but city} as
g):{city_total:=sum(@g.status)}){city,city_total}
┌──────────┬───────────────────┐
│city::Text│city_total::Integer│
├──────────┼───────────────────┤
│"Athens" │30 │
│"London" │40 │
│"Paris" │40 │
└──────────┴───────────────────┘

looks very much like the result of a common SQL aggregation grouped by city.

To update to v1.0.1 via docker:

docker pull projectm36/project-m36:latest

Thanks for using Project:M36!

Cheers,
M
OpenPGP_signature
Reply all
Reply to author
Forward
0 new messages