Thanks again Jeremy for your diligence in developing Sequel. Your efforts
are much appreciated!
On Thursday, August 1, 2013 12:02:52 PM UTC-4, Jeremy Evans wrote:
>
> Sequel 4.1.0 has been released!
>
> = New Features
>
> * Database#run and #<< now accept SQL::PlaceholderLiteralString
> objects, allowing you to more easily run arbitrary DDL queries with
> placeholders:
>
> DB.run Sequel.lit("CREATE TABLE ? (? integer)", :table, :column)
>
> * You can now provide options for check constraints by calling the
> constraint/add_constraint methods with a hash as the first argument.
> On PostgreSQL, you can now use the :not_valid option for check
> constraints, so they are enforced for inserts and updates, but
> not for existing rows.
>
> DB.create_table(:table) do
> ...
> constraint({:name=>:constraint_name, :not_valid=>true}) do
> column_name > 10
> end
> end
>
> * Dataset#stream has been added to the mysql2 adapter, and will have
> the dataset stream results if used with mysql2 0.3.12+. This
> allows you to process large datasets without keeping the entire
> dataset in memory.
>
> DB[:large_table].stream.each{|r| ...}
>
> * Database#error_info has been added to the postgres adapter. It
> is supported on PostgreSQL 9.3+ if pg-0.16.0+ is used as the
> underlying driver, and it gives you a hash of metadata related
> to the exception:
>
> DB[:table_name].insert(1) rescue DB.error_info($!)
> # => {:schema=>"public", :table=>"table_name", :column=>nil,
> :constraint=>"constraint_name", :type=>nil}
>
> * The :deferrable option is now supported when adding exclusion
> constraints on PostgreSQL, to allow setting up deferred exclusion
> constraints.
>
> * The :inherits option is now supported in Database#create_table on
> PostgreSQL, for table inheritance:
>
> DB.create_table(:t1, :inherits=>:t0){}
> # CREATE TABLE t1 () INHERITS (t0)
>
> * Dataset#replace and #multi_replace are now supported on SQLite,
> just as they have been previously on MySQL.
>
> * In the jdbc adapter, Java::JavaUtil::HashMap objects are now
> converted to ruby Hash objects. This is to make it easier to
> handle the PostgreSQL hstore type when using the jdbc/postgres
> adapter.
>
> * The odbc adapter now supports a :drvconnect option that accepts
> an ODBC connection string that is passed to ruby-odbc verbatim.
>
> = Other Improvements
>
> * The prepared_statements plugin no longer breaks the
> instance_filters and update_primary_key plugins.
>
> * Dropping indexes for tables in a specific schema is now supported
> on PostgreSQL. Sequel now explicitly specifies the same schema
> as the table when dropping such indexes.
>
> * Calling Model#add_association methods with a primary key value
> now raises a Sequel::NoMatchingRow if there is no object in the
> associated table with that primary key. Previously, this
> situation was not handled and resulted in a NoMethodError being
> raised later.
>
> * When an invalid virtual row block function call is detected, an
> error is now properly raised. Previously, the error was not
> raised until the SQL was produced for the query.
>
> = Backwards Compatibility
>
> * The :driver option to the odbc adapter is deprecated and will be
> removed in a future version. It is thought to be broken, and
> users wanting to use DSN-less connections should use the new
> :drvconnect option.
>
> * The Postgres::ArrayOp#text_op private method has been removed.
>
> Thanks,
> Jeremy
>
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.
