Re: [dancer-users] how to make sure one db connection per user

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.

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. Wbr, -- Kõike hääd, Gunnar