Skip to content

v4.12.1 - awesome aggregates

Choose a tag to compare

@benjie benjie released this 27 May 11:47
· 13990 commits to main since this release

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)

Bug Fixes

  • explain: fix 'unhandled' promise rejection (#1442) (716efb0)
  • order: fix order by computed column SQL item bug (#741) (0635ecb)
  • uniqueKey/pgViewUniqueKey applies to views (#739) (b715f6d)