title: How can I use an Alternate DB connection in Kohana 3.1
body: <p>If a run the following bit of code from a Kohana 3.1 controller</p>
  
  <pre><code>$query = DB::select("select * from foo");
  $results = $query-&gt;execute();
  foreach($results as $result)
  {
      var_dump($result);
  }
  </code></pre>
  
  <p>Kohana will attempt to connect to the database using information from the array returned by <code>application/config/database.php</code>.  Specifically, if will use the information set in the <strong>default</strong> group.</p>
  
  <pre><code>return array
  (
      'default' =&gt; array
      (
          'type'       =&gt; 'mysql',
          'connection' =&gt; array(
              /**
               * The following options are available for MySQL:
               *
               * string   hostname     server hostname, or socket
               * string   database     database name
               * string   username     database username
               * string   password     database password
               * boolean  persistent   use persistent connections?
               *
               * Ports and sockets may be appended to the hostname.
               */
              'hostname'   =&gt; 'localhost',
              'database'   =&gt; 'kohana',
              'username'   =&gt; FALSE,
              'password'   =&gt; FALSE,
              'persistent' =&gt; FALSE,
  </code></pre>
  
  <p>However, this configuration array accepts multiple top level items (called db-groups, I think). How can/should I tell Kohona 3.1 to make a connection and query using information that's set in a <strong>non-default</strong> db-group.</p>