Ruby Sequel Blob datatype

001_msoffice_files.rb

Sequel.migration do
  up do
    create_table(:office_files) do
      primary_key :id
      column :uuid, 'uniqueidentifier'
      String :name
      Date :created_at
      File :file  # datatype File = blob
    end
  end

  down do
    drop_table(:office_files)
  end
end

office_file.rb

class OfficeFile < Sequel::Model(DB)
  plugin :uuid, :field => :uuid
  plugin :timestamps
end

Rakefile

desc 'upload a file'
task :upload do
  record        = OfficeFile.new
  record.name   = 'some_file.docx'
  record.file   = File.read('some_file.docx', :binmode => true)  # important: binmode must be true
  record.save
end

desc 'download a file'
task :download do
  record = OfficeFile.where(:name => 'some_file.docx').first
  bin_stream = record.file
  File.open('./tmp/download.docx', 'w') { |f| f.write(bin_stream) }
end