Sequel 5.98.0 Released

[jeremyevans]

Sequel 5.98.0 has been released!

New Features

• A pg_auto_parameterize_duplicate_query_detection extension has
  been added. This allows for detection of cases where the same
  SQL query (with potentially different parameters) is being sent
  to the database with the same callstack. This can detect most N+1
  issues when the pg_auto_parameterize extension is used.

  To detect duplicate queries in a block of code, you wrap the code:

    DB.detect_duplicate_queries{your_code} 

  If you are using Sequel in a web application, you can do this in
  a rack middleware to find N+1 issues in your application. Note that
  this may report duplicate queries that you may not consider to be
  problems. To ignore those cases, you can use:

    DB.ignore_duplicate_queries{your_code} 

  By default, the extension will raise an exception for duplicate
  queries. It's possible to warn instead (handler: :warn) or to have
  custom behavior. It's also possible to filter the displayed
  backtraces (backtrace_filter: /\A#{Regexp.escape(Dir.pwd)}/).
  See the plugin documentation for more details.

• Model#remove_key! has been added to remove a key from the instance's
  values. You could previously use values.delete(key), but that
  didn't necessarily work correctly when using the split_values plugin.

• Model.any? has been added, which will call any? on the model's dataset
  instead of Enumerable#any?. This avoids unexpected behavior when using
  the any_not_empty extension.

Other Improvements

• The split_values plugin now supports eager loading associations that
  use join tables (e.g. many_to_many associations).

• The rcte_tree plugin now works correctly when using the split_values
  plugin.

• The insert_returning_select plugin now uses RETURNING * if the model
  uses SELECT table.* FROM table, allowing it to work better with the
  table_select plugin.

• Database#listen in the postgres adapter now ignores all received
  notifications after it sends the UNLISTEN statement, so future calls
  to #listen do not return notifications from a previous call.

• Sequel now recognizes sqlite:filename and amalgalite:filename
  connection strings, treating them like sqlite://filename and
  amalgalite://filename.

Thanks,
Jeremy