« Changelog History


Sequel v4.10.0 Release Notes

Release Date: 2014-05-01 // almost 10 years ago

    • 👉 Make Model.include API same as Module.include (ged) (#803)

    • Dataset::PlaceholderLiteralizer now handles DelayedEvaluations correctly (jeremyevans)

    • 🔨 Refactor type conversion in the jdbc adapter, for up to a 20% speedup (jeremyevans)

    • Add Dataset#with_fetch_size to jdbc adapter, for setting fetch size for JDBC ResultSets (jeremyevans)

    • 0️⃣ Default to a fetch_size of 100 in the jdbc/oracle adapter, similar to the oci8-based oracle adapter (jeremyevans)

    • Add Database#fetch_size accessor and :fetch_size option to jdbc adapter, for setting JDBC Statement fetch size (jeremyevans)

    • Automatically determine array type in pg_array_associations plugin, explicitly cast arrays in more places (jeremyevans, maccman) (#800)

    • Speed up Dataset#literal for symbols 60% by caching results, speeding up dataset literalization up to 40% or more (jeremyevans)

    • Speed up Sequel.split_symbol 10-20x by caching results, speeding up dataset literalization up to 80% or more (jeremyevans)

    • Speed up dataset literalization for simple datasets by up to 100% (jeremyevans)

    • 👌 Support :fractional_seconds Database option on MySQL 5.6.5+ to support fractional seconds by default (jeremyevans) (#797)

    • ↪ Work around MySQL 5.6+ bug when combining DROP FOREIGN KEY and DROP INDEX in same ALTER TABLE statement (jeremyevans)

    • 🔌 Make auto_validations plugin handle models that select from subqueries (jeremyevans)

    • Recognize additional disconnect errors in the postgres adapter (jeremyevans)

    • 👉 Make import/multi_insert insert multiple rows in a single query using a UNION on Oracle, DB2, and Firebird (jeremyevans)

    • Speed up association_pks many_to_many setter method by using Dataset#import (jeremyevans)

    • ➕ Add Model.prepared_finder, similar to .finder but using a prepared statement (jeremyevans)

    • Model.def_{add_method,association_dataset_methods,remove_methods} are now deprecated (jeremyevans)

    • Model.eager_loading_dataset and Model.apply_association_dataset_opts are now deprecated (jeremyevans)

    • Make prepared_statement_associations plugin handle one_through_one and one_through_many associations (jeremyevans)

    • 👉 Use placeholder literalizer for regular association loading for up to 85% speedup (jeremyevans)

    • 👉 Use placeholder literalizer for eager association loading for up to 20% speedup (jeremyevans)

    • Make Model#marshallable! work correctly when using the tactical_eager_loading plugin (jeremyevans)

    • Respect :foreign_key_constraint_name option when adding columns to existing table on MySQL (noah256) (#795)

    • AssociationReflection#association_dataset now handles joining tables if necessary (jeremyevans)

    • Support drop_view :if_exists option on SQLite, MySQL, H2, and HSQLDB (jeremyevans) (#793)

    • Support drop_table :if_exists option on HSQLDB (jeremyevans)

    • ➕ Add Database#transaction :auto_savepoint option, for automatically using a savepoint in nested transactions (jeremyevans)

    • ➕ Add :server_version Database option on Microsoft SQL Server, instead of querying the database for it (jeremyevans)

    • Support :correlated_subquery as an eager_graph and filter by associations limit strategy for one_to_* associations (jeremyevans)

    • Support named paramters in call_mssql_sproc on Microsoft SQL Server (y.zemlyanukhin, jeremyevans) (#792)

    • 🖐 Handle placeholder literalizer arguments when emulating offsets (jeremyevans)

    • Don't attempt to emulate offsets if the dataset uses literal SQL (jeremyevans)

    • 0️⃣ Use a UNION-based strategy by default to eagerly load limited associations (jeremyevans)

    • 👌 Support offsets without limits on MySQL, SQLite, H2, SQLAnywhere and CUBRID (jeremyevans)

    • ✂ Remove the install/uninstall rake tasks (jeremyevans)

    • 👉 Use INSERT VALUES with multiple rows for Dataset#import and #multi_insert on more databases (jeremyevans)

    • 👌 Support common table expressions (WITH clause) on SQLite >=3.8.3 (jeremyevans)