<div dir="ltr">on a similar note, should Mysql be built with the -with-thread-safe-client on ?<br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 28, 2015 at 9:16 AM, Andrew Solomon <span dir="ltr"><<a href="mailto:andrew@geekuni.com" target="_blank">andrew@geekuni.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>I'm a bit confused here. When should we use <a href="https://metacpan.org/pod/Dancer2::Plugin::Database" target="_blank">https://metacpan.org/pod/Dancer2::Plugin::Database</a> and when should we use <a href="https://metacpan.org/pod/DBIx::Connector" target="_blank">https://metacpan.org/pod/DBIx::Connector</a> ?<br></div><div><br></div><div>Unless I've missed something it looks as though Dancer2::Plugin::Database doesn't depend on DBIx::Connector - what's the reason for that?</div><div><br></div><div>Andrew</div><div><br></div></div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">On Tue, Apr 28, 2015 at 1:04 AM, Russell Jenkins <span dir="ltr"><<a href="mailto:russell.jenkins@strategicdata.com.au" target="_blank">russell.jenkins@strategicdata.com.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 27/04/2015 3:39 am, Nikos Vaggalis wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Is that indicating a global DBI handle that is reused and cleaned up at some time, having to do with Starman's preforking? The thing is that in my Model I initialize the database and statement handles within the subs scope and not globally.<span><br>
<br>
DBD:mysql 4.031<br>
DBI 1.633<br>
<br>
</span></blockquote>
<br>
If you are doing the database connection management yourself, I strongly suggest you look at DBIx::Connector.<br>
Its fork (and thread) safe, so you don't have to worry about such issues :)<br>
<br>
<br>
Hope that helps,<br>
  Russell.<div><div><br>
<br>
_______________________________________________<br>
dancer-users mailing list<br>
<a href="mailto:dancer-users@dancer.pm" target="_blank">dancer-users@dancer.pm</a><br>
<a href="http://lists.preshweb.co.uk/mailman/listinfo/dancer-users" target="_blank">http://lists.preshweb.co.uk/mailman/listinfo/dancer-users</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div></div></div><span class="HOEnZb"><font color="#888888">-- <br><div><div dir="ltr">Andrew Solomon<div><br></div><div>Mentor@Geekuni <a href="http://geekuni.com/" target="_blank">http://geekuni.com/</a></div><div><a href="http://www.linkedin.com/in/asolomon" target="_blank">http://www.linkedin.com/in/asolomon</a><br></div></div></div>
</font></span></div>
<br>_______________________________________________<br>
dancer-users mailing list<br>
<a href="mailto:dancer-users@dancer.pm">dancer-users@dancer.pm</a><br>
<a href="http://lists.preshweb.co.uk/mailman/listinfo/dancer-users" target="_blank">http://lists.preshweb.co.uk/mailman/listinfo/dancer-users</a><br>
<br></blockquote></div><br></div>