# ANN: Sequel 0.2.0.2 Released

**URL:** <https://www.ruby-forum.com/t/ann-sequel-0-2-0-2-released/114079>\
**Category:** Ruby\
**Created:** [September 7, 2007, 5:27pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-2-0-2-released/114079 "2007-09-07T17:27:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ciconia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/71c47a/32.png) [@ciconia](https://www.ruby-forum.com/u/ciconia)\
**Post date:** [September 7, 2007, 5:27pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-2-0-2-released/114079/1 "2007-09-07T17:27:09Z")

</div>

Sequel version 0.2.0.2 has just been released. This release includes a  
number of minor bug fixes and improvements.

# Inserting from subqueries

You can now use datasets as subqueries in insert statements, if your  
database supports this feature:

DB[:items] \<\< DB[:temp\_items].filter(:active =\> true)

#=\> “INSERT INTO items (SELECT \* FROM temp\_items WHERE (active =  
‘t’))”

# Model classes can be reopened

Classes deriving from Sequel::Model() can now be reopened and  
reloaded. This solves a annoyance people had when using Sequel models  
in Camping or Merb applications.

# MySQL adapter accepts charset option

You can now specify the character set in use for MySQL databases:

Sequel(“mysql://localhost/mydb”, :charset =\> ‘UTF-8’)

# Bug fixes and other changes

- Fixed Dataset#exclude to add parens around NOT expression (#38).

- Fixed use of sub-queries with all comparison operators in block  
filters (#38).

- Fixed arithmetic expressions in block filters to not be literalized.

- Changed Symbol#method\_missing to return LiteralString.

- Changed PrettyTable to right-align numbers.

- Fixed Model.create\_table (thanks Duane J…)

=============================================

Sequel project page:  
[http://code.google.com/p/ruby-sequel](http://code.google.com/p/ruby-sequel)

Sequel documentation:  
[http://sequel.rubyforge.org](http://sequel.rubyforge.org)

Join the Sequel-talk group:  
[http://groups.google.com/group/sequel-talk](http://groups.google.com/group/sequel-talk)

Install the gem:  
sudo gem install sequel

Or check out the source and install manually:  
svn co [http://ruby-sequel.googlecode.com/svn/trunk](http://ruby-sequel.googlecode.com/svn/trunk) sequel  
cd sequel  
rake install

---

<div class="post-metadata">

**Author:** ![ciconia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/71c47a/32.png) [@ciconia](https://www.ruby-forum.com/u/ciconia)\
**Post date:** [September 7, 2007, 6:02pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-2-0-2-released/114079/2 "2007-09-07T18:02:13Z")

</div>

Sharon R. wrote:

> Sequel version 0.2.0.2 has just been released. This release includes a  
> number of minor bug fixes and improvements.

Congratulations on the release. I like to hear about new and evolving  
tools on here - but perhaps you might consider announcing regular minor  
bugfix releases through more specialised channels, such as the sequel  
mailing list and/or the rubyforge news feeds?

It’s also nice to read a short summary of a package’s purpose and  
function near the top of announcements.

cheers  
a

---

<div class="post-metadata">

**Author:** ![ciconia](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/71c47a/32.png) [@ciconia](https://www.ruby-forum.com/u/ciconia)\
**Post date:** [September 7, 2007, 10:35pm UTC](https://www.ruby-forum.com/t/ann-sequel-0-2-0-2-released/114079/3 "2007-09-07T22:35:48Z")

</div>

Alex F. wrote:

> Sharon R. wrote:
> 
> > Sequel version 0.2.0.2 has just been released. This release includes a  
> > number of minor bug fixes and improvements.
> 
> Congratulations on the release. I like to hear about new and evolving  
> tools on here - but perhaps you might consider announcing regular minor  
> bugfix releases through more specialised channels, such as the sequel  
> mailing list and/or the rubyforge news feeds?

I like it to see announcements like this on ruby-talk! I don’t want to  
read n other mailing lists. And those announcements are not very  
high-traffic compared to the total number of questions on ruby-talk 🙂

But that’s just my opinion.

Thanks for the release!

Regards,

Michael