Are there limitations in mysqli that make it unsuitable for use with AMP or ReactPHP?

Question

I've seen that libraries such as amphp/mysql and friends-of-reactphp/mysql implement the low-level MySQL protocol, and do not rely on any built-in extension.

Given that mysqli supports async queries, is there any reason why these async libraries cannot be based on mysqli?

_{Originally asked as Why isn't amphp/mysql based on mysqli? (closed).}

score 2 · Accepted Answer · answered Dec 29 '19 at 13:11

2

Hey ReactPHP core team member here. In short you shouldn't use them (you always can but we strongly advise against it) because their I/O isn't hooked into our event loop. Meaning it can block the entire loop and everything hooked into it until it's done with what ever it does.

answered Dec 29 '19 at 13:11

WyriHaximus

1,000
6
8

Thank you, this is pretty much the answer I got from AMP, too! – BenMorel Dec 29 '19 at 13:21

BenMorel · Answer 2 · 2019-12-29T13:22:06.180

1

Courtesy @bwoebi on amphp/mysql's GitHub:

mysqli_poll() is just polling... mysql. It does not provide you any possibility to poll any other streams together with the mysql data. There's no underlying file descriptors exposed by mysqli which the event loop could use.

edited Dec 29 '19 at 13:22

answered Dec 29 '19 at 13:01

BenMorel

34,448
50
182
322

Are there limitations in mysqli that make it unsuitable for use with AMP or ReactPHP?

2 Answers2