All Versions
Latest Version
Avg Release Cycle
30 days
Latest Release
12 days ago

Changelog History
Page 1

  • v5.27.0

    December 01, 2019
    • ➕ Add Sequel::DEFAULT for a DEFAULT expression, useful for assigning to default values (jeremyevans)

    • Make Postgres::ArrayOp#join in pg_array_ops extension work correctly on PostgreSQL <9.1 (jeremyevans)

    • 👉 Make pg_enum extension work correctly on PostgreSQL 8.3-9.0 (jeremyevans)

    • 👍 Emulate FILTER clause for aggregate functions using CASE on databases not supporting it directly (jeremyevans)

    • 👌 Support ordering by NULLS FIRST/NULLS LAST without emulation on SQLite 3.30+ (jeremyevans)

  • v5.26.0

    November 01, 2019
    • Recognize two additional foreign key constraint violation codes on MySQL 8.0.13+ (rianmcguire) (#1657)

    • 👌 Support table aliases for single-table INSERT statements on PostgreSQL 9.5+ (jeremyevans) (#1656)

    • Implement Sequel::Postgres::PGRange#hash so instances work correctly in hashes (jeremyevans) (#1648)

    • Make dirty plugin work correctly with typecast_on_load plugin (jeremyevans) (#1647)

    • Add support for :require_modification option when setting up nested_attributes (jeremyevans)

    • Add support for SQL/JSON path expressions to the pg_json_ops extension, supported by PostgreSQL 12+ (jeremyevans)

  • v5.25.0

    October 01, 2019
    • 🛠 Fix Sequel::SQL::NumericMethods#coerce to not raise NoMethodError if super method is not defined (jeremyevans) (#1645)

    • 👍 Allow setting a default for a column that already has a default on Microsoft SQL Server (jeremyevans)

    • 🛠 Fix keyword argument separation warnings on Ruby master branch in csv_serializer plugin (jeremyevans)

    • Add association_multi_add_remove plugin for adding/removing multiple associated objects in a single method call (AlexWayfer, jeremyevans) (#1641, #1643)

    • 🔌 Make sharding plugin integrate with server_block extension (jeremyevans)

  • v5.24.0

    September 01, 2019
    • ➕ Add Database#skip_logging? private method designed for extensions to force query timing even if no logger is present (adam12) (#1640)

    • 👍 Allow a hostname specified in a defaults_file in the mysql2 adapter, by not explicitly setting :host (sapio-bdeamer) (#1638)

    • 💎 Convert all database array types to Ruby arrays in the jdbc adapter (jeremyevans)

    • Add static_cache_cache plugin for caching rows for static_cache models to a file to avoid database queries during model initialization (jeremyevans)

    • 🔌 Add :cache_file plugin option to pg_auto_constraint_validations plugin, for caching metadata to a file for faster initialization (jeremyevans)

    • Support :unique_deferrable and :primary_key_deferrable column options (jeremyevans)

    • Support :generated_always_as column option on PostgreSQL 12+ (jeremyevans)

  • v5.23.0

    August 01, 2019
    • 0️⃣ Work around a bug on jdbc-sqlite3 when parsing schema for tables with columns with default values (jeremyevans)

    • Work around a bug in jdbc-sqlite3 when in Database#foreign_key_list in the jdbc/sqlite3 adapter (jeremyevans)

    • Make Dataset#execute* private methods respect explicit servers option, fixing Dataset#paged_each in the postgres adapter when sharding (jeremyevans) (#1632)

    • 🖐 Handle instances of subclasses of core classes when wrapping objects in the pg_json extension (jeremyevans) (#1631)

    • 👌 Support :ansi Database option in the tinytds adapter (kenaniah) (#1629)

    • 👌 Support cross-database and linked servers when parsing schema on Microsoft SQL Server (kenaniah) (#1629)

    • ➕ Add insert_conflict plugin for automatically handling unique constraint conflicts when saving new model instances on PostgreSQL 9.5+ and SQLite 3.24.0+ (jeremyevans)

    • 🤡 Avoid errors when parsing schema in the mock sqlite adapter (jeremyevans)

    • 👍 Avoid possible thread-safety issue in the timezones support (jeremyevans)

    • 🖐 Handle offsets when typecasting an array or hash to datetime when Sequel.datetime_class = Time (jeremyevans)

    • Support Sequel.datetime_class = Time when using the named_timezones extension (jeremyevans)

  • v5.22.0

    July 01, 2019
    • Fix Dataset#multi_insert and #import with return: :primary_key on MSSQL when the dataset has a row_proc (jeremyevans) (#1627)

    • 👌 Support Dataset#with :materialized option on PostgreSQL 12 for [NOT] MATERIALIZED (jeremyevans)

    • Make Database#primary_key_sequence work on tables without serial sequences on PostgreSQL 12 (jeremyevans)

    • 👌 Support ruby 2.7+ startless ranges in the pg_range extension (jeremyevans)

    • 👌 Support ruby 2.7+ startless, endless ranges in filters, using an always true condition for them (jeremyevans)

    • 👌 Support ruby 2.7+ startless ranges in filters, using just a <= or < operator for them (jeremyevans)

  • v5.21.0

    June 01, 2019
    • Recognize additional DatabaseLockTimeout errors in mysql and mysql2 adapters (jeremyevans)

    • Disallow eager_graph of ancestors and descendants associations when using the rcte_tree plugin (jeremyevans)

    • 💎 Make jdbc/mysql adapter work when using JRuby with Java 11 (jeremyevans)

    • 👌 Support window function options :window, :exclude, and :frame :type=>:groups, :start, and :end on SQLite 3.28.0+ (jeremyevans)

    • Make the server_block extension respect the :servers_hash Database option (jeremyevans)

    • Typecast string input for json/jsonb types as JSON strings instead of parsing as JSON in the pg_json extension when Database#typecast_json_strings is set to true (jeremyevans)

    • Wrap JSON primitives (string, number, true, false, nil) in the pg_json extension when Database#wrap_json_primitives is set to true (jeremyevans)

    • ⏱ Convert the Database :timeout option to an integer in the sqlite adapter (jeremyevans) (#1620)

    • 👌 Improve performance in ado adapter using more efficient inner loop (jeremyevans)

    • 👌 Improve performance in ado adapter using faster callables for type conversion (jeremyevans)

    • 🛠 Fix handling of decimal values in the ado adapter when using locales where the decimal separator is , and not . (jeremyevans) (#1619)

  • v5.20.0

    May 01, 2019
    • Fix reversing of alter_table add_foreign_key when :type option is used (jeremyevans) (#1615)

    • Switch from using instance_exec to define_method for model associations and in some plugins (jeremyevans)

    • 🛠 Fix Database#server_version when using mysql2 adapter with mysql driver on MariaDB 10+ database (v-kolesnikov) (#1614)

    • Make one_to_one setter method handle models that use joined datasets (jeremyevans) (#1612)

    • 🔌 Make auto_validations plugin work with the class_table_inheritance plugin (jeremyevans) (#1611)

    • Avoid use of instance_exec for PlaceholderLiteralString#with_dataset (jeremyevans)

    • Recognize float unsigned database types as float (keeguon, jeremyevans) (#1609)

    • Support :savepoint options to Database#{after_commit,after_rollback} for making the hooks handle savepoints (jeremyevans)

    • Avoid use of instance_exec in association_dependencies plugin (jeremyevans)

    • Add pg_auto_constraint_validation_override to the pg_auto_constraint_validations plugin, for customizing columns and error message per constraint (jeremyevans)

    • 👉 Make Database#check_constraints on PostgreSQL also include constraints where the related columns are not known (jeremyevans)

  • v5.19.0

    April 02, 2019
    • ⚡️ Use more optimized approach to merging hashes in ruby 2.5+ (jeremyevans)

    • 💎 Use SQLite extended result codes when using ruby-sqlite3 1.4.0+ (jeremyevans)

    • Recognize additional SQLite extended result codes in the shared sqlite adapter (jeremyevans)

    • Add Database#rename_enum_value to the pg_enum extension (AlexWayfer) (#1603)

    • 📇 Make Database#drop_table delete constraint validations metadata for that table if using the constraint_validations extension (jeremyevans)

    • Speed up row fetching in the sqlite adapter (jeremyevans)

    • Speed up row fetching and type conversion in the sqlanywhere adapter (jeremyevans)

  • v5.18.0

    March 01, 2019
    • 👉 Use singleton .call methods on plain objects instead of procs/methods for faster type conversion (jeremyevans)

    • ➕ Add to avoid indirection when converting values from the database (jeremyevans)

    • 🐎 Use while instead of each for inner loops in sqlite and jdbc adapters for better performance (jeremyevans)

    • 🔌 Make after_initialize plugin not make the argument to optional (jeremyevans)

    • 👍 Allow Dataset#paged_each to be called without a block in the postgres and mysql2 adapters (jeremyevans)

    • Remove flow-control exceptions in connection_expiration and connection_validator extensions (jeremyevans)

    • ➕ Add throw_failures plugin for throwing ValidationFailed and HookFailed exceptions instead of raising them, up to 10x performance increase on JRuby (jeremyevans)

    • 👌 Support tzinfo 2 in addition to tzinfo 1 in the named_timezones extension (jeremyevans) (#1596)