Zotonic maintenance release 0.68.0

We have released a new Zotonic 0.x version. This is a maintenance release but includes a change to the search functions that has been back ported from the master branch. Read more below and at Release 0.68.0 @ Zotonic

Main changes

  • Change z_search to return estimated number of rows instead of a count
  • New zotonic config ‘filewatcher_terminal_notifier’ to disable desktop notifications
  • Fix a problem in controller_static_pages with handling Unicode filenames
  • Change signup-confirmation to require a click on a button before confirming, this fixes a problem where confirmations could accidently be done.

Search changes

The search routines are now using the query planner to estimate the number of rows.

To support this, the following changes were made:

  • The all field in the #search_result record is now deprecated.
  • In #search_result there is a new flag is_total_estimated. This is set to true if the total was estimated by using the query planner.
  • If the total is estimated then the pager does not show the last page.
  • In the admin the (estimated) total items found is shown below the pager.

With this change some searches will be much faster as the database does not need to count to max 30K rows, like in the pre 0.68.0 implementation.

The 1.x version of Zotonic is also using the query planner to estimate the number of rows, so handling this correctly will help you in moving your site to Zotonic 1.x.