To update the prebuilt executable you can run ./pocketbase update.

• List query and API rules optimizations:

  • Removed unnecessary correlated subquery expression when using back-relations via single relation field.
  • Replaced DISTINCT with GROUP BY id when rows deduplication is needed and when deemed safe. This should help with having a more stable and predictable performance even if the collection records are on the larger side.

  For some queries and data sets the above 2 optimizations have shown significant improvements but if you notice a performance degradation after upgrading, please open a Q&A discussion with export of your collections structure and the problematic request so that it can be analyzed.

• Added date formatting filter and API rules function. It works similarly to the with the main difference that NULL results will be normalized for consistency with the non-nullable PocketBase and fields. Multi-match expressions are also supported and works the same as if the collection field is referenced, for example: