The Database Toolkit for Ruby

Documentation for Sequel (v5.40.0)

General Info, Guides, Examples, and Tutorials

• General Overviews
  • README (Introduction to Sequel, start here if new)
  • Security
  • Cheat Sheet
  • Sequel for SQL Users
  • Sequel Object Model
• Databases
  • Connecting to a Database
  • Database Transactions
  • Schema Modification
  • Migrations
  • Primary/Replica Database Configurations and Sharding
  • PostgreSQL Specific Support
  • Microsoft SQL Server Stored Procedure Support
• Datasets
  • Dataset Basics
  • Dataset Filtering
  • Querying in Sequel
  • Prepared Statements/Bound Variables
  • Virtual Row Blocks
• Models
  • Model Mass Assignment
  • Model Validations
  • Model Hooks
  • Model Dataset Method Design
  • Model Associations Basics and Options
  • Advanced Model Associations
  • Model Plugins
• Misc.
  • Code Order
  • Reflection
  • Thread Safety
  • Fork Safety
  • Testing With Sequel
  • Sequel Extensions
  • Core Extensions
  • bin/sequel

RDoc

• Core/Model, main pages:
  • Sequel (main module)
  • Database
  • Dataset
  • Model
  • Model Class Methods
  • Model Instance Methods
  • Model Association Class Methods
  • Model Eager Loading Methods
• Adapters
• Extensions/Plugins

Change Log

Release Notes

• Sequel 5:
  • 5.40 |
  • 5.39 | 5.38 | 5.37 | 5.36 | 5.35 | 5.34 | 5.33 | 5.32 | 5.31 | 5.30 |
  • 5.29 | 5.28 | 5.27 | 5.26 | 5.25 | 5.24 | 5.23 | 5.22 | 5.21 | 5.20 |
  • 5.19 | 5.18 | 5.17 | 5.16 | 5.15 | 5.14 | 5.13 | 5.12 | 5.11 | 5.10 |
  • 5.9 | 5.8 | 5.7 | 5.6 | 5.5 | 5.4 | 5.3 | 5.2 | 5.1 | 5.0 |
• Sequel 4:
  • 4.49 | 4.48 | 4.47 | 4.46 | 4.45 | 4.44 | 4.43 | 4.42 | 4.41 | 4.40 |
  • 4.39 | 4.38 | 4.37 | 4.36 | 4.35 | 4.34 | 4.33 | 4.32 | 4.31 | 4.30 |
  • 4.29 | 4.28 | 4.27 | 4.26 | 4.25 | 4.24 | 4.23 | 4.22 | 4.21 | 4.20 |
  • 4.19 | 4.18 | 4.17 | 4.16 | 4.15 | 4.14 | 4.13 | 4.12 | 4.11 | 4.10 |
  • 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | 4.2 | 4.1 | 4.0 |
• Sequel 3:
  • 3.48 | 3.47 | 3.46 | 3.45 | 3.44 | 3.43 | 3.42 | 3.41 | 3.40 |
  • 3.39 | 3.38 | 3.37 | 3.36 | 3.35 | 3.34 | 3.33 | 3.32 | 3.31 | 3.30 |
  • 3.29 | 3.28 | 3.27 | 3.26 | 3.25 | 3.24 | 3.23 | 3.22 | 3.21 | 3.20 |
  • 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 |
  • 3.9 | 3.8 | 3.7 | 3.6 | 3.5 | 3.4 | 3.3 | 3.2 | 3.1 | 3.0 |
• Sequel 2: 2.12 | 2.11 | 2.10 | 2.9 | 2.8 | 2.7 | 2.6 | 2.5 | 2.4 | 2.3 | 2.2 | 2.1 | 2.0 |
• Sequel 1: 1.5 | 1.4 | 1.3 | 1.1 | 1.0 |

License

Presentations

• "Sequel: When Active Record is not enough" Presentation at RubyDay 2020
• "Give-and-Go with PostgreSQL and Sequel" Presentation at RubyC 2014 (Video)
• "Deep Dive Into Eager Loading Limited Associations" Presentation at RubyC 2014 (Video)
• "Give-and-Go with PostgreSQL and Sequel" Presentation at RailsClub 2013 (In Russian) (Video, starts about 6:30)
• "The Development of Sequel" Presentation in May 2012 at Heroku
• "Sequel: The Database Toolkit for Ruby" Presentation at PostgreSQL Conference West 2011
• "Sequel: SQL in Ruby" Presentation at Lone Star Ruby Conference 2009
• "Sequel: SQL in Ruby" Presentation at RubyKaigi 2009
• "Sequel: The Database Toolkit for Ruby" Presentation at LA Ruby Conf 2009 (Video)
• "Sequel: The Database Toolkit for Ruby" Presentation at MountainWest RubyConf 2009 (Video) (Transcript)