ANN: Sequel 3.19.0 Released

Discussion in 'Ruby' started by Jeremy Evans, Jan 3, 2011.

  1. Jeremy Evans

    Jeremy Evans Guest

    Sequel is a lightweight database access toolkit for Ruby.

    * Sequel provides thread safety, connection pooling and a concise
    DSL for constructing SQL queries and table schemas.
    * Sequel includes a comprehensive ORM layer for mapping records to
    Ruby objects and handling associated records.
    * Sequel supports advanced database features such as prepared
    statements, bound variables, stored procedures, savepoints,
    two-phase commit, transaction isolation, master/slave
    configurations, and database sharding.
    * Sequel currently has adapters for ADO, Amalgalite, DataObjects,
    DB2, DBI, Firebird, Informix, JDBC, MySQL, Mysql2, ODBC, OpenBase,
    Oracle, PostgreSQL, SQLite3, and Swift.

    Sequel 3.19.0 has been released and should be available on the gem
    mirrors.

    = New Features

    * The add_* association methods now accept a primary key, and
    associates the receiver to the associated model object with that
    primary key:

    artist.add_album(42)
    # equivalent to: artist.add_album(Album[42])

    * The validation_class_methods plugin now has the ability to
    reflect on validations:

    Album.plugin :validation_class_methods
    Album.validates_acceptance_of:)a)
    Album.validation_reflections
    # => {:a=>[[:acceptance, {:tag=>:acceptance, :allow_nil=>true,
    :message=>"is not accepted", :accept=>"1"}]]}

    = Other Improvements

    * In the postgres, mysql, and sqlite adapters, typecasting now uses
    methods instead of procs. Since methods aren't closures (while
    procs are), this makes typecasting faster (up to 15%).

    * When typecasting model column values, the classes of the new and
    existing values are checked in addition to the values themselves.
    Previously, if the new and existing values were equal (i.e. 1.0
    and 1), it wouldn't update the value. Now, if the classes are
    different, it always updates the value.

    * Date and DateTime objects are now handled correctly when using
    prepared statements/bound variables in the jdbc adapter.

    * Date, DateTime, Time, true, false, and SQL::Blob objects are now
    handled correctly when using prepared statements/bound variables
    in the sqlite adapter.

    * Sequel now uses varbinary(max) instead of image for the generic
    File (blob) type on Microsoft SQL Server. This makes it possible
    to use an SQL::Blob object as a prepared statement argument.

    * Sequel now handles blobs better in the Amalgalite adapter.

    * When disconnecting a connection using the sqlite adapter, all
    open prepared statements are now closed first. Previously,
    attempting to disconnect a connection with open prepared statements
    resulted in an error.

    * The license file has been renamed from COPYING to MIT-LICENSE, to
    make it easier to determine at a glance which license is used.

    = Backwards Compatibility

    * Because Sequel switched the generic File type from image to
    varbinary(max) on Microsoft SQL Server, any migrations/schema
    modification methods that used the File type will now result in a
    different column type than before.

    * The MYSQL_TYPE_PROCS, PG_TYPE_PROCS, and SQLITE_TYPE_PROCS
    constants have been removed from the mysql, postgres, and sqlite
    adapters, respectively. The UNIX_EPOCH_TIME_FORMAT and
    FALSE_VALUES constants have also been removed from the sqlite
    adapter.

    * Typecasting in the sqlite adapters now uses to_i and to_f instead
    of Integer() and Float() with rescues. If you put non-numeric
    data in numeric columns on SQLite, this could cause problems.

    Thanks,
    Jeremy

    * {Website}[http://sequel.rubyforge.org]
    * {Source code}[http://github.com/jeremyevans/sequel]
    * {Blog}[http://sequel.heroku.com]
    * {Bug tracking}[http://code.google.com/p/ruby-sequel/issues/list]
    * {Google group}[http://groups.google.com/group/sequel-talk]
    * {RDoc}[http://sequel.rubyforge.org/rdoc]

    --
    Posted via http://www.ruby-forum.com/.
    Jeremy Evans, Jan 3, 2011
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sharon Rosner
    Replies:
    0
    Views:
    129
    Sharon Rosner
    Apr 16, 2007
  2. Sharon Rosner

    ANN: Sequel 0.0.20 Released

    Sharon Rosner, Apr 18, 2007, in forum: Ruby
    Replies:
    0
    Views:
    95
    Sharon Rosner
    Apr 18, 2007
  3. Sharon Rosner

    ANN: Sequel 0.1.0 Released

    Sharon Rosner, Apr 22, 2007, in forum: Ruby
    Replies:
    0
    Views:
    83
    Sharon Rosner
    Apr 22, 2007
  4. Sharon Rosner

    ANN: Sequel 0.1.2 Released

    Sharon Rosner, May 19, 2007, in forum: Ruby
    Replies:
    0
    Views:
    103
    Sharon Rosner
    May 19, 2007
  5. Sharon Rosner
    Replies:
    0
    Views:
    93
    Sharon Rosner
    May 20, 2007
Loading...

Share This Page