0.36.0

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 strftime(format, timevalue, modifiers...) date formatting filter and API rules function. It works similarly to the SQLite strftime builtin function with the main difference that NULL results will be normalized for consistency with the non-nullable PocketBase text and date fields. Multi-match expressions are also supported and works the same as if the collection field is referenced, for example:

  // requires ANY/AT-LEAST-ONE-OF multiRel records to have "created" date matching the formatted string "2026-01"
  strftime('%Y-%m', multiRel.created) ?= '2026-01'
  
  // requires ALL multiRel records to have "created" date matching the formatted string "2026-01"
  strftime('%Y-%m', multiRel.created) = '2026-01'
  

• ⚠️ Minor changes to the search.ResolverResult struct (mostly used internally):

  • Replaced NoCoalesce field with the more explicit NullFallback (NullFallbackDisabled is the same as NoCoalesce:true).
  • Replaced the expression interface of the MultiMatchSubQuery field with the concrete struct type search.MultiMatchSubquery to avoid excessive type assertions and allow direct mutations of the field.

• Updated modernc.org/sqlite to v1.44.1 (SQLite 3.51.1).

• Bumped min Go GitHub action version to 1.25.6 because it comes with some minor security fixes.