Hi!
2015-09-18 19:09 GMT+03:00 Dancer New <dancerfan2015@gmail.com>:
> I use Dancer::Plugin::Database in my application. Each time when
> $dbh = DBI->connect( $c->{ dsn }, $c->{ username }, $c->{ password}, $c->{
> dbi_params })
> is called. does it return a new connection?
Yes, it does. But then is no point to use Dancer::Plugin::Database at all.
database will return a connected database handle;
the first time it is called, the plugin will establish a connection to
the database, and return a reference to the DBI object. On subsequent
calls, the same DBI connection object will be returned, unless it has
been found to be no longer usable (the connection has gone away), in
which case a fresh connection will be obtained."
> I would like one db connection for each user, where can I save the database
> handler?
Could you elaborate, why every user must have their own connection? It
does not seem reasonable. Using just one connection over the
application is much cheaper way. When using Dancer::Plugin::Database
you must set up connection data in config file.