We've finally taken our proof of concept aggregation plugin and fleshed it out with some very significant features: calculating aggregates across connections, grouped aggregates, applying conditions to grouped aggregates, ordering by relational aggregates, filtering by the results of aggregates on related connections, etc.
For more details check out the plugin: https://github.com/graphile/pg-aggregates
This release also includes a few small fixes and some other minor features that enable greater community expansion of PostGraphile. We love seeing your plugins - do share them in our #i-made-this channel on Discord and/or add them to the list on the website!
Features
- middleware: add a
release()function (experimental) (#1396) (818dad6) - utils: support for NULLS FIRST/LAST in orderByAscDesc (#737) (99b1a8e)
- pg: connections can use named queries (#715) (352dab3)
- pg: makeProcField can be used to construct aggregates (#714) (8e0102b)
- pg: procFieldDetails helper (#717) (59a07a2)
- export pgSmartTagRulesFromJSON (#722) (48e07cd)
- hooks: add postgraphile:liveSubscribe:executionResult hook (#1483) (73fe801)