title: how do I create a database with sequel
body: <p>I've read all <a href="https://github.com/jeremyevans/sequel">sequel</a>'s docs, but I could not find a way to create a database, assuming that I can do that.</p>
  
  <p>I'm running a rake task as such:</p>
  
  <pre><code>require 'rubygems'
  require 'bundler/setup'
  
  require 'pg'
  require 'sequel'
  
  require 'yaml'
  require 'erb'
  
  
  namespace :db do
  
    task :connect do
  
    end
  
  
    task :create =&gt; :connect do
  
      puts db_config
  
      Sequel.connect(db_config['production']){ |db|
  
        db.create_table :user do
          primary_key :id
  
          String :name
          String :email
  
        end
  
        user = db[:user]
  
  
        user.insert(:name =&gt; 'Roland', :email =&gt; 'rolandjitsu@gmail.com')
      }
  
    end
  
    task :drop =&gt; :connect do
  
    end
  
  end
  
  def db_config
    YAML.load(ERB.new(File.read('config/database.yml')).result)
  end
  </code></pre>
  
  <p>But obviously that will not create the database if it does not exist, so I am a bit unsure what I can do about it. When I run the task I get:</p>
  
  <pre><code>PG::ConnectionBad: FATAL:  database "pulsr" does not exist
  </code></pre>
  
  <p>And the <code>database.yml</code> file:</p>
  
  <pre><code>production: &amp;production
    adapter: postgres
    host: localhost
    encoding: unicode
    database: pulsr
    username:
    password:
  
  development:
    &lt;&lt;: *production
  </code></pre>
  
  <p>Does anyone know what I can do to create the database? Will that be a manual process as starting the postgresql server?</p>