Re: POE and DBI database question

On Feb 17, 2011, at 3:07 PM, Markus Jansen wrote:

> Hi POE experts,
>  
> is there someone who has used POE in an asynchronous way with DBI, without the necessity to reinvent the wheel,
> with some example or recipe at hand?
>  
> To illustrate my problem:
> PoCo::SimpleDBI looks nice, but I am not too sure how well this behaves inside a forking environment (prefork server).
> DBIx::Connector claims to be great on the prefork matter, but I don't see an asynchronous POE example or recipe somewhere.
> DBIx::Class claims to be even greater for non-SQL addicts, and seems to have some code in common with DBIx::Connector,
> but again I fail how to integrate that best into a POE environment ...

The best DBI interface for POE is PoCo::EasyDBI in my opinion.  Unfortunately you won't be able to use an ORM like DBIx::Class though, you will have to deal with raw SQL.